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

TitleUsing reo on ETL conceptual modelling: a first approach
Author(s)Oliveira, Bruno
Belo, O.
KeywordsData Warehousing Systems
ETL Conceptual Modelling
ETL Patterns
Reo
Reo specification models
Issue date28-Oct-2013
Abstract(s)The formalization of software patterns has proven to be very useful in software developing, improving systems communication, data interchange across platforms, and simplifying the integration of processes and data flows. Populating a data warehouse (ETL) is often a very complex task demanding significant computational resources, involving not only large volumes of data that must be processed but also undesirable change of business requirements. All of this leads frequently to reuse significant parts of other ETL implementations, adapting data structures and processes to comply with new requirements. Additionally, we believe that it’s necessary a more simply and reliable approach for ETL conceptual modelling covering the “lack of mature” of this important part of ETL development. In this paper we explored a new approach to ETL conceptual modelling using the Reo coordination language, trying to evaluate its adequacy and expressiveness on the coordination of ETL tasks. A pattern-based approach was designed to map typical operations used in real world ETL scenarios from an initial Reo specification. For demonstration purposes, we present and discuss as two case studies, a slowly changing dimension and a surrogated key pipelining processes.
TypeConference paper
URIhttp://hdl.handle.net/1822/37409
ISBN9781450324199
DOI10.1145/2513190.2513202
Peer-Reviewedyes
AccessRestricted access (UMinho)
Appears in Collections:CAlg - Artigos em livros de atas/Papers in proceedings

Files in This Item:
File Description SizeFormat 
2013-CI-DOLAP-Oliveira&Belo-CRP.pdf
  Restricted access
Artigo completo publicado402,16 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