Relevance Queries for Interval Data
Panagiotis Bouros, Nikos Mamoulis
Abstract
A wide range of applications manage large collections of interval data. For instance, temporal databases manage validity intervals of objects or versions thereof, while in probabilistic databases attribute values of records are associated with confidence or uncertainty intervals. The main search operation on interval data is the retrieval of data intervals that intersect (i.e., overlap with) a query interval (e.g., find records which were valid in September 2020, find temperature readings with non-zero probability to be within [24, 26] degrees). As query results could be many, we need mechanisms that filter or order them based on how relevant they are to the query interval. We define alternative relevance scores between a data and a query interval based on their (relative) overlap. We define relevance queries, which compute only a subset of the most relevant intervals that intersect a query. Then, we propose a framework for evaluating relevance queries that can be applied on popular domain-partitioning interval indices (interval tree and HINT). We present experiments on real datasets that demonstrate the efficiency of our framework over baseline approaches.
Ask about this paper
Your agent reads all of it.
Lune indexed this paper to the last equation, along with the top-tier papers that cite it. Ask a question and the answer quotes them.
Your agent calls
Luneget_paper_fulltext
Free to start. No credit card required.
Terminal
Install the CLIlune papers fulltext 099d7c7b-7d3d-4197-a0ba-e266296340b0Builds on4
- Raster Intervals: An Approximation Technique for Polygon Intersection JoinsThanasis Georgiadis, Nikos MamoulisSIGMOD 2023 · 21 citations
- HINT: A Hierarchical Index for Intervals in Main MemoryGeorge Christodoulou, Panagiotis Bouros, Nikos MamoulisSIGMOD 2022 · 17 citations
- LIT: Lightning-fast In-memory Temporal IndexingGeorge Christodoulou, Panagiotis Bouros, Nikos MamoulisSIGMOD 2024 · 10 citations
- Independent Range Sampling on Interval DataDaichi AmagataICDE 2024 · 9 citations
Related papers
- Fast Indexing for Temporal Information RetrievalChristian Rauch, Panagiotis BourosSIGMOD 2026 · 3 citations
- Efficient Temporal Subgraph Management: A New Interval IndexDian Ouyang, Yikun Wang, Dong Wen, Wenjie Zhang et al.VLDB 2026
- FIRAS: A Framework for Interval Range Search and SamplingDaichi Amagata, Panagiotis Simatis, Panagiotis Bouros, Nikos MamoulisSIGMOD 2026 · 4 citations
- Salvaging failing and straggling queriesBruhathi Sundarmurthy, Harshad Deshmukh, Paris Koutris, Jeffrey F. NaughtonICDE 2022
- Preferences on a Budget: Prioritizing Document Pairs when Crowdsourcing Relevance JudgmentsKevin Roitero, Alessandro Checco, Stefano Mizzaro, Gianluca DemartiniWWW 2022 · 7 citations
