ponencia en congreso.page.titleprefix 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. |
Files
Original bundle
1 - 1 of 1
Loading...
- Name:
- Awiti_2019_ponencia_INFORMATICA.pdf
- Size:
- 1.19 MB
- Format:
- Adobe Portable Document Format
- Description:
- Ponencia_Awiti
License bundle
1 - 1 of 1
No Thumbnail Available
- Name:
- license.txt
- Size:
- 1.6 KB
- Format:
- Item-specific license agreed upon to submission
- Description: