Efficient Approximation of Certain and Possible Answers for Ranking and Window Queries over Uncertain Data

Summary: Efficient under- and over-approximation framework for certain and possible answers to ranking, top-k and—uniquely—windowed aggregation queries over uncertain data. Implements physical operators for uncertain sorting/window in PostgreSQL, integrates with existing uncertain-DB methods, and empirically outperforms prior approaches in speed and accuracy. (summarized by gpt-5-mini on Feb 09 2026)

Paper ID: 13187
Venue: VLDB
Year: 2023
Pagerank: 5.3058708e-05
Overall Rank: 9,194 | 36.93%
DOI: 10.14778/3583140.3583151

Incoming Non-self Citations Over Time

Authors

1. Su Feng (Illinois Institute of Technology)
2. Boris Glavic (Illinois Institute of Technology)
3. Oliver Kennedy (State University of New York at Buffalo)

BibTeX Citation

@article{feng_vldb23,
        title = {{Efficient Approximation of Certain and Possible Answers for Ranking and Window Queries over Uncertain Data}},
        author = {Feng, Su and Glavic, Boris and Kennedy, Oliver},
        journal = {PVLDB},
        series = {{VLDB} '23},
        volume = {16},
        number = {6},
        pages = {1346--1358},
        doi = {10.14778/3583140.3583151},
        url = {https://doi.org/10.14778/3583140.3583151},
        year = {2023}
}

Incoming Citations (Sorted by Pagerank)

Showing 2 of 2 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
8,724	FastPDB: Towards Bag-Probabilistic Queries at Interactive Speeds	2025	SIGMOD	5.3766157e-05
10,657	A Rank-Based Approach to Recommender System’s Top-K Queries with Uncertain Scores	2025	SIGMOD	5.093636e-05

Outgoing Citations (Sorted by Pagerank)

Showing 21 of 21 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank	Cited Paper	Year	Venue	Pagerank
17	Provenance Semirings	2007	PODS	0.00059843817
238	MCDB: A Monte Carlo Approach to Managing Uncertain Data	2008	SIGMOD	0.0002369322
494	Dependencies Revisited for Improving Data Quality	2008	PODS	0.00017526549
806	Provenance for Aggregate Queries	2011	PODS	0.00013890398
917	Data Integration: The Teenage Years	2006	VLDB	0.00013224381
1,327	A Unified Approach to Ranking in Probabilistic Databases	2009	VLDB	0.00011141552
1,363	Ranking Queries on Uncertain Data: A Probabilistic Threshold Approach	2008	SIGMOD	0.00011025316
1,951	Interpretable Data-Based Explanations for Fairness Debugging	2022	SIGMOD	9.4252389e-05
2,172	OLAP Over Uncertain and Imprecise Data	2005	VLDB	9.0394311e-05
2,663	Partial Results in Database Systems	2014	SIGMOD	8.2818137e-05
4,098	Aggregation in Probabilistic Databases via Knowledge Compilation	2012	VLDB	6.9035475e-05
4,811	Uncertainty Annotated Databases - A Lightweight Approach for Approximating Certain Answers	2019	SIGMOD	6.4983069e-05
5,513	Foundations of Uncertain-Data Integration	2010	VLDB	6.1909879e-05
5,677	Making SQL Queries Correct on Incomplete Databases: A Feasibility Study	2016	PODS	6.1248899e-05
5,866	Querying Uncertain Data with Aggregate Constraints	2011	SIGMOD	6.0615445e-05
5,931	Your notebook is not crumby enough, REPLace it	2020	CIDR	6.0369708e-05
5,971	Lenses: An On-Demand Approach to ETL	2015	VLDB	6.0243066e-05
8,002	Fast and Reliable Missing Data Contingency Analysis with Predicate-Constraints	2020	SIGMOD	5.5085906e-05
8,260	Efficient Uncertainty Tracking for Complex Queries with Attribute-level Bounds	2021	SIGMOD	5.4574671e-05
8,837	Coping with Incomplete Data: Recent Advances	2020	PODS	5.3596619e-05
9,660	SGL: A Scalable Language for Data-Driven Games	2008	SIGMOD	5.2410213e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	12,386	Efficient Rank Join with Aggregation Constraints	2011	VLDB
2	50	Efficient Query Evaluation on Probabilistic Databases	2004	VLDB
3	1,327	A Unified Approach to Ranking in Probabilistic Databases	2009	VLDB
4	8,260	Efficient Uncertainty Tracking for Complex Queries with Attribute-level Bounds	2021	SIGMOD
5	2,571	Ranking with Uncertain Scoring Functions: Semantics and Sensitivity Measures	2011	SIGMOD
6	3,049	Top-k Queries on Uncertain Data: On Score Distribution and Typical Answers	2009	SIGMOD
7	12,467	Conditioning and Aggregating Uncertain Data Streams: Going Beyond Expectations	2010	VLDB
8	7,934	Ranking Large Temporal Data	2012	VLDB
9	1,363	Ranking Queries on Uncertain Data: A Probabilistic Threshold Approach	2008	SIGMOD
10	3,599	Sliding-Window Top-k Queries on Uncertain Streams	2008	VLDB