The Community for Technology Leaders
2007 IEEE 23rd International Conference on Data Engineering (2007)
Istanbul, Turkey
Apr. 15, 2007 to Apr. 20, 2007
ISBN: 1-4244-0802-4
pp: 886-895
Christopher Re , University of Washington, Deptartment of Computer Science, chrisre@cs.washington.edu
Nilesh Dalvi , University of Washington, Deptartment of Computer Science, nilesh@cs.washington.edu
Dan Suciu , University of Washington, Deptartment of Computer Science, suciu@cs.washington.edu
ABSTRACT
Modern enterprise applications are forced to deal with unreliable, inconsistent and imprecise information. Probabilistic databases can model such data naturally, but SQL query evaluation on probabilistic databases is difficult: previous approaches have either restricted the SQL queries, or computed approximate probabilities, or did not scale, and it was shown recently that precise query evaluation is theoretically hard. In this paper we describe a novel approach, which computes and ranks efficiently the top-k answers to a SQL query on a probabilistic database. The restriction to top-k answers is natural, since imprecisions in the data often lead to a large number of answers of low quality, and users are interested only in the answers with the highest probabilities. The idea in our algorithm is to run in parallel several Monte-Carlo simulations, one for each candidate answer, and approximate each probability only to the extent needed to compute correctly the top-k answers.
INDEX TERMS
null
CITATION

D. Suciu, N. Dalvi and C. Re, "Efficient Top-k Query Evaluation on Probabilistic Data," 2007 IEEE 23rd International Conference on Data Engineering(ICDE), Istanbul, Turkey, 2007, pp. 886-895.
doi:10.1109/ICDE.2007.367934
245 ms
(Ver 3.3 (11022016))