Abstract
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.
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
Kimball, R., Ross, M.: The Data Warehouse Toolkit. John Wiley & Sons, Chichester (2002)
Inmon, W.: Building the Data Warehouse. Wiley & Sons, New York (2002)
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)
Golfarelli, M., Rizzi, S.: Methodological framework for data warehouse design. In: DOLAP, pp. 3–9. ACM Press, New York (1998)
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)
Luján-Mora, S., Trujillo, J., Song, I.Y.: A UML profile for multidimensional modeling in data warehouses. Data & Knowledge Engineering (in press)
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)
Object Management Group: MDA Guide 1.0.1 (visited March 2006), http://www.omg.org/cgi-bin/doc?omg/03-06-01
Object Management Group: MOF 2.0 Query/Views/Transformations (visited March 2006), http://www.omg.org/cgi-bin/doc?ptc/2005-11-01
Borland Together (visited March 2006), http://www.borland.com/together
Oracle (visited March 2006), http://www.oracle.com
Object Management Group: Unified Modeling Language Specification 2.0 (visited March 2006), http://www.omg.org/cgi-bin/doc?formal/05-07-04
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)
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)
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)
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), CEUR-WS.org
Poole, J.: Model Driven Data Warehousing (MDDW) (March 2006), http://www.cwmforum.org/POOLEIntegrate2003.pdf
Object Management Group: Common Warehouse Metamodel (CWM) Specification 1.1 (March 2006), http://www.omg.org/cgi-bin/doc?formal/03-03-02
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)
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)
Object Management Group: Object Constraint Language (OCL) Specification 2.0 (visited March 2006), http://www.omg.org/cgi-bin/doc?ptc/03-10-14
Object Management Group: Common Warehouse Metamodel (CWM) Specification 1.1, vol. 2. Extensions (visited March 2006), http://www.omg.org/cgi-bin/doc?ad/2001-02-02
Kleppe, A., Warmer, J., Bast, W.: MDA Explained. The Practice and Promise of The Model Driven Architecture. Addison-Wesley, Reading (2003)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2006 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Mazón, JN., Pardillo, J., Trujillo, J. (2006). Applying Transformations to Model Driven Data Warehouses. In: Tjoa, A.M., Trujillo, J. (eds) Data Warehousing and Knowledge Discovery. DaWaK 2006. Lecture Notes in Computer Science, vol 4081. Springer, Berlin, Heidelberg. https://doi.org/10.1007/11823728_2
Download citation
DOI: https://doi.org/10.1007/11823728_2
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-37736-8
Online ISBN: 978-3-540-37737-5
eBook Packages: Computer ScienceComputer Science (R0)