Thumbnail Image
Publication

From conceptual to logical ETL design using BPMN and relational algebra

Awiti, Judith
; 
Vaisman, Alejandro Ariel
; 
Zimányi, Esteban
Type
Ponencia en congreso
Citations
Altmetric:
Abstract
"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."
Description
Date
2019
Journal Title
Journal ISSN
Volume Title
Publisher
Collections
Presentaciones a Congresos
Show all metadata
Files
Thumbnail Image
Ponencia_Awiti
Adobe PDF, 1.19 MB
Research Projects
Organizational Units
Journal Issue
Keywords
OLAP, BPMN, ALMACENES DE DATOS, ALGEBRA RELACIONAL, ETL
Citation
URI
http://ri.itba.edu.ar/handle/20.500.14769/1922
Embedded videos