Efficient query evaluation on probabilistic databases

被引:278
作者
Dalvi, Nilesh [1 ]
Suciu, Dan [1 ]
机构
[1] Univ Washington, Seattle, WA 98195 USA
关键词
D O I
10.1007/s00778-006-0004-3
中图分类号
TP3 [计算技术、计算机技术];
学科分类号
0812 ;
摘要
We describe a framework for supporting arbitrarily complex SQL queries with "uncertain" predicates. The query semantics is based on a probabilistic model and the results are ranked, much like in Information Retrieval. Our main focus is query evaluation. We describe an optimization algorithm that can compute efficiently most queries. We show, however, that the data complexity of some queries is # P-complete, which implies that these queries do not admit any efficient evaluation methods. For these queries we describe both an approximation algorithm and a Monte-Carlo simulation algorithm.
引用
收藏
页码:523 / 544
页数:22
相关论文
共 38 条
[1]  
AGRAWAL S, 2003, AUTOMATED RANKING DA
[2]  
[Anonymous], 1988, PROBABILISTIC REASON, DOI DOI 10.1016/C2009-0-27609-4
[3]   From statistical knowledge bases to degrees of belief [J].
Bacchus, F ;
Grove, AJ ;
Halpern, JY ;
Koller, D .
ARTIFICIAL INTELLIGENCE, 1996, 87 (1-2) :75-143
[4]  
Baeza-Yates R.A., 1999, Modern Information Retrieval
[5]   THE MANAGEMENT OF PROBABILISTIC DATA [J].
BARBARA, D ;
GARCIAMOLINA, H ;
PORTER, D .
IEEE TRANSACTIONS ON KNOWLEDGE AND DATA ENGINEERING, 1992, 4 (05) :487-502
[6]  
CAVALLO R, 1987, THEORY PROBABILISTIC, P71
[7]  
CHAUDHURI S, 2002, P 18 INT C DAT ENG S
[8]  
CHENG R, 2003, SIGMOD, P551
[9]   A probabilistic relational model and algebra [J].
Dey, D ;
Sarkar, S .
ACM TRANSACTIONS ON DATABASE SYSTEMS, 1996, 21 (03) :339-369
[10]   Probabilistic object bases [J].
Eiter, T ;
Lu, JJ ;
Lukasiewicz, T ;
Subrahmanian, VS .
ACM TRANSACTIONS ON DATABASE SYSTEMS, 2001, 26 (03) :264-312