Abstract
The development of data warehouses (DW) is still complex and costly. In recent years, a growing number of contributions suggested the application of Model-Driven Architecture (MDA) to DW development. However, most of these approaches are not evaluated in practice. Therefore, we conducted an evaluation of the Multidimensional Model-Driven Architecture (MD²A), based on a case study derived from a real-world DW project. The case study results can be summarized as follows: The suggested full-automatic transformation of conceptual schemas is not feasible under all circumstances. Necessary performance optimizations in the logical level cannot be derived from the conceptual. Additionally, we can conclude that the integration of evolution concepts into an MDA approach for DWs is desirable for two reasons: First, when conceptual schemas are changed and transformed into the logical level, previously made manual optimizations have to be conserved. Second, transformations from the logical level to code have to consider the protection of historicized data.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Inmon, W.H.: Building the data warehouse, 4th edn., pp. 29–70. Wiley, Indianapolis (2005)
Fernandes, L.A., Neto, B.H., Fagundes, V., Zimbrao, G., de Souza, J.M., Salvador R.: Model-Driven Architecture Approach for Data Warehouse. In: 2010 Sixth International Conference on Autonomic and Autonomous Systems, pp. 156–161 (2010)
Gluchowski, P., Kurze, C., Schieder, C.: A Modeling Tool for Multidimensional Data using the ADAPT Notation. In: Proceedings of the 42nd Hawaii International Conference on System Sciences, pp. 1–10 (2009)
Zepeda, L., Cecena, E., Quintero, R., Zatarain, R., Vega, L., Mora, Z., Clemente, G.G.: A MDA Tool for Data Warehouse. In: Proceedings of the 2010 International Conference on Computational Science and Its Applications, pp. 261–265. IEEE Computer Society (2010)
Choura, H., Feki, J.: MDA Compliant Approach for Data Mart Schemas Generation. In: Bellatreche, L., Mota Pinto, F. (eds.) MEDI 2011. LNCS, vol. 6918, pp. 262–269. Springer, Heidelberg (2011)
Mazón, J.-N., Trujillo, J., Serrano, M., Piattini, M.: Applying MDA to the development of data warehouses. In: Proceedings of the 8th ACM International Workshop on Data Ware-Housing and OLAP, pp. 57–66. ACM, Bremen (2005)
Luján-Mora, S., Trujillo, J.: A Data Warehouse Engineering Process. In: Yakhno, T. (ed.) ADVIS 2004. LNCS, vol. 3261, pp. 14–23. Springer, Heidelberg (2004)
Soler, E., Trujillo, J., Fernández-Medina, E., Piattini, M.: A set of QVT relations to transform PIM to PSM in the Design of Secure Data Warehouses. In: Second International Conference on Availability, Reliability and Security, pp. 644–654 (2007)
Mazón, J.-N., Trujillo, J., Lechtenbörger, J.: A set of QVT relations to assure the correctness of data warehouses by using multidimensional normal forms. In: Proceedings of the 25th International Conference on Conceptual Modeling, pp. 385–398. Springer, Tucson (2006)
Glorio, O., Trujillo, J.: An MDA Approach for the Development of Spatial Data Warehouses. In: Proceedings of the 10th International Conference on Data Warehousing and Knowledge Discovery, pp. 23–32. Springer, Turin (2008)
Mazón, J.-N., Pardillo, J., Trujillo, J.: Applying transformations to model driven data warehouses. In: Proceedings of the 8th International Conference on Data Warehousing and Knowledge Discovery, pp. 13–22. Springer, Krakow (2006)
Rizzi, S., Abelló, A., Lechtenbörger, J., Trujillo, J.: Research in data warehouse modeling and design: dead or alive? In: Proceedings of the 9th ACM International Workshop on Data Warehousing and OLAP, pp. 3–10. ACM, Arlington (2006)
Golfarelli, M., Rizzi, S., Pagliarani, C.: Data Warehouse Design. In: Modern Principles and Methodologies, pp. 43–60. McGraw-Hill, New York (2009)
Golfarelli, M., Rizzi, S.: A methodological framework for data warehouse design. In: Proceedings of the 1st ACM International Workshop on Data Warehousing and OLAP, pp. 3–9. ACM, Washington, D.C. (1998)
Kimball, R., Ross, M.: The data warehouse toolkit. The complete guide to dimensional modeling. Wiley, New York (2002)
Object Management Group: MDA Guide Version 1.0.1, http://www.omg.org/cgi-bin/doc?omg/03-06-01.pdf
Luján-Mora, S., Trujillo, J., Song, I.-Y.: A UML profile for multidimensional modeling in data warehouses. Data & Knowledge Engineering 59, 725–769 (2006)
Object Management Group: Common Warehouse Metamodel (CWM) Specification, http://www.omg.org/spec/CWM/1.1/PDF/
Object Management Group: Meta Object Facility (MOF) 2.0 Query/View/Transformation Specification, http://www.omg.org/spec/QVT/1.1/PDF/
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2012 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Benker, T., Jürck, C. (2012). A Case Study on Model-Driven Data Warehouse Development. In: Cuzzocrea, A., Dayal, U. (eds) Data Warehousing and Knowledge Discovery. DaWaK 2012. Lecture Notes in Computer Science, vol 7448. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-32584-7_5
Download citation
DOI: https://doi.org/10.1007/978-3-642-32584-7_5
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-32583-0
Online ISBN: 978-3-642-32584-7
eBook Packages: Computer ScienceComputer Science (R0)