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

TitleA pattern-oriented approach for supporting ETL conceptual modelling and its YAWL-based implementation
Author(s)Oliveira, Bruno
Belo, O.
Cuzzocrea, Alfredo
KeywordsData Warehouse
ETL Modeling
ETL Patterns
Meta - model and YAWL
Verification
Quality
Validation
Patterns
ETL
Issue date29-Aug-2014
PublisherSCITEPRESS
Abstract(s)Modelling and implementing Data Warehouse populating processes (mainly known as ETL) involves in complex and challenge tasks that have been highlighted by numerous researchers in the field. Several workflow modelling languages, mainly used for supporting Business Processes modelling, such as BPMN, BPEL or UML AD, have been adapted and (sometimes) used to model ETL processes with the goal of successfully conceptual-modelling them and enabling their posteriorly executions. However, there is a large bridge still to be built between abstract models, which are typically used in initial phases of projects, and their subsequent implementation in real-world practical scenarios. Furthermore, ETL processes are strongly related to business requirements, which are often affected by business evolution and business operational systems. Hence, with the goal of minimizing such gaps, in this paper we propose the use of a pattern- oriented approach for supporting ETL conceptual modelling, where common tasks are identified and formalized in order to describe their potential behaviour, thus allowing for its application and reuse in different application scenarios.
TypeConference paper
URIhttp://hdl.handle.net/1822/37430
ISBN9789897580352
Peer-Reviewedyes
AccessRestricted access (UMinho)
Appears in Collections:CAlg - Artigos em livros de atas/Papers in proceedings

Files in This Item:
File Description SizeFormat 
2014-CI-Data-OliveiraEtAL-CRP.pdf
  Restricted access
Artigo completo publicado265,51 kBAdobe PDFView/Open    Request a copy!

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