From conceptual to logical ETL design using BPMN and relational algebra

"Extraction, transformation, and loading (ETL) processes are used to extract data from internal and external sources of an organization, transform these data, and load them into a data warehouse. The Business Process Modeling Notation (BPMN) has been proposed for expressing ETL processes at a...

Descripción completa

Guardado en:
Detalles Bibliográficos
Autores principales: Awiti, Judith, Vaisman, Alejandro Ariel, Zimányi, Esteban
Formato: Ponencias en Congresos acceptedVersion
Lenguaje:Inglés
Publicado: 2020
Materias:
OLAP
BPMN
ETL
ALMACENES DE DATOS
ALGEBRA RELACIONAL
Acceso en línea:http://ri.itba.edu.ar/handle/123456789/1922
Aporte de:
Repositorio Institucional Instituto Tecnológico de Buenos Aires (ITBA) de Instituto Tecnológico de Buenos Aires (ITBA)
id I32-R138-123456789-1922
record_format dspace
spelling I32-R138-123456789-19222022-12-07T14:13:45Z From conceptual to logical ETL design using BPMN and relational algebra Awiti, Judith Vaisman, Alejandro Ariel Zimányi, Esteban OLAP BPMN ETL ALMACENES DE DATOS ALGEBRA RELACIONAL "Extraction, transformation, and loading (ETL) processes are used to extract data from internal and external sources of an organization, transform these data, and load them into a data warehouse. The Business Process Modeling Notation (BPMN) has been proposed for expressing ETL processes at a conceptual level. This paper extends relational algebra (RA) with update operations for specifying ETL processes at a logical level. In this approach, data tasks can be automatically translated into SQL queries to be executed over a DBMS. An extension of RA is presented, as well as a translation mechanism from BPMN to the RA specification. Throughout the paper, the TPC-DI benchmark is used for comparing both approaches. Experiments show the efficiency of the resulting ETL flow with respect to the Pentaho Data Integration tool." 2020-04-01T13:29:07Z 2020-04-01T13:29:07Z 2019 Ponencias en Congresos info:eu-repo/semantics/acceptedVersion 0302-9743 http://ri.itba.edu.ar/handle/123456789/1922 en info:eu-repo/semantics/altIdentifier/doi//0.1007/978-3-030-27520-4_21 info:eu-repo/grantAgreement/ANPCyT/PICT/2017-1054/AR. Ciudad Autónoma de Buenos Aires application/pdf
institution Instituto Tecnológico de Buenos Aires (ITBA)
institution_str I-32
repository_str R-138
collection Repositorio Institucional Instituto Tecnológico de Buenos Aires (ITBA)
language Inglés
topic OLAP
BPMN
ETL
ALMACENES DE DATOS
ALGEBRA RELACIONAL
spellingShingle OLAP
BPMN
ETL
ALMACENES DE DATOS
ALGEBRA RELACIONAL
Awiti, Judith
Vaisman, Alejandro Ariel
Zimányi, Esteban
From conceptual to logical ETL design using BPMN and relational algebra
topic_facet OLAP
BPMN
ETL
ALMACENES DE DATOS
ALGEBRA RELACIONAL
description "Extraction, transformation, and loading (ETL) processes are used to extract data from internal and external sources of an organization, transform these data, and load them into a data warehouse. The Business Process Modeling Notation (BPMN) has been proposed for expressing ETL processes at a conceptual level. This paper extends relational algebra (RA) with update operations for specifying ETL processes at a logical level. In this approach, data tasks can be automatically translated into SQL queries to be executed over a DBMS. An extension of RA is presented, as well as a translation mechanism from BPMN to the RA specification. Throughout the paper, the TPC-DI benchmark is used for comparing both approaches. Experiments show the efficiency of the resulting ETL flow with respect to the Pentaho Data Integration tool."
format Ponencias en Congresos
acceptedVersion
author Awiti, Judith
Vaisman, Alejandro Ariel
Zimányi, Esteban
author_facet Awiti, Judith
Vaisman, Alejandro Ariel
Zimányi, Esteban
author_sort Awiti, Judith
title From conceptual to logical ETL design using BPMN and relational algebra
title_short From conceptual to logical ETL design using BPMN and relational algebra
title_full From conceptual to logical ETL design using BPMN and relational algebra
title_fullStr From conceptual to logical ETL design using BPMN and relational algebra
title_full_unstemmed From conceptual to logical ETL design using BPMN and relational algebra
title_sort from conceptual to logical etl design using bpmn and relational algebra
publishDate 2020
url http://ri.itba.edu.ar/handle/123456789/1922
work_keys_str_mv AT awitijudith fromconceptualtologicaletldesignusingbpmnandrelationalalgebra
AT vaismanalejandroariel fromconceptualtologicaletldesignusingbpmnandrelationalalgebra
AT zimanyiesteban fromconceptualtologicaletldesignusingbpmnandrelationalalgebra
_version_ 1765661039072903168

Ejemplares similares