Applying Transformations to Model Driven Data Warehouses

In the past few years, several conceptual approaches have been proposed for the specification of the main multidimensional (MD) properties of the data warehouse (DW) repository. However, these approaches often fail in providing mechanisms to univocally and automatically derive a logical representation of the MD conceptual model. To overcome this limitation, we present an approach to align the MD modeling of the DW repository with the Model Driven Architecture (MDA) by formally defining a set of Query/View/Transformation (QVT) transformation rules which allow us to obtain a logical representation of the MD conceptual model in an automatic way. Finally, we show how to implement our approach in an MDA-compliant commercial tool.

[1]  Anneke Kleppe,et al.  MDA explained - the Model Driven Architecture: practice and promise , 2003, Addison Wesley object technology series.

[2]  Carlos José Pereira de Lucena,et al.  Developing Multi-Agent Systems Based on MDA , 2005, CAiSE Short Paper Proceedings.

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

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

[5]  Jean Vanderdonckt,et al.  A MDA-Compliant Environment for Developing User Interfaces of Information Systems , 2005, CAiSE.

[6]  Nora Koch,et al.  Improving Web Design Methods with Architecture Modeling , 2005, EC-Web.

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

[8]  Juan Trujillo,et al.  A Standard for Representing Multidimensional Properties: The Common Warehouse Metamodel (CWM) , 2002, ADBIS.

[9]  José Samos,et al.  A Framework for the Classification and Description of Multidimensional Data Models , 2001, DEXA.

[10]  W. H. Inmon,et al.  Building the Data Warehouse,3rd Edition , 2002 .

[11]  Nectaria Tryfona,et al.  starER: a conceptual model for data warehouse design , 1999, DOLAP '99.

[12]  Jean Bézivin,et al.  Applying MDA approach for Web service platform , 2004, Proceedings. Eighth IEEE International Enterprise Distributed Object Computing Conference, 2004. EDOC 2004..

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