• ¿Qué es UTP-Ridda2?
  • Políticas
  • ¿Cómo Depositar?
  • Estadísticas
Repositorio Institucional
de la Universidad Tecnológica de Panamá
    • English
    • español
  • English 
    • English
    • español
  • Login
View Item 
  •   UTP-Ridda2
  • Investigación
  • Ingeniería en computación e informática
  • Facultad de Ingeniería de Sistemas Computacionales
  • View Item
  •   UTP-Ridda2
  • Investigación
  • Ingeniería en computación e informática
  • Facultad de Ingeniería de Sistemas Computacionales
  • View Item
JavaScript is disabled for your browser. Some features of this site may not work without it.

ETL Process Modeling Conceptual for Data Warehouses: A Systematic Mapping Study

Thumbnail
Date
06/16/2011
06/16/2011
Author
Muñoz, Lilia
Mazón, Jose Norberto
Juan, Trujillo
Metadata
Show full item record
Abstract
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.
URL
https://ieeexplore.ieee.org/abstract/document/5893784/
URI
http://ridda2.utp.ac.pa/handle/123456789/4918
http://ridda2.utp.ac.pa/handle/123456789/4918
Collections
  • Facultad de Ingeniería de Sistemas Computacionales [191]
License
info:eu-repo/semantics/embargoedAccess

Related items

Showing items related by title, author, creator and subject.

  • Systematic review and comparison of modeling ETL processes in data warehouse 

    Muñoz, Lilia; Mazón, Jose Norberto; Trujillo, Juan (08/23/2010)
    Abstract: In a Data Warehouse (DW), ETL processes (Extraction, Transformation, Load) are responsible for extracting, transforming and loading data from the data sources into the DW. A good design of these processes in the ...
  • Décomposition d’Images Fondée sur l’Analyse de la Régularité Locale: Application au Codage Hybride d’Image 

    Merchán, Fernando; Turcu, Flavius; Najim, Mohamed (2016-07-01)
    La représentation hybride d'image utilise conjointement la décomposition en ondelettes pour l'information structurée et la modélisation paramétrique pour les textures. Dans ce cadre, nous proposons un algorithme qui décompose ...
  • A family of experiments to validate measures for UML activity diagrams of ETL processes in data warehouses 

    Muñoz, Lilia; Mazón, Jose Norberto; Trujillo, Juan (11/01/2010)
    In data warehousing, Extract, Transform, and Load (ETL) processes are in charge of extracting the data from the data sources that will be contained in the data warehouse. Their design and maintenance is thus a cornerstone ...

Browse

All of UTP-Ridda2Communities & CollectionsBy Issue DateAuthorsTitlesSubjectsThis CollectionBy Issue DateAuthorsTitlesSubjects

My Account

LoginRegister

Statistics

View Usage Statistics

  • Enlaces de Interes

  • ¿Qué es UTP-Ridda2?
  • Políticas
  • ¿Cómo depositar?
  • Sitios Recomendados

  • Revistas UTP
  • Sistema de Información Científica
  • Universidad Tecnológica de Panamá
  • Redes Sociales

  • facebook.com/UTPrepositorio
  • @utprepositorio

Recolectado por:

El OAI de este repositorio: http://ridda2.utp.ac.pa/oai/
Repositorio Institucional de Documentos Digitales de Acceso Abierto de la Universidad de Tecnológica de Panamá.
Este repositorio utiliza la Licencia CC BY-NC-SA y funciona bajo DSpace.

Contact Us | Send Feedback
Universidad Tecnológica de Panamá

  • Enlaces de Interes

  • ¿Qué es UTP-Ridda2?
  • Políticas
  • ¿Cómo depositar?
  • Sitios Recomendados

  • Revistas UTP
  • Sistema de Información Científica
  • Universidad Tecnológica de Panamá
  • Redes Sociales

  • facebook.com/UTPrepositorio
  • @utprepositorio

Recolectado por:

El OAI de este repositorio: http://ridda2.utp.ac.pa/oai/
Repositorio Institucional de Documentos Digitales de Acceso Abierto de la Universidad de Tecnológica de Panamá.
Este repositorio utiliza la Licencia CC BY-NC-SA y funciona bajo DSpace.

Contact Us | Send Feedback
Universidad Tecnológica de Panamá