logo
Data Quality Tools for Data Warehousing - A Small Sample Survey

Abstract

Introduction

Data Flow

Research Questions

Review of Data Quality in Data Warehouses

Data Quality Tools

Methodology

Results

Conclusion

Further Research

Selected References

Research Questions

This study was designed to address the following questions about the relationship between data quality tools and the data destined for the data warehouse:
  1. How can a data quality tool help to ensure that data is clean before it enters the data warehouse?
  2. What properties of the data need to be addressed in order to ensure that the data is clean?
  3. What are the features of a data quality tool that will clean the data?
  4. Which data quality tools contain the features that are needed to ensure clean and accurate data?
  5. How do the various data quality tools compare in terms of price, platform and “user-friendliness?”
The research project was also designed to use the resulting information as the foundation for the “Mapping Data Problems to Features of Data Quality Tools” matrix.
© 2003 Center for Technology in Government