A Case Study on Model-Driven Data Warehouse Development

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.

[1]  Jose-Norberto Mazón,et al.  Applying Transformations to Model Driven Data Warehouses , 2006, DaWaK.

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

[3]  Tatyana Yakhno,et al.  Advances in Information Systems , 2002, Lecture Notes in Computer Science.

[4]  Matteo Golfarelli,et al.  Data Warehouse Design: Modern Principles and Methodologies , 2009 .

[5]  Juan Trujillo,et al.  A Data Warehouse Engineering Process , 2004, ADVIS.

[6]  Ralph Kimball,et al.  The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling , 1996 .

[7]  Torben Bach Pedersen,et al.  Building a web warehouse for accessibility data , 2006, DOLAP '06.

[8]  Peter Gluchowski,et al.  A Modeling Tool for Multidimensional Data using the ADAPT Notation , 2009 .

[9]  Jamel Feki,et al.  MDA Compliant Approach for Data Mart Schemas Generation , 2011, MEDI.

[10]  Jim Steel,et al.  MOF QVT final adopted specification: meta object facility (MOF) 2.0 query/view/transformation specification. , 2005 .

[11]  Il-Yeol Song,et al.  A UML profile for multidimensional modeling in data warehouses , 2006, Data Knowl. Eng..

[12]  Alberto Abelló,et al.  Research in data warehouse modeling and design: dead or alive? , 2006, DOLAP '06.

[13]  Ramón Zataraín-Cabada,et al.  A MDA Tool for Data Warehouse , 2010, 2010 International Conference on Computational Science and Its Applications.

[14]  Juan Trujillo,et al.  An MDA Approach for the Development of Spatial Data Warehouses , 2008, DaWaK.

[15]  Helmut Krcmar,et al.  Data Warehouse Design , 2008 .

[16]  Mario Piattini,et al.  Applying MDA to the development of data warehouses , 2005, DOLAP '05.

[17]  Jose-Norberto Mazón,et al.  A Set of QVT Relations to Assure the Correctness of Data Warehouses by Using Multidimensional Normal Forms , 2006, ER.

[18]  Matteo Golfarelli,et al.  A methodological framework for data warehouse design , 1998, DOLAP '98.

[19]  Eric Yu,et al.  Proceedings of the 27th International Conference on Conceptual Modeling , 2002 .

[20]  Mario Piattini,et al.  A set of QVT relations to transform PIM to PSM in the Design of Secure Data Warehouses , 2007, The Second International Conference on Availability, Reliability and Security (ARES'07).

[21]  Jano Moreira de Souza,et al.  Model-Driven Architecture Approach for Data Warehouse , 2010, 2010 Sixth International Conference on Autonomic and Autonomous Systems.