NDLI: Conditional functional dependencies for capturing data inconsistencies

Content Provider	ACM Digital Library
Author	Kementsietsidis, Anastasios Fan, Wenfei Geerts, Floris Jia, Xibei
Copyright Year	2008
Abstract	We propose a class of integrity constraints for relational databases, referred to as conditional functional dependencies (CFDs), and study their applications in data cleaning. In contrast to traditional functional dependencies (FDs) that were developed mainly for schema design, CFDs aim at capturing the consistency of data by enforcing bindings of semantically related values. For static analysis of CFDs we investigate the consistency problem, which is to determine whether or not there exists a nonempty database satisfying a given set of CFDs, and the implication problem, which is to decide whether or not a set of CFDs entails another CFD. We show that while any set of transitional FDs is trivially consistent, the consistency problem is NP-complete for CFDs, but it is in PTIME when either the database schema is predefined or no attributes involved in the CFDs have a finite domain. For the implication analysis of CFDs, we provide an inference system analogous to Armstrong's axioms for FDs, and show that the implication problem is coNP-complete for CFDs in contrast to the linear-time complexity for their traditional counterpart. We also present an algorithm for computing a minimal cover of a set of CFDs. Since CFDs allow data bindings, in some cases CFDs may be physically large, complicating the detection of constraint violations. We develop techniques for detecting CFD violations in SQL as well as novel techniques for checking multiple constraints by a single query. We also provide incremental methods for checking CFDs in response to changes to the database. We experimentally verify the effectiveness of our CFD-based methods for inconsistency detection. This work not only yields a constraint theory for CFDs but is also a step toward a practical constraint-based method for improving data quality.
Starting Page	1
Ending Page	48
Page Count	48
File Format	PDF
ISSN	03625915
e-ISSN	15574644
DOI	10.1145/1366102.1366103
Volume Number	33
Issue Number	2
Journal	ACM Transactions on Database Systems (TODS)
Language	English
Publisher	Association for Computing Machinery (ACM)
Publisher Date	2008-06-24
Publisher Place	New York
Access Restriction	One Nation One Subscription (ONOS)
Subject Keyword	Data cleaning SQL Functional dependency
Content Type	Text
Resource Type	Article
Subject	Information Systems

Sl.	Authority	Responsibilities	Communication Details
1	Ministry of Education (GoI), Department of Higher Education	Sanctioning Authority	https://www.education.gov.in/ict-initiatives
2	Indian Institute of Technology Kharagpur	Host Institute of the Project: The host institute of the project is responsible for providing infrastructure support and hosting the project	https://www.iitkgp.ac.in
3	National Digital Library of India Office, Indian Institute of Technology Kharagpur	The administrative and infrastructural headquarters of the project	Dr. B. Sutradhar bsutra@ndl.gov.in
4	Project PI / Joint PI	Principal Investigator and Joint Principal Investigators of the project	Dr. B. Sutradhar bsutra@ndl.gov.in Prof. Saswat Chakrabarti will be added soon
5	Website/Portal (Helpdesk)	Queries regarding NDLI and its services	support@ndl.gov.in
6	Contents and Copyright Issues	Queries related to content curation and copyright issues	content@ndl.gov.in
7	National Digital Library of India Club (NDLI Club)	Queries related to NDLI Club formation, support, user awareness program, seminar/symposium, collaboration, social media, promotion, and outreach	clubsupport@ndl.gov.in
8	Digital Preservation Centre (DPC)	Assistance with digitizing and archiving copyright-free printed books	dpc@ndl.gov.in
9	IDR Setup or Support	Queries related to establishment and support of Institutional Digital Repository (IDR) and IDR workshops	idr@ndl.gov.in

Explorer Conditional functional dependencies for capturing data inconsistencies

Design by example for SQL table definitions with functional dependencies

Discovering Conditional Functional Dependencies

Sampling from repairs of conditional functional dependency violations

Conflict resolution with data currency and consistency

The implication problem of data dependencies over SQL table definitions: Axiomatic, algorithmic and logical characterizations

Discovering Conditional Functional Dependencies

Incremental Detection of Inconsistencies in Distributed Data

Functional dependencies in Horn clause queries

Conditional functional dependencies for capturing data inconsistencies

Similar Documents

Explorer Conditional functional dependencies for capturing data inconsistencies

Design by example for SQL table definitions with functional dependencies

Discovering Conditional Functional Dependencies

Sampling from repairs of conditional functional dependency violations

Conflict resolution with data currency and consistency

The implication problem of data dependencies over SQL table definitions: Axiomatic, algorithmic and logical characterizations

Discovering Conditional Functional Dependencies

Incremental Detection of Inconsistencies in Distributed Data

Functional dependencies in Horn clause queries

Conditional functional dependencies for capturing data inconsistencies