Fan, Wenfei

Geerts, Floris

Jia, Xibei

English

We present SEMANDAQ, a prototype system for improving the quality of relational data. Based on the recently proposed conditional functional dependencies (CFDs), it detects and repairs errors and inconsistencies that emerge as violations of these constraints. We demonstrate the following functionalities supported by SEMANDAQ: (a) an interface for specifying CFDs; (b) a visual tool for automated detection of CFD violations in relational data,leveraging efficient SQL-based techniques; (c) extensive visual data exploration capabilities that provide the user with various measures of the quality of the data; (d) repair (cleaning) functionality without excess human interaction, built upon CFD-based cleaning algorithms; we show how SEMANDAQ allows for a natural exploration of the quality of the obtained repairs. SEMANDAQ is a promising tool that provides easy access and user-friendly data quality facilitiesfor any relational database system

Edinburgh Research Explorer

A cost-based model and effective heuristic for repairing constraints by value modiﬁcation.

A systematic approach to automatic edit and imputation.

Census data repair: a challenging application of disjunctive logic programming.

Complexity of consistent query answering in databases under cardinality-based and incremental repair semantics.

Conditional functional dependencies for data cleaning.

Conquer: Efﬁcient management of inconsistent databases.

Consistent query answers in inconsistent databases.

Declarative data cleaning: Language, model and algorithms.

Enterprise information portals.

Improving data quality: Consistency and accuracy.

Potter’s wheel: An interactive data cleaning system.

quoting Bill Hostmann, Research Director, presenting at

Semandaq: a data quality system based on conditional functional dependencies

Semandaq: a data quality system based on conditional functional dependencies

Abstract

Similar works

Full text

Available Versions

Edinburgh Research Explorer