• 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