Discovery of multivalued dependencies from relations

Article type: Research Article

Authors: Savnik, Iztok^{a; *} | Flach, Peter A.^b

Affiliations: [a] Institut für Informatik, Albert-Ludwigs-Universität Freiburg, Am Flughafen 17, 79110 Freiburg, Germany. E-mail: [email protected] | [b] Department of Computer Science, University of Bristol, Bristol BS8 1UB, UK. E-mail: [email protected]

Correspondence: [*] Corresponding author.

Abstract: Discovery of multivalued dependencies from database relations is viewed as a search in a hypothesis space defined according to the generalisation relationship among multivalued dependencies. Two algorithms for the discovery of multivalued dependencies from relations are presented. The top-down algorithm enumerates the hypotheses from the most general to more specific hypotheses which are checked on the input relation. The bottom-up algorithm first computes the invalid multivalued dependencies. Starting with the most general dependencies, the algorithm iteratively refines the set of dependencies to conform with each particular invalid dependency. The implementation of the algorithms is analysed and some empirical results are presented.

Keywords: attribute dependency, multivalued dependency, database reverse engineering, and data mining

DOI: 10.3233/IDA-2000-43-403

Journal: Intelligent Data Analysis, vol. 4, no. 3-4, pp. 195-211, 2000