Sample Header Ad - 728x90

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