Location via proxy:   [ UP ]  
[Report a bug]   [Manage cookies]                
skip to main content
article
Free access

Database states and their tableaux

Published: 03 June 1984 Publication History
  • Get Citation Alerts
  • Abstract

    Recent work considers a database state to satisfy a set of dependencies if there exists a satisfying universal relation whose projections contain each of the relations in the state. Such relations are called weak instances for the state. We propose the set of all weak instances for a state as an embodiment of the information represented by the state. We characterize states that have the same set of weak instances by the equivalence of their associated tableaux. We apply this notion to the comparison of database schemes and characterize all pairs of schemes such that for every legal state of one of them there exists an equivalent legal state of the other one. We use this approach to provide a new characterization of Boyce-Codd Normal Form relation schemes.

    References

    [1]
    AHO, A. V., SAGIV, Y., AND ULLMAN, J.D. Equivalence among relational expressions. SIAM J. Comput. 8, 2 (May 1979), 218-246.
    [2]
    BABB, E. Joined Normal Form: A storage encoding for relational databases. A CM Trans. Database Syst. 7, 4 (Dec. 1982), 588-614.
    [3]
    BEERI, C., BERNSTEIN, P. A., AND GOODMAN, N. A sophisticate's introduction to database normalization theory. In Proceedings of Very Large Data Bases (1978), 113-124.
    [4]
    BEERI, C., MENDELZON, A. O., SAGIV, Y., AND ULLMAN, J. I). Equivalence of relational database schemes. SIAM J. Comput. I0, 2 (1981), 352-370.
    [5]
    BEERI, C., AND RISSANEN, J. Faithful representation of relational database schemes. IBM Res. Rep. RJ2722, 1980.
    [6]
    CHANDRA, A. K., AND MERLIN, P. M. Optimal implementation of conjunctive queries in relational data bases. In Proceedings of the 9th A CM Symposium on the Theory of Computing {1976), ACM, New York, 77-99.
    [7]
    CODD, E.F. Further normalization of the data base relational model. In Data Base Systems, R. Rustin, Ed., Prentice-Hall, Englewood Cliffs, N.J., 1972, 33-64.
    [8]
    FAGIN, R. Normal forms and relational database operators. In Proceedings of the ACM SIGMOD (1979), ACM, New York, 153-160.
    [9]
    FAGIN, R., MENDELZON, A. O., AND ULLMAN, J.D. A simplified universal relation assumption and its properties. ACM Trans. Database Syst. 7, 3 (Sept. 1982), 343-360.
    [10]
    GRAHAM, M.H. Functions in databases. ACM Trans. Database Syst. 8, 1 (Mar. 1983), 81-109.
    [11]
    GRAHAM, M. H., AND MENDELZON, A.O. Notions of dependency satisfaction. In Proceedings o/ the A CM Symposium on Principles of Database Systems (Mar. 29-31, 1982, Los Angeles, Calif.), ACM, New York, 177-188.
    [12]
    HONEYMAN, P. Testing satisfaction of functional dependencies. J. ACM 29, 3 (1982), 668-677.
    [13]
    KUCK, S. M., AND SAGIV, Y. A universal relation database system implemented via the network model. In Proceedings of the ACM Symposium on Principles of Database Systems (Mar. 29-31, 1982, Los Angeles, Calif.), ACM, New York, 147-157.
    [14]
    MAIER, D., MENDELZON, A. O., SADRI, F., AND ULLMAN, J.D. Adequacy of decompositions of relational databases. JCSS 21, 3 (1980), 368-379.
    [15]
    MAIER, D., MENDELZON, A. O., AND SAGIV, Y. Testing implications of data dependencies. ACM Trans. Database Syst. 4, 4 (Dec. 1979), 455-469.
    [16]
    MAIER, D., ROZENSHTEIN, D., SALVETER, S. C., STEIN, J., AND WARREN, D.S. Toward logical data independence: A relational query language without relations. In Proceedings of the ACM SIGMOD (1982), ACM, New York, 51-60.
    [17]
    MAIER, D., ULLMAN, J. D, AND VARDI, M. The revenge of the JD. In Proceedings of the ACM Symposium on Principles o{ Database Systems (1983), ACM, New York, 279-287.
    [18]
    RISSANEN, J. On equivalences of database schemes. In Proceedings of the ACM Symposium on Principles of Database Systems (Mar. 29-31, 1982, Los Angeles, Calif.), ACM, New York, 23-26.
    [19]
    ROZV.NSHTmN, D. Query and authorization of updates in the association-object database model. Computer Science Tech. Rep. 82-040, SUNY at Stony Brook, May 1982.
    [20]
    SAGlV, Y. Can we use the universal instance assumption without using nulls? In Proceedings ACM SIGMOD (1981), ACM, New York, 108-120.
    [21]
    ULLMANN, J.D. Principles of Database Systems. 2nd ed., Computer Science Press, 1982.
    [22]
    VASSILIOU, Y. A formal treatment of imperfect information in database management. Ph.D. dissertation, University of Toronto, 1980.

    Cited By

    View all

    Index Terms

    1. Database states and their tableaux

      Recommendations

      Comments

      Information & Contributors

      Information

      Published In

      cover image ACM Transactions on Database Systems
      ACM Transactions on Database Systems  Volume 9, Issue 2
      June 1984
      164 pages
      ISSN:0362-5915
      EISSN:1557-4644
      DOI:10.1145/329
      • Editor:
      • Robert W. Taylor
      Issue’s Table of Contents

      Publisher

      Association for Computing Machinery

      New York, NY, United States

      Publication History

      Published: 03 June 1984
      Published in TODS Volume 9, Issue 2

      Permissions

      Request permissions for this article.

      Check for updates

      Qualifiers

      • Article

      Contributors

      Other Metrics

      Bibliometrics & Citations

      Bibliometrics

      Article Metrics

      • Downloads (Last 12 months)24
      • Downloads (Last 6 weeks)3
      Reflects downloads up to 10 Aug 2024

      Other Metrics

      Citations

      Cited By

      View all

      View Options

      View options

      PDF

      View or Download as a PDF file.

      PDF

      eReader

      View online with eReader.

      eReader

      Get Access

      Login options

      Full Access

      Media

      Figures

      Other

      Tables

      Share

      Share

      Share this Publication link

      Share on social media