A probabilistic relational model and algebra

Although the relational model for databases provides a great range of advantages over other data models, it lacks a comprehensive way to handle incomplete and uncertain data. Uncertainty in data values, however, is pervasive in all real-world environments and has received much attention in the literature. Several methods have been proposed for incorporating uncertain data into relational databases. However, the current approaches have many shortcomings and have not established an acceptable extension of the relational model. In this paper, we propose a consistent extension of the relational model. We present a revised relational structure and extend the relational algebra. The extended algebra is shown to be closed, a consistent extension of the conventional relational algebra, and reducible to the latter.

[1]  Richard T. Snodgrass,et al.  The temporal query language TQuel , 1984, TODS.

[2]  E. F. Codd,et al.  The Relational Model for Database Management, Version 2 , 1990 .

[3]  Frederick E. Petry,et al.  Extending the fuzzy database with fuzzy numbers , 1984, Inf. Sci..

[4]  Michael Pittarelli,et al.  The Theory of Probabilistic Databases , 1987, VLDB.

[5]  Witold Lipski,et al.  On semantic issues connected with incomplete information databases , 1979, ACM Trans. Database Syst..

[6]  Abraham Kandel,et al.  Implementing Imprecision in Information Systems , 1985, Inf. Sci..

[7]  George J. Klir,et al.  Fuzzy sets, uncertainty and information , 1988 .

[8]  Henri Prade,et al.  Generalizing Database Relational Algebra for the Treatment of Incomplete/Uncertain Information and Vague Queries , 1984, Inf. Sci..

[9]  Hector Garcia-Molina,et al.  The Management of Probabilistic Data , 1992, IEEE Trans. Knowl. Data Eng..

[10]  Patricia A. Owen,et al.  Decisions that influence outcomes in the distant future , 1983, IEEE Transactions on Systems, Man, and Cybernetics.

[11]  Eugene Wong,et al.  A statistical approach to incomplete information in database systems , 1982, TODS.

[12]  Arun K. Majumdar,et al.  Fuzzy Functional Dependencies and Lossless Join Decomposition of Fuzzy Relational Database Systems , 1988, ACM Trans. Database Syst..

[13]  David Maier,et al.  The Theory of Relational Databases , 1983 .

[14]  Judea Pearl,et al.  Probabilistic Semantics for Nonmonotonic Reasoning: A Survey , 1989, KR.

[15]  Bill P. Buckles,et al.  Information-theoretical characterization of fuzzy relational databases , 1983, IEEE Transactions on Systems, Man, and Cybernetics.

[16]  C. J. Date Relational Database - Selected Writings , 1986 .

[17]  Haim Mendelson,et al.  Incomplete information costs and database design , 1986, TODS.

[18]  E. F. Codd,et al.  Extending the database relational model to capture more meaning , 1979, ACM Trans. Database Syst..

[19]  LipskiWitold On semantic issues connected with incomplete information databases , 1979 .

[20]  Judea Pearl,et al.  Fusion, Propagation, and Structuring in Belief Networks , 1986, Artif. Intell..