This paper is published in Volume-4, Issue-4, 2018
Area
Database Management Systems (DBMS)
Author
Sneha Sadalagi, Dr. P V Kumar
Org/Univ
Acharya Institute of Technology, Department of CSE, Bengaluru, Karnataka, India
Keywords
Functional dependency (FD), Conditional functional dependency (CFD), Constant conditional functional dependency (CCFD), Data cleaning
Citations
IEEE
Sneha Sadalagi, Dr. P V Kumar. A method to discover constant conditional functional dependencies for a given relation, International Journal of Advance Research, Ideas and Innovations in Technology, www.IJARIIT.com.
APA
Sneha Sadalagi, Dr. P V Kumar (2018). A method to discover constant conditional functional dependencies for a given relation. International Journal of Advance Research, Ideas and Innovations in Technology, 4(4) www.IJARIIT.com.
MLA
Sneha Sadalagi, Dr. P V Kumar. "A method to discover constant conditional functional dependencies for a given relation." International Journal of Advance Research, Ideas and Innovations in Technology 4.4 (2018). www.IJARIIT.com.
Sneha Sadalagi, Dr. P V Kumar. A method to discover constant conditional functional dependencies for a given relation, International Journal of Advance Research, Ideas and Innovations in Technology, www.IJARIIT.com.
APA
Sneha Sadalagi, Dr. P V Kumar (2018). A method to discover constant conditional functional dependencies for a given relation. International Journal of Advance Research, Ideas and Innovations in Technology, 4(4) www.IJARIIT.com.
MLA
Sneha Sadalagi, Dr. P V Kumar. "A method to discover constant conditional functional dependencies for a given relation." International Journal of Advance Research, Ideas and Innovations in Technology 4.4 (2018). www.IJARIIT.com.
Abstract
This CCFD paper explores the idea of discovering the constant conditional functional dependencies (CCFDs). Constant CFDs are particularly important for object identification, which is essential to data cleaning and data integration. The further algorithm provides a set of cleaning rule discovery tools for users to choose it for different applications. These CCFDs are derived from conditional functional dependencies (CFDs). The algorithm is implemented for finding the constant conditional functional dependencies from a given relation.