Advertisement

A probabilistic relational data model

  • Daniel Barbara
  • Hector Garcia-Molina
  • Daryl Porter
Session 3: Data Models
Part of the Lecture Notes in Computer Science book series (LNCS, volume 416)

Abstract

It is often desirable to represent in a database entities whose properties cannot be deterministically classified. We develop a new data model that includes probabilities associated with the values of the attributes. The notion of missing probabilities is introduced for partially specified probability distributions. This new model offers a richer descriptive language allowing the database to reflect more accurately the uncertain real world. Probabilistic analogs to the basic relational operators are defined and their correctness is studied.

Keywords

Probability Distribution Function Relational Database Incomplete Information Deterministic Attribute Deterministic Relation 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

7. References

  1. [Bar]
    Barbara, D., Garcia-Molina, H., Porter, D., “A Probabilistic Relational Data Model,” Technical Report CS-TR-215-89, Department of Computer Science, Princeton University, January 1989.Google Scholar
  2. [Cav]
    Cavallo, R. & Pittarelli, M., “The Theory of Probabilistic Databases,” Proceedings of the 13th Conference on Very Large Databases, 1987.Google Scholar
  3. [Dad]
    Dadam, P., Kuespert, K. et al, “A DBMS Prototype to Support Non-First Normal Form Relations: An Integrated View on Flat Tables & Hierarchies”, SIGMOD Proceedings, 1986.Google Scholar
  4. [Dat]
    Date, C., An Introduction to Database Systems Vol. 1, Addison-Wesley, 4th Edition, 1986.Google Scholar
  5. [Gar]
    Garcia-Molina, H & Porter, D., “Supporting Probabilistic Data in a Relational System,” Technical Report TR-147, Department of Computer Science, Princeton University, February 1988.Google Scholar
  6. [Gel]
    Gelenbe, E. & Hebrail, G., “A Probability Model of Uncertainty in Databases,” Proceedings of the International Conference on Data Engineering, Feb. 1986.Google Scholar
  7. [Gho]
    Ghosh, S., “Statistical Relational Tables for Statistical Database Management,” IEEE Transactions on Software Engineering, Dec. 1986.Google Scholar
  8. [Imi]
    Imielinski, T., “Query Processing in Deductive Databases with Incomplete Information,” Rutgers Technical Report DCS-TR-177, Mar. 1986.Google Scholar
  9. [Imi2]
    Imielinski, T., “Automated Deduction in Databases with Incomplete Information,” Rutgers Technical Report DCS-TR-181, Mar. 1986.Google Scholar
  10. [Imi3]
    Imielinski, T. & Lipski, W., “Incomplete Information in Relational Databases,” Journal of the ACM, Vol. 31, No. 4, Oct. 1984.Google Scholar
  11. [Lip]
    Lipski, W., ‘On Semantic Issues Connected with Incomplete Information Databases,” ACM Transactions on Database Systems, Vol. 4, No. 3, Sep. 1979.Google Scholar
  12. [Lip2]
    Lipski, W., “On the Logic of Incomplete Information,” Proceedings of the 6th International Symposium of Mathematical Foundations of Computer Science, September 1977.Google Scholar
  13. [Liu]
    Liu, Ken-Chih & Sunderraman, R., “On Representing Indefinite & Maybe Information in Relational Databases,” Proceedings of the 4th International Conference on Data Engineering, February 1988.Google Scholar
  14. [Men]
    Mendelson, H. & Saharia, A., “Incomplete Information Costs & Database Design,” ACM Transactions on Database Systems, Vol. 11, June 1986.Google Scholar
  15. [Mey]
    Meyer, P. Introductory Probability & Statistical Applications, Addison-Wesley, 2nd Edition, 1970.Google Scholar
  16. [Mor]
    Morrissey, J. & van Rijsbergen, C., “A Formal Treatment of Missing & Imprecise Information,” Proceedings of SIGIR, 1987.Google Scholar
  17. [Pea]
    Pearl, Judea, “Fusion, Propagation, and Structuring in Belief Networks,” Artificial Intelligence 29, 1986, pp 241–288.CrossRefMathSciNetGoogle Scholar
  18. [Raj]
    Raju, K.V.S.V.N., & Majumdar A., “Fuzzy Functional Dependencies and Lossless Join Decomposition of Fuzzy Relational Database Systems,” ACM Transactions on Database Systems, Vol. 13, No. 2, June 1988.Google Scholar
  19. [Rei]
    Reiter, R., “A Sound & Sometimes Complete Query Evaluation Algorithm for Relational Databases with Null Values,” Journal of the ACM, Vol. 33, No. 2, Apr. 1986.Google Scholar
  20. [Rot]
    Roth, M., Korth, H., & Silberschatz, A., “Extended Algebra & Calculus for Non-1NF Relational Databases,” University of Texas at Austin Technical Report TR-84-36, Jan. 1985.Google Scholar
  21. [Rot2]
    Roth, M., Korth, H., & Silberschatz, A., “Null Values in Non-1NF Relational Databases,” University of Texas at Austin Technical Report TR-85-32, Dec. 1985.Google Scholar
  22. [Ull]
    Ullman, J. D., Principles of Database and Knowledge-Base Systems, Computer Science Press, 1988.Google Scholar
  23. [Vas]
    Vassilou, Y., “Functional Dependencies & Incomplete Information,” Proceedings of the 6th International Conference on Very Large Databases, Montreal, Oct. 1980.Google Scholar
  24. [Won]
    Wong, E., “A Statistical Approach to Incomplete Information in Database Systems,” ACM Transactions on Database Systems, Vol. 7, No. 3, Sep. 1982.Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 1990

Authors and Affiliations

  • Daniel Barbara
    • 1
  • Hector Garcia-Molina
    • 1
  • Daryl Porter
    • 1
  1. 1.Department of Computer SciencePrinceton UniversityPrinceton

Personalised recommendations