An Algorithm for Inferring Multivalued Dependencies with an Application to Propositional Logic

Yehoshua Sagiv*

*Corresponding author for this work

Research output: Contribution to journalArticlepeer-review

31 Scopus citations

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 languageEnglish
Pages (from-to)250-262
Number of pages13
JournalJournal of the ACM
Volume27
Issue number2
DOIs
StatePublished - 1 Apr 1980
Externally publishedYes

Keywords

  • database design
  • functional dependency
  • inference rule
  • membership algorithm
  • multivalued dependency
  • propositional logic
  • relational database

Fingerprint

Dive into the research topics of 'An Algorithm for Inferring Multivalued Dependencies with an Application to Propositional Logic'. Together they form a unique fingerprint.

Cite this