Abstract
Data warehouses, based on multidimensional models, have emerged as powerful tool for strategic decision making in the organizations. So it is crucial to assure their information quality, which largely depends on the multidimensional model quality. Few researchers have proposed some useful metrics to assess the quality of the multidimensional models. However, there are certain characteristics of dimension hierarchies (such as relationship between dimension levels; sharing of some hierarchy levels within a dimension, among various dimensions etc.) that have not been considered so far and may contribute significantly to structural complexity of multidimensional data models. The objective of this work is to propose metrics to compute the structural complexity of multidimensional models. The focus is on the sharing of levels among dimension hierarchies, as it may elevate the structural complexity of multidimensional models, thereby affecting understandability and in turn maintainability of these models.
Chapter PDF
Similar content being viewed by others
References
Abello, A., Samos, J., Saltor, F.: Understanding analysis dimensions in a multidimensional object-oriented model. In: Proc. of the 3rd Int. Workshop on Design and Management of Data Warehouses, pp. 1–9 (2001)
Abelló, A., Samos, J., Saltor, F.: YAM2 (Yet Another Multidimensional Model): An Extension of UML. In: International Database Engineering and Applications Symposium, pp. 172–172. IEEE Computer Society (2002)
Berenguer, G., Romero, R., Trujillo, J., Bilò, V., Piattini, M.: A Set of Quality Indicators and Their Corresponding Metrics for Conceptual Models of Data Warehouses. In: Tjoa, A.M., Trujillo, J. (eds.) DaWaK 2005. LNCS, vol. 3589, pp. 95–104. Springer, Heidelberg (2005)
Briand, L.C., Morasca, S., Basili, V.R.: Property based software engineering measurement. IEEE Trans. Softw. Eng. 22, 68–86 (1996)
Calero, C., Piattini, M., Pascual, C., Serrano, M.: Towards data warehouse quality metrics. In: Proc. of Third Int. Workshop on Design and Management of Data Warehouse, Interlaken, Switzerland, pp. 1–10 (2001)
Si-said Cherfi, S., Prat, N.: Multidimensional schemas quality: assessing and balancing analyzability and simplicity. In: Jeusfeld, M.A., Pastor, Ó. (eds.) ER Workshops 2003. LNCS, vol. 2814, pp. 140–151. Springer, Heidelberg (2003)
Fenton, N.: Software measurement: a necessary scientific basis. IEEE Trans. Softw. Eng. 20(3), 199–206 (1994)
Flood, R.L., Carson, E.R.: Dealing with Complexity: An Introduction to the Theory and Application of Systems Science. Plenum Press, Springer, New York (1993)
Gosain, A., Singh, J.: Conceptual Multidimensional Modeling for Data Warehouses: A Survey. In: Communicated to 3rd International Conference on Frontiers in Intelligent Computing Theory and Applications (FICTA) to be held on 14-15 November, Proceedings to be Published in Springer AISC (2014)
Gosain, A., Nagpal, S., Sabharwal, S.: Quality metrics for conceptual models for data warehouse focusing on dimension hierarchies. ACM SIGSOFT Softw. Eng. Notes 36(4), 1–5 (2011)
Gosain, A., Sabharwal, S., Nagpal, S.: Assessment of quality of data warehouse multidimensional model. International Journal of Information Quality 2(4), 344–358 (2011)
Gosain, A., Nagpal, S., Sabharwal, S.: Validating dimension hierarchy metrics for the understandability of multidimensional models for data warehouse. IET Software 7(2), 93–103 (2013)
Hurtado, C.A., Gutiérrez, C., Mendelzon, A.O.: Capturing summarizability with integrity constraints in OLAP. ACM Trans. Database Syst. 30(3), 854–886 (2005)
Husemann, B., Lechtenborger, J., Vossen, G.: Conceptual data warehouse design. In: Proc. of the Int. Workshop on Design and Management of Data Warehouses, p. 6 (2000)
Inmon, W.H.: Building the Data Warehouse, 4th edn. John Wiley & Sons, Inc., New York (2005)
Jagadish, H.V., Lakshmanan, L.V.S., Srivastava, D.: What can hierarchies do for data warehouses? In: Proc. of the 25th International Conference on Very Large Databases, pp. 530–541 (1999)
Kaner, C., Bond, P.: Software Engineering Metrics: What Do They Measure and How Do We Know? In: Proc. of 10th International Software Metrics Symposium (Metrics 2004), Chicago, IL (2004)
Kimball, R.: The data warehouse toolkit. John Wiley & Sons, Chichester (2006)
Kumar, M., Gosain, A., Singh, Y.: Empirical validation of structural metrics for predicting understandability of conceptual schemas for data warehouse. International Journal of System Assurance Engineering and Management, 1–16 (2013)
Lenzerini, M., Vassiliou, Y., Vassiliadis, P.: Fundamentals of data warehouses, Jarke, M. (ed.). Springer (2002)
Luján-Mora, S., Trujillo, J., Song Il, Y.: A UML profile for multidimensional modeling in data warehouses. Data & Knowledge Engineering 59(3), 725–769 (2006)
Malinowski, E., Zimányi, E.: OLAP hierarchies: A conceptual perspective. In: Persson, A., Stirna, J. (eds.) CAiSE 2004. LNCS, vol. 3084, pp. 477–491. Springer, Heidelberg (2004)
Malinowski, E., Zimányi, E.: Hierarchies in a multidimensional model: From conceptual modeling to logical representation. Data & Knowledge Engineering 59(2), 348–377 (2006)
Mansmann, S., Scholl, M.H.: Empowering the OLAP technology to support complex dimension hierarchies. International Journal of Data Warehousing and Mining (IJDWM) 3(4), 31–50 (2007)
Mansmann, S., Scholl, M.H.: Extending the Multidimensional Data Model to Handle Complex Data. Journal of Computing Science and Engineering 1(2), 125–160 (2007)
Mazón, J.N., Lechtenbörger, J., Trujillo, J.: A survey on summarizability issues in multidimensional modeling. Data & Knowledge Engineering 68(12), 1452–1469 (2009)
Melton, A.: Software Measurement. International Thomson Computer Press, London (1996)
Nagpal, S., Gosain, A., Sabharwal, S.: Complexity metric for multidimensional models for data warehouse. In: Proc. of the CUBE International Information Technology Conference, pp. 360–365. ACM (2012)
Pedersen, T.B., Jensen, C.S., Dyreson, C.E.: A foundation for capturing and querying complex multidimensional data. Information Systems 26(5), 383–423 (2001)
Poels, G., Dedene, G.: Distance: a framework for software measure construction, Research Report DTEW 993 (1999)
Prat, N., Akoka, J., Comyn-Wattiau, I.: A UML-based data warehouse design method. Decision Support Systems 42(3), 1449–1473 (2006)
Rizzi, S.: Conceptual modeling solutions for the data warehouse. In: Data Warehouses and OLAP: Concepts, Architectures and Solutions, pp. 1–26 (2007)
Rizzi, S., Abelló, A., Lechtenbörger, J., Trujillo, J.: Research in data warehouse modeling and design: dead or alive? In: Proc. of the 9th ACM International Workshop on Data Warehousing and OLAP, pp. 3–10 (2006)
Serrano, M.: Definition of a Set of Metrics for Assuring Data Warehouse Quality. Univeristy of Castilla, La Mancha (2004)
Serrano, M., Calero, C., Piattini, M.: Validating metrics for data warehouse. IEE Proceeding - Software 149(5), 161–166 (2002)
Serrano, M., Calero, C., Piattini, M.: Experimental validation of multidimensional data models metrics. In: Proc. of 36th Annual Hawaii Int. Conf. on System Sciences, Hawaii (2003)
Bilò, V., Calero, C., Trujillo, J., Luján-Mora, S., Piattini, M.: Empirical validation of metrics for conceptual models for data warehouse. In: Persson, A., Stirna, J. (eds.) CAiSE 2004. LNCS, vol. 3084, pp. 506–520. Springer, Heidelberg (2004)
Serrano, M., Calero, C., Piattini, M.: An experimental replication with data warehouse metrics. International Journal of Data Warehousing and Mining 1(4), 1–21 (2005)
Serrano, M., Trujillo, J., Calero, C., Piattini, M.: Metrics for data warehouse conceptual models understandability. Journal of Information and Software Technology 49, 851–870 (2007)
Serrano, M., Calero, C., Sahraouli, H., Piattini, M.: Empirical studies to assess the understandability of data warehouse schemas using structural metrics. Software Quality Journal 16(1), 79–106 (2008)
Zuse, H.: Framework of Software Measurement. Walter de Guyter, Berlin (1998)
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2015 Springer International Publishing Switzerland
About this paper
Cite this paper
Gosain, A., Singh, J. (2015). Quality Metrics for Data Warehouse Multidimensional Models with Focus on Dimension Hierarchy Sharing. In: El-Alfy, ES., Thampi, S., Takagi, H., Piramuthu, S., Hanne, T. (eds) Advances in Intelligent Informatics. Advances in Intelligent Systems and Computing, vol 320. Springer, Cham. https://doi.org/10.1007/978-3-319-11218-3_39
Download citation
DOI: https://doi.org/10.1007/978-3-319-11218-3_39
Publisher Name: Springer, Cham
Print ISBN: 978-3-319-11217-6
Online ISBN: 978-3-319-11218-3
eBook Packages: EngineeringEngineering (R0)