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 language | English |
---|---|
Journal | Proceedings of the VLDB Endowment |
Volume | 12 |
Issue number | 12 |
Pages (from-to) | 1874-1877 |
Number of pages | 4 |
ISSN | 2150-8097 |
DOIs | |
Publication status | Published - 2019 |
Event | 45th International Conference on Very Large Data Bases - Duration: 26 Aug 2019 → 30 Aug 2019 Conference number: 45 http://vldb.org/2019/ |
Conference
Conference | 45th International Conference on Very Large Data Bases |
---|---|
Number | 45 |
Period | 26/08/2019 → 30/08/2019 |
Internet address |