Formalization and Discovery of Approximate Conditional Functional Dependencies

  • Hiroki Nakayama
  • Ayako Hoshino
  • Chihiro Ito
  • Kyota Kanno
Part of the Lecture Notes in Computer Science book series (LNCS, volume 8055)


We propose efficient and precise discoveries of approximate Conditional Functional Dependencies (CFDs), by providing a precise formalization of approximate CFDs and presenting three discovery algorithms approxCFDMiner, approxCTANE and approxFastCFD as extensions of existing algorithms with renewed techniques. First, approxCFDMiner introduces a global FP-tree traversal for finding Right-hand Side items. Second, approxCTANE uses a modified pruning strategy. Third, approxFastCFD adopts a minimal coverset that is used to exclude non-minimal approximate CFDs. For these algorithms, we theoretically proved the correctness and experimentally evaluated the performances.


Conditional Functional Dependency Approximate CFD Discovery Algorithms 


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    Agrawal, R., Srikant, R.: Fast algorithms for mining association rules in large databases. In: VLDB, pp. 487–499 (1994)Google Scholar
  2. 2.
    Bohannon, P., Flaster, M., Fan, W., Rastogi, R.: A cost-based model and effective heuristic for repairing constraints by value modification. In: SIGMOD, pp. 143–154 (2005)Google Scholar
  3. 3.
    Chiang, F., Miller, R.J.: Discovering data quality rules. PVLDB 1(1), 1166–1177 (2008)Google Scholar
  4. 4.
    Cong, G., Fan, W., Geerts, F., Jia, X., Ma, S.: Improving data quality: Consistency and accuracy. In: VLDB, pp. 315–326 (2007)Google Scholar
  5. 5.
    Diallo, T., Novelli, N., Petit, J.M.: Discovering (frequent) constant conditional functional dependencies. IJDMMM 4(3), 205–223 (2012)CrossRefGoogle Scholar
  6. 6.
    Fan, W., Geerts, F., Jia, X., Kementsietsidis, A.: Conditional functional dependencies for capturing data inconsistencies. ACM Trans. Database Syst. 33(2) (2008)Google Scholar
  7. 7.
    Fan, W., Geerts, F., Li, J., Xiong, M.: Discovering conditional functional dependencies. IEEE Trans. Knowl. Data Eng. 23(5), 683–698 (2011)CrossRefGoogle Scholar
  8. 8.
    Golab, L., Karloff, H.J., Korn, F., Srivastava, D., Yu, B.: On generating near-optimal tableaux for conditional functional dependencies. PVLDB 1(1), 376–390 (2008)Google Scholar
  9. 9.
    Huhtala, Y., Kärkkäinen, J., Porkka, P., Toivonen, H.: Tane: An efficient algorithm for discovering functional and approximate dependencies. Comput. J. 42(2), 100–111 (1999)zbMATHCrossRefGoogle Scholar
  10. 10.
    Liu, G., Li, J., Wong, L.: A new concise representation of frequent itemsets using generators and a positive border. Knowl. Inf. Syst. 17(1), 35–56 (2008)MathSciNetCrossRefGoogle Scholar
  11. 11.
    Medina, R., Nourine, L.: A unified hierarchy for functional dependencies, conditional functional dependencies and association rules. In: Ferré, S., Rudolph, S. (eds.) ICFCA 2009. LNCS, vol. 5548, pp. 98–113. Springer, Heidelberg (2009)CrossRefGoogle Scholar
  12. 12.
    Wyss, C., Giannella, C., Robertson, E.: FastFDs: A heuristic-driven, depth-first algorithm for mining functional dependencies from relation instances - extended abstract. In: Kambayashi, Y., Winiwarter, W., Arikawa, M. (eds.) DaWaK 2001. LNCS, vol. 2114, pp. 101–110. Springer, Heidelberg (2001)CrossRefGoogle Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2013

Authors and Affiliations

  • Hiroki Nakayama
    • 1
  • Ayako Hoshino
    • 2
  • Chihiro Ito
    • 2
  • Kyota Kanno
    • 2
  1. 1.NEC Informatec Systems, Ltd.Kawasaki-shiJapan
  2. 2.NEC Knowledge Discovery Research Labs.Kawasaki-shiJapan

Personalised recommendations