Please use this identifier to cite or link to this item: http://hdl.handle.net/1822/38345

TitleAutomatic generation of ETL physical systems from BPMN conceptual models
Author(s)Belo, O.
Gomes, Cláudia
Oliveira, Bruno
Marques, Ricardo
Santos, Vasco
KeywordsData Warehousing Systems
ETL Conceptual Modeling
BPMN
Domain-Specific Languages
ETL Skeletons
Kettle
BPMN specification models
Issue date26-Sep-2015
PublisherSpringer Verlag
JournalLecture Notes in Computer Science (including Subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)
Abstract(s)ETL conceptual modeling is a very important activity in any data warehousing system project implementation. Owning a high-level system representation allowing for a clear identification of the main parts of a data warehousing system is clearly a great advantage, especially in early stages of design and development. However, the effort to model conceptually an ETL system rarely is properly rewarded. Translating ETL conceptual models directly into something that saves work and time on the concrete implementation of the system process it would be, in fact, a great help. In this paper we present and discuss a hybrid approach to this problem, combining the simplicity of interpretation and power of expression of BPMN on ETL systems conceptualization with the use of ETL patterns to produce automatically an ETL skeleton, a first prototype system, which has the ability to be executed in a commercial ETL tool like Kettle.
TypeConference paper
URIhttp://hdl.handle.net/1822/38345
ISBN9783319237800
DOI10.1007/978-3-319-23781-7_19
ISSN0302-9743
Peer-Reviewedyes
AccessRestricted access (UMinho)
Appears in Collections:CAlg - Artigos em livros de atas/Papers in proceedings

Files in This Item:
File Description SizeFormat 
2015-CI-MEDI-BeloEtAl-9P-CRP.pdf
  Restricted access
Artigo completo publicado.620,27 kBAdobe PDFView/Open

Partilhe no FacebookPartilhe no TwitterPartilhe no DeliciousPartilhe no LinkedInPartilhe no DiggAdicionar ao Google BookmarksPartilhe no MySpacePartilhe no Orkut
Exporte no formato BibTex mendeley Exporte no formato Endnote Adicione ao seu ORCID