Multidimensional Design Paradigms for Data Warehouses: A Systematic Mapping Study

Ania Cravero, Samuel Sepúlveda

System Engineering Department, La Frontera University, Temuco, Chile.

DOI: 10.4236/jsea.2014.71006                

Abstract

Data warehouses (DW) must integrate information from the different areas and sources of an organization in order to extract knowledge relevant to decision-making. The DW development is not an easy task, which is why various design approaches have been put forward. These approaches can be classified in three different paradigms according to the origin of the information requirements: supply-driven, demand-driven, and hybrids of these. This article compares the methodologies for the multidimensional design of DW through a systematic mapping as research methodology. The study is presented for each paradigm, the main characteristics of the methodologies, their notations and problem areas exhibited in each one of them. The results indicate that there is no follow-up to the complete process of implementing a DW in either an academic or industrial environment; however, there is also no evidence that the attempt is made to address the design and development of a DW by applying and comparing different methodologies existing in the field.

Keywords

Multidimensional Design; Paradigms; Data Warehouses; Systematic Mapping

Conflicts of Interest

The authors declare no conflicts of interest.

References

[1]	P. Giorgini, S. Rizzi and M. Garzetti, “Goal Oriented Requirement Analysis for Data Warehouse Design,” DOLAP’05, Proceedings of the 8th ACM International Workshop on Data Warehousing and OLAP, Bremen, Vol. 45, 2005, pp. 47-56.
[2]	R. Kimball and M. Ross, “The Data Warehouse Toolkit,” 2nd Edition, John Wiley & Sons, Chichester, 2002.
[3]	M. Frolick and K. Winter, “Critical Factors for Data Warehouse Failure,” Business Intelligence Journal, Vol. 8, No. 1, 2003, pp. 61-71. http://www.tdwi.org/research/display.aspx?ID=6592
[4]	A. Cravero, S. Sepúlveda, J.-N. Mazón and J. Trujillo, “Alineamiento de Objetivos de la Organización: Una Necesidad para el Análisis de Requisitos en Almacenes de Datos,” CIBSE2010, 2010.
[5]	O. Romero and A. Abello, “A Survey of Multidimensional Modeling Methodologies,” International Journal of Data Warehousing & Mining (IJDWM), Vol. 5, No. 2, 2009, pp. 1-23. http://dx.doi.org/10. 4018/jdwm.2009040101
[6]	R. Winter and B. Strauch, “A Method for Demand Driven Information Requirements Analysis in Data Warehousing Projects,” Proceedings of the 36th Annual Hawaii International Conference on System Sciences, 2003, pp. 9-14.
[7]	B. Kitcheham, T. Dyba and M. Jorgensen, “Evidence-Based Software Engineering,” Proceeding of the 26th International Conference on Software Engineering (ICSE, 2006), IEEE Computer Society, 2006, pp. 373-378.
[8]	N. Prakash and A. Gosain, “An Approach to Engineering the Requirements of Data Warehouses,” Requirements Engineering, Vol. 13, No. 1, 2008, pp. 49-72. http://dx.doi.org/10.1007/s00766-007-0057-x
[9]	S. Rizzi, A. Abelló, J. Lechtenb?rger and J. Trujillo, “Research in Data Warehouse Modeling and Design: Dead or Alive?” Proceedings of the 9th ACM International Workshop on Data Warehousing and OLAP, Arlington, 2006, pp. 3-10.
[10]	B. List, R. M. Bruckner, K. Machaczek and J. Schiefer, “A Comparison of Data Warehouse Development Methodologies Case Study of the Process Warehouse,” In A. Hameurlain, R. Cicchetti and R. Traunmüller, Eds., Proceedings of 13th International Conference on Database and Expert Systems Applications, Lecture Notes in Computer Science, Aix-en-Provence, Vol. 2453, 2002, pp. 203-215.
[11]	M. Golfarelli, “From User Requirements to Conceptual Design in Data Warehouse Design,” Data Warehousing Design and Advanced Engineering Applications: Methods for Complex Construction, 2010, p. 1.
[12]	P. Giorgini, S. Rizzi and M. Garzetti, “GRAnD: A GoalOriented Approach to Requirement Analysis in Data Warehouses,” Decision Support Systems, Vol. 45, No. 1, 2008, pp. 4-21. http://dx.doi.org/10. 1016/j.dss.2006.12.001
[13]	R. Weir, T. Peng and J. Kerridge, “Best Practice for Implementing a Data Warehouse: A Review for Strategic Alignment,” School of Computing, Napier University, Edinburgh, 2003.
[14]	W. Inmon, “Building the Data Warehouse,” 2nd Edition, 1996.
[15]	E. Codd, S. Codd and C. Salley, “Providing OLAP to User-Analysts: An IT Mandate, E. F. Codd and Associates,” 1993.
[16]	F. Silva-Paim and J. F. B.-Castro, “DWARF: AN Approach for Requirements Definition and Management of Data Warehouse Systems,” Proceedings of the Requirements Engineering Conference, RE’03, 11th IEEE International, 2003, pp. 75-84.
[17]	K. Petersen, R. Feldt, S. Mujtaba and M. Mattsson, “Systematic Mapping Studies in Software Engineering,” EASE’08 Proceedings of the 12th International Conference on Evaluation and Assessment in Software Engineering. British Computer Society Swinton, 2008, pp. 68-77.
[18]	B. Kitchenham and S. Charters, “Guidelines for Performing Systematic Literature Reviews in Software Engineering,” Technical Report EBSE’07, 2007.
[19]	K. Gwet, “Inter-Rater Reliability: Dependency on Trait Prevalence and Marginal Homogeneity,” Statistical Methods for Inter-Rater Reliability Assessment Series, Vol. 2, 2002, pp. 1-9.
[20]	P. Hernández, I. Garrigos and J.-N. Mazón, “Model-Driven Development of Multidimensional Models from Web Log Files,” Advances in Conceptual Modeling—Applications and Challenges, 2010, pp. 170-179.
[21]	F. Di-Tria, E. Lefons and F. Tangorra, “Hybrid Methodology for Data Warehouse Conceptual Design by UML Schemas,” Information and Software Technology, Vol. 54, No. 4, 2012, pp. 360-379. http://dx.doi.org/10.1016/j.infsof.2011.11.004
[22]	J. N. Mazón, J. Pardillo and J. Trujillo, “A Model Driven Goal Oriented Requirement Engineering Approach for Data Warehouses,” ER Workshops (RIGiM), 2007.
[23]	P. Giorgini, S. Rizzi and M. Garzetti, “Goal Oriented Requirement Analysis for Data Warehouse Design,” DOLAP’05, Bremen, Vol. 45, 2005, pp. 47-56.
[24]	A. Bonifati, F. Cattaneo, S. Ceri, A. Fuggetta and F. Paraboschi, “Designing Data Marts for Data Warehouses,” ACM Transactions on Software Engineering and Methodology, Vol. 10, No. 4, 2001, pp. 452-483. http://dx.doi.org/10.1145/384189.384190
[25]	A. Cravero, J.-N. Mazón and J. Trujillo, “A Business-Oriented Approach to Data Warehouse Development,” Ingeniería e Investigación, Vol. 33, No. 1, 2013, pp. 59-65.
[26]	OMG, “Business Motivation Model. Version 1.1,” OMG Document Number: Formal/2010-05-01, 2008.
[27]	O. Romero and A. Abelló, “Multidimensional Design Methods for Data Warehousing,” Integrations of Data Warehousing, Data Mining and Database Technologies: Innovative Approaches, 2011, p. 78.
[28]	O. Glorio, J. Pardillo, J.-N. Mazón and J. Trujillo, “DaWaRA: An Eclipse Plugin for Usingi* on Data Warehouse Requirement Analysis,” RE’08, 2008, pp. 317-318.
[29]	M. Thenmozhi and K. Vivekanandan, “An Ontology Based Hybrid Approach to Derive Multidimensional Schema for Data Warehouse,” International Journal of Computer Applications, Vol. 54, No. 8, 2012, pp. 36-42.
[30]	J.-N. Mazón and J. Trujillo, “An MDA Approach for the Development of Data Warehouses,” JISBD’09, 2009, p. 208.
[31]	R. Jindal and S. Taneja, “Comparative Study of Data Warehouse Design Approaches: A Survey,” International Journal of Database Management Systems, Vol. 4, No. 1, 2012, pp. 33-45.
[32]	A. Cravero and S. Sepúlveda, “A Chronological Study of Paradigms for Data Warehouse Design,” Ingeniería e Investigación, Vol. 32, No. 2, 2012, pp. 58-62.