DocumentCode
503944
Title
Candidate Keys Solving Method Based on Boolean Matrix for Single Attribute Functional Dependency Sets
Author
Duan, Wenxiu
Author_Institution
Comput. Dept., DeZhou Univ., Dezhou, China
Volume
2
fYear
2009
fDate
19-21 May 2009
Firstpage
265
Lastpage
267
Abstract
Candidate key is a very important concept in database design, the right or wrong of the appointed candidate keys determines the database optimization result to some extent. A solution algorithm solving candidate keys of single attribute functional dependency sets based on Boolean matrix is given in this paper. N class attribute, circuit and subgraph don´t have to be considered in the method, and it is very easy in program realization. The method can obtained all candidate keys in the appointed problem field. Meanwhile, the algorithm also can provide good foundation for solving candidate keys of complex attribute functional dependency sets.
Keywords
data mining; pattern classification; relational databases; set theory; Boolean matrix; N-class attribute; attribute classification; candidate key solving algorithm; complex attribute functional dependency set; database design optimization; program realization; relation schema; single attribute functional dependency set; subgraph method; Circuits; Data preprocessing; Databases; Design optimization; Matrix converters; Software engineering; Boolean matrix; Candidate key; Single attribute functional dependency sets;
fLanguage
English
Publisher
ieee
Conference_Titel
Software Engineering, 2009. WCSE '09. WRI World Congress on
Conference_Location
Xiamen
Print_ISBN
978-0-7695-3570-8
Type
conf
DOI
10.1109/WCSE.2009.126
Filename
5319667
Link To Document