DocumentCode
479748
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
Volume
1
fYear
2008
fDate
12-14 Dec. 2008
Firstpage
237
Lastpage
242
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;
fLanguage
English
Publisher
ieee
Conference_Titel
Computer Science and Software Engineering, 2008 International Conference on
Conference_Location
Wuhan, Hubei
Print_ISBN
978-0-7695-3336-0
Type
conf
DOI
10.1109/CSSE.2008.441
Filename
4721734
Link To Document