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: h75c68e904342743a
Venue: VLDB
Year: 2023
Pagerank: 5.1868213e-05
Overall Rank: 9,374 | 36.98%
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,886	FastPDB: Towards Bag-Probabilistic Queries at Interactive Speeds	2025	SIGMOD	5.2559789e-05
11,100	A Rank-Based Approach to Recommender System’s Top-K Queries with Uncertain Scores	2025	SIGMOD	4.9793485e-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.00059752575
245	MCDB: A Monte Carlo Approach to Managing Uncertain Data	2008	SIGMOD	0.00023258672
500	Dependencies Revisited for Improving Data Quality	2008	PODS	0.00017280722
819	Provenance for Aggregate Queries	2011	PODS	0.00013666629
824	Data Integration: The Teenage Years	2006	VLDB	0.00013646923
1,365	A Unified Approach to Ranking in Probabilistic Databases	2009	VLDB	0.00010913898
1,396	Ranking Queries on Uncertain Data: A Probabilistic Threshold Approach	2008	SIGMOD	0.0001079253
1,941	Interpretable Data-Based Explanations for Fairness Debugging	2022	SIGMOD	9.3297671e-05
2,204	OLAP Over Uncertain and Imprecise Data	2005	VLDB	8.8558582e-05
2,717	Partial Results in Database Systems	2014	SIGMOD	8.0980367e-05
4,176	Aggregation in Probabilistic Databases via Knowledge Compilation	2012	VLDB	6.7573044e-05
4,868	Uncertainty Annotated Databases - A Lightweight Approach for Approximating Certain Answers	2019	SIGMOD	6.3748367e-05
5,651	Foundations of Uncertain-Data Integration	2010	VLDB	6.0521173e-05
5,802	Making SQL Queries Correct on Incomplete Databases: A Feasibility Study	2016	PODS	5.989635e-05
5,986	Querying Uncertain Data with Aggregate Constraints	2011	SIGMOD	5.9260205e-05
6,046	Your notebook is not crumby enough, REPLace it	2020	CIDR	5.9052121e-05
6,089	Lenses: An On-Demand Approach to ETL	2015	VLDB	5.8908642e-05
8,166	Fast and Reliable Missing Data Contingency Analysis with Predicate-Constraints	2020	SIGMOD	5.3849926e-05
8,426	Efficient Uncertainty Tracking for Complex Queries with Attribute-level Bounds	2021	SIGMOD	5.3350162e-05
9,002	Coping with Incomplete Data: Recent Advances	2020	PODS	5.2394054e-05
9,838	SGL: A Scalable Language for Data-Driven Games	2008	SIGMOD	5.1234268e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	12,677	Efficient Rank Join with Aggregation Constraints	2011	VLDB
2	51	Efficient Query Evaluation on Probabilistic Databases	2004	VLDB
3	1,365	A Unified Approach to Ranking in Probabilistic Databases	2009	VLDB
4	2,620	Ranking with Uncertain Scoring Functions: Semantics and Sensitivity Measures	2011	SIGMOD
5	8,426	Efficient Uncertainty Tracking for Complex Queries with Attribute-level Bounds	2021	SIGMOD
6	12,758	Conditioning and Aggregating Uncertain Data Streams: Going Beyond Expectations	2010	VLDB
7	3,105	Top-k Queries on Uncertain Data: On Score Distribution and Typical Answers	2009	SIGMOD
8	8,102	Ranking Large Temporal Data	2012	VLDB
9	1,396	Ranking Queries on Uncertain Data: A Probabilistic Threshold Approach	2008	SIGMOD
10	3,326	Sliding-Window Top-k Queries on Uncertain Streams	2008	VLDB