A BPMN-Based Design and Maintenance Framework for ETL Processes
Por favor, use este identificador para citar o enlazar este ítem:
http://hdl.handle.net/10045/40213
Título: | A BPMN-Based Design and Maintenance Framework for ETL Processes |
---|---|
Autor/es: | El Akkaoui, Zineb | Zimányi, Esteban | Mazón, Jose-Norberto | Trujillo, Juan |
Grupo/s de investigación o GITE: | Web and Knowledge (WaKe) | Lucentia |
Centro, Departamento o Servicio: | Universidad de Alicante. Departamento de Lenguajes y Sistemas Informáticos |
Palabras clave: | Data warehouses | ETL process | Conceptual model | Code generation | Maintenance | Model-driven development |
Área/s de conocimiento: | Lenguajes y Sistemas Informáticos |
Fecha de publicación: | 2013 |
Editor: | IGI Global |
Cita bibliográfica: | International Journal of Data Warehousing and Mining. 2013, 9(3): 46-72. doi:10.4018/jdwm.2013070103 |
Resumen: | Business Intelligence (BI) applications require the design, implementation, and maintenance of processes that extract, transform, and load suitable data for analysis. The development of these processes (known as ETL) is an inherently complex problem that is typically costly and time consuming. In a previous work, we have proposed a vendor-independent language for reducing the design complexity due to disparate ETL languages tailored to specific design tools with steep learning curves. Nevertheless, the designer still faces two major issues during the development of ETL processes: (i) how to implement the designed processes in an executable language, and (ii) how to maintain the implementation when the organization data infrastructure evolves. In this paper, we propose a model-driven framework that provides automatic code generation capability and ameliorate maintenance support of our ETL language. We present a set of model-to-text transformations able to produce code for different ETL commercial tools as well as model-to-model transformations that automatically update the ETL models with the aim of supporting the maintenance of the generated code according to data source evolution. A demonstration using an example is conducted as an initial validation to show that the framework covering modeling, code generation and maintenance could be used in practice. |
URI: | http://hdl.handle.net/10045/40213 |
ISSN: | 1548-3924 (Print) | 1548-3932 (Online) |
DOI: | 10.4018/jdwm.2013070103 |
Idioma: | eng |
Tipo: | info:eu-repo/semantics/article |
Derechos: | Copyright © 2013, IGI Global |
Revisión científica: | si |
Versión del editor: | http://dx.doi.org/10.4018/jdwm.2013070103 |
Aparece en las colecciones: | INV - WaKe - Artículos de Revistas INV - LUCENTIA - Artículos de Revistas |
Archivos en este ítem:
Archivo | Descripción | Tamaño | Formato | |
---|---|---|---|---|
2013_El-Akkaoui_IJDWM.pdf | 1,05 MB | Adobe PDF | Abrir Vista previa | |
Todos los documentos en RUA están protegidos por derechos de autor. Algunos derechos reservados.