Title :
Use Closure of Relevant Sets of Attributes to Efficiently Find Candidate Keys
Author :
Li, Hongbo ; Zhou, Li
Author_Institution :
Sch. of Manage., LuDong Univ., Yantai
Abstract :
Based on canonical cover or minimum cover for functional dependency set F, a data structure MAC is constructed, which facilitates to compute closures of all attributes sets. Using MAC, a fast algorithm of computing closure of an individual set of attributes is improved to efficiently find candidate keys. The improved algorithm of finding candidate keys neednpsilat compute closures of the total subsets of R, but compute closures of the subsets which are closely relevant to candidate keys, namely, which are candidate keys or one part of candidate keys. Based on the improved algorithm for fast computing closures of the sets of attributes in left set and theorem of reference, an efficient algorithm of finding the total candidate keys are gained, whose time complexity is O(nmiddot|R|middot|Fc|2).
Keywords :
computational complexity; data structures; relational databases; set theory; candidate keys; data structure MAC; functional dependency set; relational database; time complexity; Algorithm design and analysis; Computer science; Conference management; Data structures; Engineering management; Law; Legal factors; Relational databases; Software engineering; Left Part; candidate keys; canonical cover Fc; closure of attributes;
Conference_Titel :
Computer Science and Software Engineering, 2008 International Conference on
Conference_Location :
Wuhan, Hubei
Print_ISBN :
978-0-7695-3336-0
DOI :
10.1109/CSSE.2008.441