Threshold Queries in Theory and in the Wild
Angela Bonifati, Stefania Dumbrava, George Fletcher, Jan Hidders, Matthias Hofer, Wim Martens, Filip Murlak, Joshua Shinavier, Slawek Staworko, Dominik Tomaszuk
Abstract
Threshold queries are an important class of queries that only require computing or counting answers up to a specified threshold value. To the best of our knowledge, threshold queries have been largely disregarded in the research literature, which is surprising considering how common they are in practice. In this paper, we present a deep theoretical analysis of threshold query evaluation and show that thresholds can be used to significantly improve the asymptotic bounds of state-of-the-art query evaluation algorithms. We also empirically show that threshold queries are significant in practice. In surprising contrast to conventional wisdom, we found important scenarios in real-world data sets in which users are interested in computing the results of queries up to a certain threshold, independent of a ranking function that orders the query results by importance.
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.
Cited by top-tier papers2
- Relational Algorithms for Top-k Query EvaluationQichen Wang, Qiyao Luo, Yilei WangSIGMOD 2024 · 5 citations
- Exploring Exploratory QueryingMarcelo Arenas, Enrico Franconi, Janik Hammerer, Olaf Hartig et al.VLDB 2025
Builds on4
- Optimal Algorithms for Ranked Enumeration of Answers to Full Conjunctive QueriesNikolaos Tziavelis, Deepak Ajwani, Wolfgang Gatterbauer, Mirek Riedewald et al.VLDB 2020 · 45 citations
- A Structured Review of Data Management Technology for Interactive Visualization and AnalysisLeilani Battle, Carlos ScheideggerIEEE VIS 2020 · 40 citations
- Pushing Data-Induced Predicates Through Joins in Big-Data ClustersLaurel J. Orr, Srikanth Kandula, Surajit ChaudhuriVLDB 2020 · 35 citations
- When is approximate counting for conjunctive queries tractable?Marcelo Arenas, Luis Alberto Croquevielle, Rajesh Jayaram, Cristian RiverosSTOC 2021 · 1 citation
Related papers
- Cardinality Estimation for Having-ClausesGuido MoerkotteVLDB 2025
- Window Function Optimization: Co-Evaluation and Other TechniquesDaniel Lindner, Felix Naumann, Alberto LernerVLDB 2026
- SimTab: Accuracy-Guaranteed SimRank Queries through Tighter Confidence Bounds and Multi-Armed BanditsYu Liu, Lei Zou, Qian Ge, Zhewei WeiVLDB 2020
- Supporting Hard Queries over Probabilistic PreferencesHaoyue Ping, Julia Stoyanovich, Benny KimelfeldVLDB 2020 · 1 citation
- Ranked Enumeration of Join Queries with ProjectionsShaleen Deep, Xiao Hu, Paraschos KoutrisVLDB 2022 · 14 citations
