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
Pub. Date
14 August, 2018
Paper ID
V4I4-1460
Publisher
Keywords
Functional dependency (FD), Conditional functional dependency (CFD), Constant conditional functional dependency (CCFD), Data cleaning

Citationsacebook

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.

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.