An Algorithm for Inferring Multivalued Dependencies with an Application to Propositional Logic
- 1 April 1980
- journal article
- Published by Association for Computing Machinery (ACM) in Journal of the ACM
- Vol. 27 (2) , 250-262
- https://doi.org/10.1145/322186.322190
Abstract
An algorithm is given for deciding whether a functional or a multivalued dependency σ (with a right-hand side Y ) is implied by a set of functional and multivalued dependencies Σ. The running time of the algorithm is O (| Y |‖Σ‖), where Y is the number of attributes in Y and ‖Σ‖ is the size of the description of Σ. The problem of constructing the dependency basis of a set of attributes X is also investigated. It is shown that the dependency basis can be found in O ( S ‖Σ‖) time, where S is the number of sets in the dependency basis. Since functional and multivalued dependencies correspond to a subclass of propositional logic (that can be viewed as a generalization of Horn clauses), the algorithm given is also an efficient inference procedure for this subclass of propositional logic.Keywords
This publication has 9 references indexed in Scilit:
- An Equivalence Between Relational Database Dependencies and a Fragment of Propositional LogicJournal of the ACM, 1981
- On the menbership problem for functional and multivalued dependencies in relational databasesACM Transactions on Database Systems, 1980
- Computational problems related to the design of normal form relational schemasACM Transactions on Database Systems, 1979
- On Axiomatizing Multivalued Dependencies in Relational DatabasesJournal of the ACM, 1979
- On the complementation rule for multivalued dependencies in database relationsActa Informatica, 1978
- Functional Dependencies in a Relational Database and Propositional LogicIBM Journal of Research and Development, 1977
- Multivalued dependencies and a new normal form for relational databasesACM Transactions on Database Systems, 1977
- Synthesizing third normal form relations from functional dependenciesACM Transactions on Database Systems, 1976
- A relational model of data for large shared data banksCommunications of the ACM, 1970