Enhancing data quality in data warehouse environments

Abstract

The article reports on enhancement of data quality in data warehouse environment. Here a conceptual framework is offered for enhancing data quality in data warehouse environments. Factors are explored such as current level of data quality, the levels of quality needed by the relevant decision process, the potential benefits of projects designed to enhance data. Those who are responsible for data quality have to understand the importance of such factors. For warehouses supporting a limited number of decision processes, awareness of these issues coupled with good judgment should suffice. Data warehousing efforts may not succeed for various reasons, but nothing is more certain to yield failure than lack of concern for the quality of the data. Data supporting organizational activities in a meaningful way should be warehoused. A distinguishing characteristic of warehoused data is that it is used for decision making, rather than for operations. Data warehousing efforts have to address several potential problems.