Extended SQL support for uncertain data
Although the relational model for databases provides a great range of advantages over other data models, it lacks a comprehensive way for handling uncertain data. Uncertainty in data values, however, is pervasive in all real world environments and has received some attention in the literature. Several methods have been proposed for incorporating uncertain data into relational databases; however, these approaches have many shortcomings. In this paper, we discuss a probabilistic extension of the relational model and propose a query language for creation, modification, and retrieval of uncertain data.
KeywordsFaculty Member Data Item Query Language Marginal Probability Uncertain Data
Unable to display preview. Download preview PDF.
- 1.Barbará, D., Garcia-Molina, H. and Porter, D., “The Management of Probabilistic Data.” IEEE Transactions on Knowledge and Data Engineering, 4(5), pp. 487–502, October 1992.Google Scholar
- 2.Cavallo, R. and Pittarelli, M., “The Theory of Probabilistic Databases.” Proceedings of the 13th VLDB Conference, pp. 71–81, Brighton, 1987.Google Scholar
- 3.Dey, D. and Sarkar, S., “A Probabilistic Relational Model and Algebra.” ACM Transactions on Database Systems, 21(3), pp. 339–369, 1996.Google Scholar
- 4.Klir, G.J. and Folger, T.A., Fuzzy Sets, Uncertainty, and Information, Prentice-Hall, 1988.Google Scholar
- 5.Mendelson, H. and Saharia, AX, “Incomplete Information Costs and Database Design.” ACM Transactions on Database Systems, 11(2), pp. 159–185, 1986.Google Scholar
- 6.Pearl, J., “Fusion, Propagation, and Structuring in Belief Networks.” Artificial Intelligence, 29, pp. 241–288, 1986.Google Scholar