Data Cleaning: Problems and Current Approaches

We classify data quality problems that are addressed by data cleaning and provide an overview of the main solution approaches. Data cleaning is especially required when integrating heterogeneous data sources and should be addressed together with schema-related data transformations. In data warehouses, data cleaning is a major part of the so-called ETL process. We also discuss current tool support for data cleaning.

• Type: Journal
• Year: 2000
• Where: DEBU
• Authors: Erhard Rahm, Hong Hai Do
• Keywords: Cleaning, Data Quality Problems, DEBU 2000, Heterogeneous Data Sources