Imagen de Portada

Automatic generation of ETL processes from conceptual models

Data warehouses (DW) integrate different data sources in order to give a multidimensional view of them to the decision-maker. To this aim, the ETL (Extraction, Transformation and Load) processes are responsible for extracting data from heterogeneous operational data sources, their transformation (co...

Descripción completa

Autores Principales: Muñoz, Lilia, Trujillo, Juan, Mazón, Jose Norberto
Formato: Artículo
Idioma: Inglés
Publicado: 2018
Materias:
Automatic
ETL processes
conceptual models
Acceso en línea: https://dl.acm.org/citation.cfm?id=1651298
http://ridda2.utp.ac.pa/handle/123456789/4915
http://ridda2.utp.ac.pa/handle/123456789/4915
id RepoUTP4915
recordtype dspace
spelling RepoUTP49152021-07-06T15:35:08Z Automatic generation of ETL processes from conceptual models Muñoz, Lilia Trujillo, Juan Mazón, Jose Norberto Automatic ETL processes conceptual models Automatic ETL processes conceptual models Data warehouses (DW) integrate different data sources in order to give a multidimensional view of them to the decision-maker. To this aim, the ETL (Extraction, Transformation and Load) processes are responsible for extracting data from heterogeneous operational data sources, their transformation (conversion, cleaning, standardization, etc.), and its load in the DW. In recent years, several conceptual modeling approaches have been proposed for designing ETL processes. Although these approaches are very useful for documenting ETL processes and supporting the designer tasks, these proposals fail to give mechanisms to carry out an automatic code generation stage. Such a stage should be required to both avoid fails and save development time in the implementation of complex ETL process. Therefore, in this paper we define an approach for the automatic code generation of ETL processes. To this aim, we align the modeling of ETL processes in DW with MDA (Model Driven Architecture) by formally defining a set of QVT (Query, View, Transformation) transformations. Data warehouses (DW) integrate different data sources in order to give a multidimensional view of them to the decision-maker. To this aim, the ETL (Extraction, Transformation and Load) processes are responsible for extracting data from heterogeneous operational data sources, their transformation (conversion, cleaning, standardization, etc.), and its load in the DW. In recent years, several conceptual modeling approaches have been proposed for designing ETL processes. Although these approaches are very useful for documenting ETL processes and supporting the designer tasks, these proposals fail to give mechanisms to carry out an automatic code generation stage. Such a stage should be required to both avoid fails and save development time in the implementation of complex ETL process. Therefore, in this paper we define an approach for the automatic code generation of ETL processes. To this aim, we align the modeling of ETL processes in DW with MDA (Model Driven Architecture) by formally defining a set of QVT (Query, View, Transformation) transformations. 2018-06-13T20:09:20Z 2018-06-13T20:09:20Z 2018-06-13T20:09:20Z 2018-06-13T20:09:20Z 11/06/2009 11/06/2009 info:eu-repo/semantics/article info:eu-repo/semantics/publishedVersion https://dl.acm.org/citation.cfm?id=1651298 http://ridda2.utp.ac.pa/handle/123456789/4915 http://ridda2.utp.ac.pa/handle/123456789/4915 eng info:eu-repo/semantics/embargoedAccess application/pdf text/html
institution Universidad Tecnológica de Panamá
collection Repositorio UTP – Ridda2
language Inglés
topic Automatic
ETL processes
conceptual models
Automatic
ETL processes
conceptual models
spellingShingle Automatic
ETL processes
conceptual models
Automatic
ETL processes
conceptual models
Muñoz, Lilia
Trujillo, Juan
Mazón, Jose Norberto
Automatic generation of ETL processes from conceptual models
description Data warehouses (DW) integrate different data sources in order to give a multidimensional view of them to the decision-maker. To this aim, the ETL (Extraction, Transformation and Load) processes are responsible for extracting data from heterogeneous operational data sources, their transformation (conversion, cleaning, standardization, etc.), and its load in the DW. In recent years, several conceptual modeling approaches have been proposed for designing ETL processes. Although these approaches are very useful for documenting ETL processes and supporting the designer tasks, these proposals fail to give mechanisms to carry out an automatic code generation stage. Such a stage should be required to both avoid fails and save development time in the implementation of complex ETL process. Therefore, in this paper we define an approach for the automatic code generation of ETL processes. To this aim, we align the modeling of ETL processes in DW with MDA (Model Driven Architecture) by formally defining a set of QVT (Query, View, Transformation) transformations.
format Artículo
author Muñoz, Lilia
Trujillo, Juan
Mazón, Jose Norberto
author_sort Muñoz, Lilia
title Automatic generation of ETL processes from conceptual models
title_short Automatic generation of ETL processes from conceptual models
title_full Automatic generation of ETL processes from conceptual models
title_fullStr Automatic generation of ETL processes from conceptual models
title_full_unstemmed Automatic generation of ETL processes from conceptual models
title_sort automatic generation of etl processes from conceptual models
publishDate 2018
url https://dl.acm.org/citation.cfm?id=1651298
http://ridda2.utp.ac.pa/handle/123456789/4915
http://ridda2.utp.ac.pa/handle/123456789/4915
_version_ 1796209603499786240
score 12.231669

Ejemplares similares