Analysis of Data Warehouse Quality Metrics Using LR

Abstract

Organizations, these days are deploying Data Warehouse for integrating data from various heterogeneous sources for management of information more efficiently and cost- effectively. Data Warehouse is acting as the main asset of the organization because strategic decision making ability of a business manager largely depends on the effectiveness of data warehouse. One of the main issues that influence the Quality of the information is the Data Warehouse Model Quality. A set of metrics have been defined and validated [9] to measure the Quality of the conceptual Data Model for Data Warehouse. However, this set of metrics contains some redundant metrics. Using Linear Regression (LR), we reduce this set of metrics so as to obtain the effective predictor metrics only. Further, these metrics will be empirically validated so as to use them as Quality indicators. © Springer-Verlag Berlin Heidelberg 2010.