From conceptual to logical ETL design using BPMN and relational algebra

Awiti, Judith; Vaisman, Alejandro Ariel; Zimányi, Esteban

Ponencia en Congreso:
From conceptual to logical ETL design using BPMN and relational algebra

dc.contributor.author	Awiti, Judith
dc.contributor.author	Vaisman, Alejandro Ariel
dc.contributor.author	Zimányi, Esteban
dc.date.accessioned	2020-04-01T13:29:07Z
dc.date.available	2020-04-01T13:29:07Z
dc.date.issued	2019
dc.description.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."	en
dc.identifier.issn	0302-9743
dc.identifier.uri	http://ri.itba.edu.ar/handle/123456789/1922
dc.language.iso	en	en
dc.relation	info:eu-repo/semantics/altIdentifier/doi//0.1007/978-3-030-27520-4_21
dc.relation	info:eu-repo/grantAgreement/ANPCyT/PICT/2017-1054/AR. Ciudad Autónoma de Buenos Aires
dc.subject	OLAP	en
dc.subject	BPMN	en
dc.subject	ALMACENES DE DATOS	es
dc.subject	ALGEBRA RELACIONAL	es
dc.subject	ETL	en
dc.title	From conceptual to logical ETL design using BPMN and relational algebra	en
dc.type	Ponencias en Congresos	es
dc.type	info:eu-repo/semantics/acceptedVersion
dspace.entity.type	Ponencia en Congreso
itba.description.filiation	Fil: Awiti, Judith. Université Libre de Bruxelles; Bélgica.
itba.description.filiation	Fil: Vaisman, Alejandro Ariel. Instituto Tecnológico de Buenos Aires; Argentina.
itba.description.filiation	Fil: Zimányi, Esteban. Université Libre de Bruxelles; Bélgica.