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.
Original language | English |
---|---|
Pages (from-to) | 250-262 |
Number of pages | 13 |
Journal | Journal of the ACM |
Volume | 27 |
Issue number | 2 |
DOIs | |
State | Published - 1 Apr 1980 |
Externally published | Yes |
Keywords
- database design
- functional dependency
- inference rule
- membership algorithm
- multivalued dependency
- propositional logic
- relational database