IHCS: An Integrated Hybrid Cleaning System

Congcong Ge, Yunjun Gao, Xiaoye Miao, Lu Chen, Christian S. Jensen, Ziyuan Zhu

Research output: Contribution to journalConference article in JournalResearchpeer-review

Abstract

Data cleaning is a prerequisite to subsequent data analysis, and is know to often be time-consuming and labor-intensive. We present IHCS, a hybrid data cleaning system that integrates error detection and repair to contend effectively with multiple error types. In a preprocessing step that precedes the data cleaning, IHCS formats an input dataset to be cleaned, and transforms applicable data quality rules into a unified format. Then, an MLN index structure is formed according to the unified rules, enabling IHCS to handle multiple error types simultaneously. During the cleaning, IHCS first tackles abnormalities through an abnormal group process, and then, it generates multiple data versions based on the MLN index. Finally, IHCS eliminates conflicting values across the multiple versions, and derives the final unified clean data. A visual interface enables cleaning process monitoring and cleaning result analysis.
Original languageEnglish
JournalProceedings of the VLDB Endowment
Volume12
Issue number12
Pages (from-to)1874-1877
Number of pages4
ISSN2150-8097
DOIs
Publication statusPublished - 2019
Event45th International Conference on Very Large Data Bases -
Duration: 26 Aug 201930 Aug 2019
Conference number: 45
http://vldb.org/2019/

Conference

Conference45th International Conference on Very Large Data Bases
Number45
Period26/08/201930/08/2019
Internet address

Fingerprint Dive into the research topics of 'IHCS: An Integrated Hybrid Cleaning System'. Together they form a unique fingerprint.

Cite this