Towards a Metrics Suite for Conceptual Models of Datawarehouses

Nowadays most organizations have incorporated datawarehouses as one of their principal assets for the efficient management of information. It is vital to be able to guarantee the quality of the information that is stored in the datawarehouses given that they have become the principal tool for strategic decision making. The quality of the information depends on the quality of its presentation and the quality of the datawarehouse. The latter includes the quality of the multidimensional model, at a conceptual, logical, and physical level. Over recent years we have proposed and validated several metrics for the evaluation of the complexity of the multidimensional star model (at a logical level). In this article we present an initial proposal of metrics for the multidimensional model at a conceptual level and for their theoretical validation.

[1]  Mario Piattini,et al.  Using Metrics to Predict OO Information Systems Maintainability , 2001, CAiSE.

[2]  Ralph Kimball,et al.  The Data Warehouse Toolkit: Practical Techniques for Building Dimensional Data Warehouses , 1996 .

[3]  Matteo Golfarelli,et al.  Designing the Data Warehouse: Key Steps and Crucial Issues , 1999 .

[4]  Coral Calero,et al.  Empirical validation of referential integrity metrics , 2001, Inf. Softw. Technol..

[5]  Patrick Suppes,et al.  Foundations of Measurement, Vol. II: Geometrical, Threshold, and Probabilistic Representations , 1989 .

[6]  Jeffrey D. Ullman,et al.  Implementing data cubes efficiently , 1996, SIGMOD '96.

[7]  Bao Yu.  StarChainedER: a Conceptual Model for Data Warehouse Design , 2005 .

[8]  Chris Adamson,et al.  Data Warehouse Design Solutions , 1998 .

[9]  Nectaria Tryfona,et al.  starER: a conceptual model for data warehouse design , 1999, DOLAP '99.

[10]  Mario Piattini,et al.  Experimental validation of multidimensional data models metrics , 2003, 36th Annual Hawaii International Conference on System Sciences, 2003. Proceedings of the.

[11]  Norman E. Fenton,et al.  Software metrics: roadmap , 2000, ICSE '00.

[12]  Victor R. Basili,et al.  The TAME Project: Towards Improvement-Oriented Software Environments , 1988, IEEE Trans. Software Eng..

[13]  Horst Zuse,et al.  A Framework of Software Measurement , 1998 .

[14]  José Samos,et al.  Understanding Analysis Dimensions in a Multidimensional Object-Oriented Model , 2001, DMDW.

[15]  Sandro Morasca,et al.  Property-Based Software Engineering Measurement , 1996, IEEE Trans. Software Eng..

[16]  Richard Y. Wang,et al.  Quality information and knowledge , 1998 .

[17]  Luca Cabibbo,et al.  A Logical Approach to Multidimensional Databases , 1998, EDBT.

[18]  Mario Piattini,et al.  A Controlled Experiment for Validating Class Diagram Structural Complexity Metrics , 2002, OOIS.

[19]  Mario Piattini,et al.  Métricas de calidad para almacenes de datos , 2001, JISBD.

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

[21]  Surajit Chaudhuri,et al.  An overview of data warehousing and OLAP technology , 1997, SGMD.

[22]  Wilburt Labio,et al.  Physical database design for data warehouses , 1997, Proceedings 13th International Conference on Data Engineering.

[23]  Victor R. Basili,et al.  A Methodology for Collecting Valid Software Engineering Data , 1984, IEEE Transactions on Software Engineering.

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

[25]  Elaine J. Weyuker,et al.  Evaluating Software Complexity Measures , 2010, IEEE Trans. Software Eng..

[26]  Thomas Redman,et al.  Data quality for the information age , 1996 .

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

[28]  Coral Calero,et al.  Information and Database Quality , 2002, Advances in Database Systems.

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

[30]  W. H. Inmon,et al.  Building the data warehouse , 1992 .

[31]  Scott A. Whitmire,et al.  Object-Oriented Design Measurement , 1997 .

[32]  Mario Piattini,et al.  A methodology for datawarehouse design: conceptual modeling , 2002 .

[33]  Alberto Abelll.  YAM 2 ( Yet Another Multidimensional Model ) : An extension of UMLAlberto Abell , .

[34]  Il-Yeol Song,et al.  Multidimensional Modeling with UML Package Diagrams , 2002, ER.

[35]  Barbara Dinter,et al.  Extending the E/R Model for the Multidimensional Paradigm , 1998, ER Workshops.

[36]  Panos Vassiliadis,et al.  Data Warehouse Modeling and Quality Issues , 2000 .

[37]  Manuel Palomar,et al.  Designing Data Warehouses with OO Conceptual Models , 2001, Computer.

[38]  Matteo Golfarelli,et al.  Conceptual design of data warehouses from E/R schemes , 1998, Proceedings of the Thirty-First Hawaii International Conference on System Sciences.

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

[40]  M. Jarke,et al.  Fundamentals of Data Warehouses , 2003, Springer Berlin Heidelberg.