The Specification of ETL Transformation Operations based on Weaving Models
Keywords:
ETL process, MDD, Weaving modelsAbstract
In the ETL process the transformation of data is achieved through the execution of a set of transformation operations. The realization of this process (the order in which the transformation operations must be executed) should be preceded by a specification of the transformation process at a higher level of abstraction. The specification is given through mappings representing abstract operations specific to the transformation process. These mappings are defined through weaving models and metamodels. A generated weaving metamodel (GWMM) is proposed giving the complete mapping semantics through specific link types (representing the abstract operations) and appropriate OCL constraints. Weaving models specifying the actual mappings must be in accordance with this proposed GWMM.
References
Del Fabro, M.D., Bézivin, J., Jouault, F., Valduriez, P., Applying Generic Model Management to Data Mapping. In proc. of Base de Donnes Avances (BDA 2005), France, 2005.
Del Fabro, M.D., Valduriez, P., Semi-automatic model integration using matching transformations and weaving models. In proc. of symposium on Applied computing, ACM, 2007.
Del Fabro, M.D., Bézivin, J, and Valduriez, P., Weaving Models with the Eclipse AMW plugin. In: Eclipse Modeling Symposium, Eclipse Summit Europe 2006, Germany, 2006.
Miller, J., Mukerji, J., Model Driven Architecture (MDA). http://www.omg.org; 2001.
Nešković, S., VuÄković, M., AniÄić, N., On Using Weaving Models to Specify Schema Mappings. 2nd Intl Workshop on Future Trends of Model-Driven Development, Portugal, 2010.
AniÄić, N., Nešković, S., VuÄković, M., Cvetković, R., Specification of Data Schema Mappings using Weaving Models. Paper accepted for publication in ComSiS Journal, March 2012.
Golfarelli M., Rizzi, S., Data Warehouse Design: Modern Principles and Methodologies. McGraw-Hill, ISBN-13: 978-0071610391, 2009.
Kurz, S., Guppenberger, M., Freitag, B., A UML profile for modeling schema mappings. In Proc. of the intl. conf. on Advances in Conceptual Modeling, (pp. 53-62), Springer, 2006.
El Akkaoui, Z., Zimányi, E., Mazón, J.-N., Trujillo, J., A model-driven framework for ETL process development. In Proc. of 14th intl. workshop on DW and OLAP, ACM, 2011.
Lujan-Mora, S., Vassiliadis, P., Trujillo, J., Data Mapping Diagrams for Data Warehouse Design with UML. In Proc. 23rd Intl. Conf. on Conceptual Modeling, Springer, 2004.
Trujillo, J., Luján-Mora, S., A UML Based Approach for Modeling ETL Processes in Data Warehouses. Conceptual Modeling - ER 2003, (pp. 307-320), Springer-Verlag, 2003.
Simitsis, A., Mapping conceptual to logical models for ETL processes. In Proc. of the 8th ACM international workshop on Data warehousing and OLAP, (pp. 67-76), ACM, 2005. http://dx.doi.org/10.1145/1097002.1097014
Published
Issue
Section
License
ONLINE OPEN ACCES: Acces to full text of each article and each issue are allowed for free in respect of Attribution-NonCommercial 4.0 International (CC BY-NC 4.0.
You are free to:
-Share: copy and redistribute the material in any medium or format;
-Adapt: remix, transform, and build upon the material.
The licensor cannot revoke these freedoms as long as you follow the license terms.
DISCLAIMER: The author(s) of each article appearing in International Journal of Computers Communications & Control is/are solely responsible for the content thereof; the publication of an article shall not constitute or be deemed to constitute any representation by the Editors or Agora University Press that the data presented therein are original, correct or sufficient to support the conclusions reached or that the experiment design or methodology is adequate.
