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 :
بازگشت