Database / Search-Index recommendation: Match time ranges from different categories
0
votes
1
answer
45
views
* 300k+ videos
* 10+ millions of markers, pointing to timeranges in videos
{
"markerCategory": "something",
"markerDesc": "something-more-specific",
"frameIn": 120001,
"frameOut": 140002
},
{
"markerCategory": "something-else",
"markerDesc": "something-else-more-specific",
"frameIn": 130001,
"frameOut": 135002
}
Any Suggestions which database / search-index would perform best,
when searching for something along these lines:
> Videos having events of category A
__AND__ category B
in overlapping timeranges,
sorted by amount of covered time
Videos are currently exported from some proprietary relational database and stored in an Apache SOLR instance for searching.
* Is there a specific name for those kind of queries ("inverted range queries" or some thing like that...) ?
* Any Suggestions which technology would perform best, for those types of queries?
I was thinking maybe elasticsearch?
Asked by gherkins
(103 rep)
Mar 6, 2025, 06:45 AM
Last activity: Mar 6, 2025, 01:08 PM
Last activity: Mar 6, 2025, 01:08 PM