Show simple item record

dc.contributor.authorAwiti, Judith
dc.contributor.authorVaisman, Alejandro Ariel
dc.contributor.authorZimányi, Esteban
dc.date.accessioned2020-04-01T13:29:07Z
dc.date.available2020-04-01T13:29:07Z
dc.date.issued2019
dc.identifier.issn0302-9743
dc.identifier.urihttp://ri.itba.edu.ar/handle/123456789/1922
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.language.isoenen
dc.relationinfo:eu-repo/semantics/altIdentifier/doi//0.1007/978-3-030-27520-4_21
dc.relationinfo:eu-repo/grantAgreement/ANPCyT/PICT/2017-1054/AR. Ciudad Autónoma de Buenos Aires
dc.subjectOLAPen
dc.subjectBPMNen
dc.subjectALMACEN DE DATOSes
dc.subjectALGEBRA RELACIONALes
dc.subjectETLen
dc.titleFrom conceptual to logical ETL design using BPMN and relational algebraen
dc.typePonencias en Congresoses
dc.typeinfo:eu-repo/semantics/aceptedVersion
itba.description.filiationFil: Awiti, Judith. Université Libre de Bruxelles; Bélgica.
itba.description.filiationFil: Vaisman, Alejandro Ariel. Instituto Tecnológico de Buenos Aires; Argentina.
itba.description.filiationFil: Zimányi, Esteban. Université Libre de Bruxelles; Bélgica.


Files in this item

Thumbnail

This item appears in the following Collection(s)

Show simple item record