Abstract
Multidimensional conceptual models have been accepted as the foundation for data warehouse designs. The quality of these models have significant effect on the quality of data warehouse and hence, in turn on the information quality. Few researchers have defined quality attributes for the conceptual models for data warehouse and have also proposed metrics to assess the quality attributes of these models objectively. The objective of this work is to propose candidate metrics to compute the structural complexity of multidimensional model. The main emphasis of this paper will be on the dimension hierarchies in multidimensional model. Though, these hierarchies play very significant role in analysing data at various granularity levels, their use enhances structural complexities of multidimensional model which can affect their understandability and modifiability and in turn maintainability.
- Calero C., Piattini M., Pascual C., Serrano, M.A. (2001), "Towards Data warehouse quality metrics. In 3rd International workshop on design and Management of Data warehouses (DMDW 2001), Interlaken, Switzerland.Google Scholar
- Inmon,, W. H. (1997), "Building Data warehouse", John Wiley & sons.Google Scholar
- Fenton N. (1994), "Software measurement: a necessary scientific basis," IEEE Transactions on Software Engineering, Vol. 20, 1994, pp. 199--206. Google ScholarDigital Library
- Zuse H. (1992), "Properties of software measures," Software Quality Journal, Vol. 1, pp. 225--260.Google ScholarCross Ref
- Elzbieta Malinowski, Esteban Zimányi, (2004) "OLAP Hierarchies: A Conceptual Perspective", CAiSE 2004, LNCS 3084, pp. 477--491.Google Scholar
- Berenguer, G., Romero, R., Trujillo, J., Serrano, M., Piattini, M. (2005), "A Set of Quality Indicators and Their Corresponding Metrics for Conceptual Models of Data Warehouses", Lecture Notes in Computer Science 3589 (DaWaK 2005), Springer. ISSN: 0302-9743. Pp.95--104. Google ScholarDigital Library
- Serrano M., Trujillo j., Calero C., Piattini M. (2007), "Metrics for data warehouse conceptual models understandability", Journal of Information and Software Technology 49, 851--870. Google ScholarDigital Library
- A. Abelló, J. Samos, F. Saltor (2002), "YAM2 (Yet Another Multidimensional Model): An Extension of UML", International Database Engineering and Applications Symposium (IDEAS 2002), IEEE Computer Society, Edmonton (Canada), pp. 172--181. Google ScholarDigital Library
- Serrano M., "Definition of a Set of Metrics for Assuring Data Warehouse Quality", Univeristy of Castilla, La Mancha (Spain), 2004.Google Scholar
- Serrano M., Calero C., Piattini M. (2002), "Validating metrics for data warehouses", IEE Proceedings SOFTWARE 149, 161--166.Google ScholarCross Ref
- Serrano M., Calero C., Trujillo J., Lujan, Piattini M. (2004), "Empirical validation of metrics for conceptual models of data warehouse", 16th International Conference on Advanced Information Systems Engineering (CAISE'04), Riga, Latvia, pp. 506--520.Google ScholarCross Ref
- Serrano M., Calero C., Trujillo J., Lujan S., Piattini M. (2004), "Empirical validation of metrics for data warehouses", 4th ASERC Workshop on Quantitative and Soft Computing Based Software Engineering (QSSE 2004), Banff, Alberta (Canada).Google Scholar
- Si-Saıd, Prat N. (2003), "Multidimensional Schemas Quality: assessing and Balancing Analyzability and simplicity", ER 2003 Workhop pp. 140--151.Google Scholar
- Trujillo J., Palomar M., Gómez J., Song (2001), "Designing Data Warehouses with OO Conceptual Models", IEEE Computer, Special issue on Data Warehouses 34, 66--75. Google ScholarDigital Library
- Solingen R., Berghout V., "The Goal/Question/Metric Method: A Practical Guide for Quality improvement of Software Development", McGraw-Hill, 1999.Google Scholar
- Briand L., Wust J., Lounis H., "A Comprehensive investigation of quality factors in object oriented designs: An industrial case study", 21st International conference on software Engineering, pp 345--354. Google ScholarDigital Library
- Kesh S. (1995), "Evaluating the Quality of Entity Relationship model", Information and Software Technology 37 (12).Google Scholar
- Krogstie J., Lindland O, Sindre G. (1995), "Towards a deeper understanding of quality in Requirement Engineering", 7th International Conference on Advanced Information Systems Engineering CAISE 1995. Google ScholarDigital Library
- Lindland O., Sindre A., Solvberg A. (1994), "Understanding quality in conceptual modelling", IEEE Software 11 (2), pp 42--49. Google ScholarDigital Library
- Krogstie J., "Integrating the understanding of Quality in Requirement specification and conceptual modelling", Software Engineering notes, 28(1), pp 86--91. Google ScholarDigital Library
- Van Hans, "Software Engineering: Principles and Practice, John Wiley & sons.Google Scholar
- Moody D. L., Shank G. G. (2003), "Improving the quality of data models: Empirical Validation of Quality management framework", International Journal of Information systems. Google ScholarDigital Library
- Marcela Genero, Geert Poels, Mario Piattini (2008), "Defining and validating metrics for assessing the understandability of entity-relationship diagrams", Data & Knowledge Engineering (64), 534--557. Google ScholarDigital Library
- Moody D.L. (2005), "Theoretical and practical issues in evaluating the quality of conceptual models: current state and future directions", Data and Knowledge Engineering 55 (3), 243--276. Google ScholarDigital Library
- Basil V., Weiss D (1984)., "A methodology for collecting Valid Software Engineering data", IEEE Transaction on software Engineering (10), 728--738.Google Scholar
- ISO International Standard ISO/IEC 9126 Information Technology- Software product evaluation, Geneva (2001).Google Scholar
- Fenton, N., & Pfleeger, S. (1997), Software metrics, A rigorous approach (2nd ed.). London: Chapman & Hall. 1997. Google ScholarDigital Library
- Calero C., Piattini M., Genero M (2001a), "Method for obtaining correct metrics", 3rd International Conference on Enterprise and Information Systems (ICEIS'2001), pp779--784.Google Scholar
- Calero C., Piattini, M., Genero M (2001b), "Metrics for controlling database complexity: Chapter III in Developing quality complex database systems: Practices, Techniques and Technologies", Becker (ed), Idea Group Publishing. Google ScholarDigital Library
Index Terms
- Quality metrics for conceptual models for data warehouse focusing on dimension hierarchies
Recommendations
Complexity metric for multidimensional models for data warehouse
CUBE '12: Proceedings of the CUBE International Information Technology ConferenceQuality of data models for data warehouse has significant effect on the quality of data warehouse. Complexity metrics play significant role in predicting quality attributes of a software artifact. Few researchers have proposed structural complexity ...
Metrics for data warehouse conceptual models understandability
Due to the principal role of Data warehouses (DW) in making strategy decisions, data warehouse quality is crucial for organizations. Therefore, we should use methods, models, techniques and tools to help us in designing and maintaining high quality DWs. ...
Validating dimension hierarchy metrics for the understandability of multidimensional models for data warehouse
Structural properties including hierarchies have been recognised as important factors influencing quality of a software product. Metrics based on structural properties (structural complexity metrics) have been popularly used to assess the quality ...
Comments