• DocumentCode
    1750650
  • Title

    Incremental discovery of functional dependencies using partitions

  • Author

    Wang, Shyue-Liang ; Shen, Ju-Wen ; Hong, Tzung-Pei

  • Author_Institution
    Dept. of Inf. Manage., I-Shou Univ., Kaohsiung, Taiwan
  • Volume
    3
  • fYear
    2001
  • fDate
    25-28 July 2001
  • Firstpage
    1322
  • Abstract
    The discovery of functional dependencies (FDs) in relational databases is an important data mining problem. Most current work assumes that the database is static, and a database update requires rediscovering all the FDs by scanning the entire old and new database repeatedly. In this work, we present an efficient data mining algorithm to incrementally discover all FDs in the presence of a new set of tuples added to an old database. Based on the concept of tuple partitions and the monotonicity of FDs, we avoid re-scanning of the database and thereby reduce the computation time. The computational complexity of the proposed algorithm is analyzed. A comparison the with the pair-wise comparison-based incremental approach is also presented. The results show that an improved computation time is achieved, while extra space is required for partitions by our approach
  • Keywords
    computational complexity; data mining; database theory; relational databases; computation time; computational complexity; data mining algorithm; database updating; incremental functional dependencies discovery; monotonicity; new tuple set; pair-wise comparison-based incremental approach; relational databases; tuple partitions; Algorithm design and analysis; Computational complexity; Data analysis; Data mining; Decision trees; Guidelines; Information management; Partitioning algorithms; Relational databases; Testing;
  • fLanguage
    English
  • Publisher
    ieee
  • Conference_Titel
    IFSA World Congress and 20th NAFIPS International Conference, 2001. Joint 9th
  • Conference_Location
    Vancouver, BC
  • Print_ISBN
    0-7803-7078-3
  • Type

    conf

  • DOI
    10.1109/NAFIPS.2001.943739
  • Filename
    943739