Consensus Answers for Queries over Probabilistic Databases

Summary: Introduce “consensus world” — a deterministic answer minimizing expected distance to possible worlds, extending rank-aggregation to probabilistic databases. Derive polytime optimal/approx algorithms and NP-hardness for SPJ, Top‑k, group-by aggregates, and clustering under the expressive and/xor-tree model. (summarized by gpt-5-mini on Feb 09 2026)

Paper ID: h28d6790fd4e9f5b7
Venue: PODS
Year: 2009
Pagerank: 7.2155312e-05
Overall Rank: 3,542 | 76.19%
DOI: 10.1145/1559795.1559835

Incoming Non-self Citations Over Time

Authors

1. Jian Li (University of Maryland)
2. Amol Deshpande (University of Maryland)

BibTeX Citation

@inproceedings{li_pods09,
        address = {New York, NY, USA},
        series = {{PODS} '09},
        title = {{Consensus Answers for Queries over Probabilistic Databases}},
        url = {https://dl.acm.org/doi/10.1145/1559795.1559835},
        doi = {10.1145/1559795.1559835},
        booktitle = {Proceedings of the {ACM} {SIGMOD} Symposium on {Principles} of {Database} {Systems}},
        publisher = {Association for Computing Machinery},
        author = {Li, Jian and Deshpande, Amol},
        year = {2009}
}

Incoming Citations (Sorted by Pagerank)

Showing 8 of 8 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
1,365	A Unified Approach to Ranking in Probabilistic Databases	2009	VLDB	0.00010913898
2,620	Ranking with Uncertain Scoring Functions: Semantics and Sensitivity Measures	2011	SIGMOD	8.2168186e-05
3,893	Ranking Continuous Probabilistic Datasets	2010	VLDB	6.940442e-05
6,108	Efficient Probabilistic Reverse Nearest Neighbor Query Processing on Uncertain Data	2011	VLDB	5.8850424e-05
8,639	Efficient Summarization Framework for Multi-Attribute Uncertain Data	2014	SIGMOD	5.2978746e-05
9,380	JENNER: Just-in-time Enrichment in Query Processing	2022	VLDB	5.1868213e-05
11,100	A Rank-Based Approach to Recommender System’s Top-K Queries with Uncertain Scores	2025	SIGMOD	4.9793485e-05
12,694	On Pruning for Top-K Ranking in Uncertain Databases	2011	VLDB	4.9793485e-05

Outgoing Citations (Sorted by Pagerank)

Showing 17 of 17 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
51	Efficient Query Evaluation on Probabilistic Databases	2004	VLDB	0.00042936299
126	Trio: A System for Integrated Management of Data, Accuracy, and Lineage	2005	CIDR	0.00030439683
343	Model-Driven Data Acquisition in Sensor Networks	2004	VLDB	0.00020519525
370	Evaluating Probabilistic Queries over Imprecise Data	2003	SIGMOD	0.00019846702
587	Management of Probabilistic Data: Foundations and Challenges	2007	PODS	0.00015933201
690	Creating Probabilistic Databases from Information Extraction Models	2006	VLDB	0.00014745444
841	BayesStore: Managing Large, Uncertain Data Repositories with Probabilistic Graphical Models	2008	VLDB	0.00013541445
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,635	Efficient Search for the Top-k Probable Nearest Neighbors in Uncertain Databases	2008	VLDB	0.00010017067
2,304	Approximation Algorithms for Clustering Uncertain Data	2008	PODS	8.6702799e-05
2,502	Exploiting Shared Correlations in Probabilistic Databases	2008	VLDB	8.3800737e-05
2,543	From Complete to Incomplete Information and Back	2007	SIGMOD	8.3182354e-05
2,965	Horn Tables - An Efficient Tool For Handling Incomplete Information In Databases	1989	PODS	7.8051404e-05
2,984	Materialized Views in Probabilistic Databases: For Information Exchange and Query Optimization	2007	VLDB	7.7830089e-05
3,038	Estimating Statistical Aggregates on Probabilistic Data Streams	2007	PODS	7.7270848e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	5,340	Approximate Lifted Inference with Probabilistic Databases	2015	VLDB
2	6,808	Benchmarking Approximate Consistent Query Answering	2021	PODS
3	1,365	A Unified Approach to Ranking in Probabilistic Databases	2009	VLDB
4	9,169	Efficient Approximations of Conjunctive Queries	2012	PODS
5	1,735	The Data Complexity of Consistent Query Answering for Self-Join-Free Conjunctive Queries Under Primary Key Constraints	2015	PODS
6	4,389	Read-Once Functions and Query Evaluation in Probabilistic Databases	2010	VLDB
7	51	Efficient Query Evaluation on Probabilistic Databases	2004	VLDB
8	7,466	Probabilistic Query Evaluation: The Combined FPRAS Landscape	2023	PODS
9	7,858	Conjunctive Queries on Probabilistic Graphs: Combined Complexity	2017	PODS
10	5,779	Consistent Query Answers in Inconsistent Probabilistic Databases	2010	SIGMOD