Empirical Validation of Object Oriented Data Warehouse Design Quality Metrics

Data warehouses have been developed that stores information enabling the knowledge worker to make better and faster decisions. As a decision support information system, a data warehouse must provide high level quality of data and quality of service. Various metrics have been defined and theoretical validated to measure the quality of the data warehouse in a consistent and objective manner and if quality measured, it can be managed and improved. Now, in this paper we will use these design quality metrics and empirically validated these metrics by conducting an experiment using regression analysis and deriving the conclusions according to the analysis so that they can be used by researchers and users.

[1]  Marcus Kaiser,et al.  How to Measure Data Quality? - A Metric-Based Approach , 2007, ICIS.

[2]  Jean-Marc Jézéquel,et al.  ≪UML≫ 2002 — The Unified Modeling Language , 2002, Lecture Notes in Computer Science.

[3]  Sergio Luján-Mora.  Multidimensional Modeling using UML and XML , 2002 .

[4]  Mario Piattini,et al.  A Set of Quality Indicators and Their Corresponding Metrics for Conceptual Models of Data Warehouses , 2005, DaWaK.

[5]  Mario Piattini,et al.  Empirical studies to assess the understandability of data warehouse schemas using structural metrics , 2008, Software Quality Journal.

[6]  Walid G. Aref,et al.  Digital government security infrastructure design challenges , 2001 .

[7]  Sergio Luján-Mora,et al.  Extending the UML for Multidimensional Modeling , 2002, UML.

[8]  José Samos,et al.  YAM/sup 2/ (yet another multidimensional model): an extension of UML , 2002, Proceedings International Database Engineering and Applications Symposium.

[9]  Daniel L. Moody,et al.  Theoretical and practical issues in evaluating the quality of conceptual models: current state and future directions , 2005, Data Knowl. Eng..

[10]  Mario Piattini,et al.  Quality of Data Warehouses , 2009, Encyclopedia of Database Systems.

[11]  Manfred A. Jeusfeld,et al.  Conceptual Modeling for Novel Application Domains , 2003, Lecture Notes in Computer Science.

[12]  Panos Vassiliadis,et al.  Towards Quality-oriented Data Warehouse Usage and Evolution , 2000, Inf. Syst..

[13]  Samira Si-Said Cherfi,et al.  Multidimensional Schemas Quality: Assessing and Balancing Analyzability and Simplicity , 2003, ER.

[14]  Mario Piattini,et al.  Validating metrics for data warehouses , 2002, IEE Proc. Softw..

[15]  Mario Piattini,et al.  Towards Data Warehouse Quality Metrics , 2001, DMDW.

[16]  Dimitri Theodoratos,et al.  Proceedings of the 3rd Intl. Workshop on Design and Management of Data Warehouses, DMDW'2001, Interlaken, Switzerland, June 4, 2001 , 2001, Design and Management of Data Warehouses.

[17]  Mario Piattini,et al.  Metrics for data warehouse conceptual models understandability , 2007, Inf. Softw. Technol..

[18]  Mario Piattini,et al.  The impact of structural complexity on the understandability of UML statechart diagrams , 2010, Inf. Sci..