Database states and their tableaux
- 3 June 1984
- journal article
- Published by Association for Computing Machinery (ACM) in ACM Transactions on Database Systems
- Vol. 9 (2) , 264-282
- https://doi.org/10.1145/329.318579
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.Keywords
This publication has 16 references indexed in Scilit:
- Functions in databasesACM Transactions on Database Systems, 1983
- Joined normal formACM Transactions on Database Systems, 1982
- A simplied universal relation assumption and its propertiesACM Transactions on Database Systems, 1982
- Testing satisfaction of functional dependenciesJournal of the ACM, 1982
- Notions of dependency satisfactionPublished by Association for Computing Machinery (ACM) ,1982
- Equivalence of Relational Database SchemesSIAM Journal on Computing, 1981
- Testing implications of data dependenciesACM Transactions on Database Systems, 1979
- Equivalences among Relational ExpressionsSIAM Journal on Computing, 1979
- Normal forms and relational database operatorsPublished by Association for Computing Machinery (ACM) ,1979
- Optimal implementation of conjunctive queries in relational data basesPublished by Association for Computing Machinery (ACM) ,1977