Applying Transformations to Model Driven Data Warehouses

  • Jose-Norberto Mazón
  • Jesús Pardillo
  • Juan Trujillo
Part of the Lecture Notes in Computer Science book series (LNCS, volume 4081)


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.


Transformation Rule Data Warehouse Object Constraint Language Logical Representation Object Management Group 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    Kimball, R., Ross, M.: The Data Warehouse Toolkit. John Wiley & Sons, Chichester (2002)Google Scholar
  2. 2.
    Inmon, W.: Building the Data Warehouse. Wiley & Sons, New York (2002)Google Scholar
  3. 3.
    Abelló, A., Samos, J., Saltor, F.: A framework for the classification and description of multidimensional data models. In: Mayr, H.C., Lazanský, J., Quirchmayr, G., Vogel, P. (eds.) DEXA 2001. LNCS, vol. 2113, pp. 668–677. Springer, Heidelberg (2001)CrossRefGoogle Scholar
  4. 4.
    Golfarelli, M., Rizzi, S.: Methodological framework for data warehouse design. In: DOLAP, pp. 3–9. ACM Press, New York (1998)Google Scholar
  5. 5.
    Tryfona, N., Busborg, F., Christiansen, J.G.B.: starER: A conceptual model for data warehouse design. In: DOLAP, pp. 3–8. ACM Press, New York (1999)Google Scholar
  6. 6.
    Luján-Mora, S., Trujillo, J., Song, I.Y.: A UML profile for multidimensional modeling in data warehouses. Data & Knowledge Engineering (in press)Google Scholar
  7. 7.
    Mazón, J.N., Trujillo, J., Serrano, M., Piattini, M.: Applying MDA to the development of data warehouses. In: DOLAP, pp. 57–66. ACM Press, New York (2005)CrossRefGoogle Scholar
  8. 8.
    Object Management Group: MDA Guide 1.0.1 (visited March 2006),
  9. 9.
    Object Management Group: MOF 2.0 Query/Views/Transformations (visited March 2006),
  10. 10.
    Borland Together (visited March 2006),
  11. 11.
    Oracle (visited March 2006),
  12. 12.
    Object Management Group: Unified Modeling Language Specification 2.0 (visited March 2006),
  13. 13.
    Bézivin, J., Hammoudi, S., Lopes, D., Jouault, F.: Applying MDA approach for web service platform. In: EDOC, pp. 58–70. IEEE Computer Society Press, Los Alamitos (2004)Google Scholar
  14. 14.
    Meliá, S., Gómez, J., Koch, N.: Improving web design methods with architecture modeling. In: Bauknecht, K., Pröll, B., Werthner, H. (eds.) EC-Web 2005. LNCS, vol. 3590, pp. 53–64. Springer, Heidelberg (2005)CrossRefGoogle Scholar
  15. 15.
    Vanderdonckt, J.: A MDA-compliant environment for developing user interfaces of information systems. In: Pastor, Ó., Falcão e Cunha, J. (eds.) CAiSE 2005. LNCS, vol. 3520, pp. 16–31. Springer, Heidelberg (2005)CrossRefGoogle Scholar
  16. 16.
    Maria, B.A.D., da Silva, V.T., de Lucena, C.J.P.: Developing multi-agent systems based on MDA. In: CAiSE Short Paper Proceedings. CEUR Workshop Proceedings, vol. 161 (2005),
  17. 17.
    Poole, J.: Model Driven Data Warehousing (MDDW) (March 2006),
  18. 18.
    Object Management Group: Common Warehouse Metamodel (CWM) Specification 1.1 (March 2006),
  19. 19.
    Medina, E., Trujillo, J.: A standard for representing multidimensional properties: The Common Warehouse Metamodel (CWM). In: Manolopoulos, Y., Návrat, P. (eds.) ADBIS 2002. LNCS, vol. 2435, pp. 232–247. Springer, Heidelberg (2002)CrossRefGoogle Scholar
  20. 20.
    Mazón, J.N., Trujillo, J., Serrano, M., Piattini, M.: Designing data warehouses: from business requirement analysis to multidimensional modeling. In: REBNITA, pp. 44–53. University of New South Wales Press (2005)Google Scholar
  21. 21.
    Object Management Group: Object Constraint Language (OCL) Specification 2.0 (visited March 2006),
  22. 22.
    Object Management Group: Common Warehouse Metamodel (CWM) Specification 1.1, vol. 2. Extensions (visited March 2006),
  23. 23.
    Kleppe, A., Warmer, J., Bast, W.: MDA Explained. The Practice and Promise of The Model Driven Architecture. Addison-Wesley, Reading (2003)Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2006

Authors and Affiliations

  • Jose-Norberto Mazón
    • 1
  • Jesús Pardillo
    • 1
  • Juan Trujillo
    • 1
  1. 1.Dept. of Software and Computing SystemsUniversity of AlicanteSpain

Personalised recommendations