Research Output

A rule based taxonomy of dirty data.

  There is a growing awareness that high quality of data is a key to today’s business success and that dirty data existing within data sources is one of the causes of poor data quality. To ensure high quality data, enterprises need to have a process, methodologies and resources to monitor and analyze the quality of data, methodologies for preventing and/or detecting and repairing dirty data. Nevertheless, research shows that many enterprises do not pay adequate attention to the existence of dirty data and have not applied useful methodologies to ensure high quality data for their applications. One of the reasons is a lack of appreciation of the types and extent of dirty data. In practice, detecting and cleaning all the dirty data that exists in all data sources is quite expensive and unrealistic. The cost of cleaning dirty data needs to be considered for most of enterprises. This problem has not attracted enough attention from researchers. In this paper, a rule-based taxonomy of dirty data is developed. The proposed taxonomy not only provides a mechanism to deal with this problem but also includes more dirty data types than any of existing such taxonomies.

  • Date:

    30 November 2009

  • Publication Status:

    Published

  • Publisher

    GSTF

  • Library of Congress:

    QA75 Electronic computers. Computer science

  • Dewey Decimal Classification:

    005 Computer programming, programs & data

Citation

Li, L., Peng, T. & Kennedy, J. (2009). A rule based taxonomy of dirty data. In Proceedings of Annual International Academic Conference on Data Analysis, Data Quality and Metadata Management, 140-148. ISBN 978-981-08-6308-1

Authors

Keywords

Data warehousing; dirty data; data cleansing; rule-based taxonomy;

Available Documents