Validation of Object Oriented Metrics for Evaluating Understandability of Data Warehouse Models

Abstract

Datawarehouse has a key role in formulating strategic decisions thus it is very essential to maintain its quality. Metrics have been generally used to direct designers to develop quality data models. Numerous researchers have proposed metrics for multidimensional models for datawarehouse. These metrics are required to be empirically validated to prove their practical utility. Empirical validation of the object oriented metrics for multidimensional models for data warehouses at a conceptual level is presented in the paper. Quality attribute understandability is assessed through various combinations of metrics. Univariate and Multiple linear regression analysis have been used in this paper for computing the multidimensional models quality. The results show that these metrics may be considered as key indicators for quality of multidimensional data models.