Empirical Validation of Multidimensional Model for Data Warehouse

Information is dormant somewhere inside the huge data; dataware house activates it and presents it in the form of required information to top level managers for decision making. Thus by the help of datawarehouse, we do not need to go through tomes of databases for analysis before making a decision. There are some metrics proposed by researchers for multidimensional models for data warehouse. These metrics just provide the estimated or calculated measures and we need to empirically validate these at conceptual level. Two quality attributes effectiveness and understandability are used in this paper for estimating quality of these models. Here database management system software is used to obtain understandability in a pellucid way to attain more accuracy. We used a database management system as the unswayed or neutral subject. The execution time of each query is taken as the time taken by the subject to answer the question. Analysis is done using Pearson's correlation method and finally quality is predicted.