A Taxonomy of Dirty Data

  • Authors:
  • Won Kim;Byoung-Ju Choi;Eui-Kyeong Hong;Soo-Kyung Kim;Doheon Lee

  • Affiliations:
  • Cyber Database Solutions, Inc., Austin, Texas, USA;Department of Computer Science, Ewha Institute of Science and Technology, Seoul, Korea;University of Seoul, AITrc, Seoul, Korea;Lucent Technologies, Seoul, Korea;Department of Biosystems, Korea Advanced Institute of Science and Technology, Daejon, Korea

  • Venue:
  • Data Mining and Knowledge Discovery
  • Year:
  • 2003

Quantified Score

Hi-index 0.00

Visualization

Abstract

Today large corporations are constructing enterprise data warehouses from disparate data sources in order to run enterprise-wide data analysis applications, including decision support systems, multidimensional online analytical applications, data mining, and customer relationship management systems. A major problem that is only beginning to be recognized is that the data in data sources are often “dirty”. Broadly, dirty data include missing data, wrong data, and non-standard representations of the same data. The results of analyzing a database/data warehouse of dirty data can be damaging and at best be unreliable. In this paper, a comprehensive classification of dirty data is developed for use as a framework for understanding how dirty data arise, manifest themselves, and may be cleansed to ensure proper construction of data warehouses and accurate data analysis. The impact of dirty data on data mining is also explored.