ETL process modeling conceptual for data warehouses: a systematic mapping study
Por favor, use este identificador para citar o enlazar este ítem:
http://hdl.handle.net/10045/21179
Título: | ETL process modeling conceptual for data warehouses: a systematic mapping study |
---|---|
Autor/es: | Muñoz, Lilia | Mazón, Jose-Norberto | Trujillo, Juan |
Grupo/s de investigación o GITE: | Lucentia |
Centro, Departamento o Servicio: | Universidad de Alicante. Departamento de Lenguajes y Sistemas Informáticos |
Palabras clave: | ETL process | Modeling conceptual | Data warehouse | Systematic mapping studies |
Área/s de conocimiento: | Lenguajes y Sistemas Informáticos |
Fecha de publicación: | jun-2011 |
Editor: | IEEE |
Cita bibliográfica: | MUÑOZ, L.; MAZÓN, J.N.; TRUJILLO, J. "ETL process modeling conceptual for data warehouses: a systematic mapping study". Revista IEEE América Latina. Vol. 9, Issue 3 (June 2011). ISSN 1548-0992, pp. 358-363 |
Resumen: | BACKGROUND: A data warehouse (DW) is an integrated collection of subject-oriented data in the support of decision making. Importantly, the integration of data sources is achieved through the use of ETL (Extract, Transform, and Load) processes. It is therefore extensively recognized that the appropriate design of the ETL processes are key factors in the success of DW projects. OBJECTIVE: We assess existing research proposals about ETL process modeling for data warehouse in order to identify their main characteristics, notation, and activities. We also study if these modeling approaches are supported by some kind of prototype or tool. METHOD: We have undertaken a systematic mapping study of the research literature about modeling ETL processes. A mapping study provides a systematic and objective procedure for identifying the nature and extent of the available research by means of research questions. RESULTS: The study is based on a comprehensive set of papers obtained after using a multi-stage selection criteria and are published in international workshops, conferences and journals between 2000 and 2009. CONCLUSIONS: This systematic mapping study states that there is a clear classification of ETL process modeling approaches, but that they are not enough covered by researchers. Therefore, more effort is required to bridge the research gap in modeling ETL processes. |
Patrocinador/es: | Este trabajo es soportado por los proyectos ESPIA (TIN2007-67078) del Ministerio de Educación y Ciencia de España y QUASIMODO (PAC08-0157-0668) de la Consejería de Educación y Ciencia de Castilla-La Mancha, España. Lilia Muñoz dispone de una beca de la Secretaria Nacional de Ciencia, Tecnología e Innovación (SENACYT) y el Instituto para la Formación y Aprovechamiento de Recursos Humanos (IFARHU), de la República de Panamá. |
URI: | http://hdl.handle.net/10045/21179 |
ISSN: | 1548-0992 |
DOI: | 10.1109/TLA.2011.5893784 |
Idioma: | spa |
Tipo: | info:eu-repo/semantics/article |
Derechos: | © Copyright 2011 IEEE – All Rights Reserved |
Revisión científica: | si |
Versión del editor: | http://dx.doi.org/10.1109/TLA.2011.5893784 |
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 | |
---|---|---|---|---|
9TLA3_18Munoz.pdf | Versión revisada (acceso abierto) | 253,63 kB | Adobe PDF | Abrir Vista previa |
9TLA3_18Munoz_final.pdf | Versión final (acceso restringido) | 470,66 kB | Adobe PDF | Abrir Solicitar una copia |
Todos los documentos en RUA están protegidos por derechos de autor. Algunos derechos reservados.