Utilize este identificador para referenciar este registo:
https://hdl.handle.net/1822/37409
Título: | Using reo on ETL conceptual modelling: a first approach |
Autor(es): | Oliveira, Bruno Belo, O. |
Palavras-chave: | Data Warehousing Systems ETL Conceptual Modelling ETL Patterns Reo Reo specification models |
Data: | 28-Out-2013 |
Resumo(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. |
Tipo: | Artigo em ata de conferência |
URI: | https://hdl.handle.net/1822/37409 |
ISBN: | 9781450324199 |
DOI: | 10.1145/2513190.2513202 |
Arbitragem científica: | yes |
Acesso: | Acesso restrito UMinho |
Aparece nas coleções: |
Ficheiros deste registo:
Ficheiro | Descrição | Tamanho | Formato | |
---|---|---|---|---|
2013-CI-DOLAP-Oliveira&Belo-CRP.pdf Acesso restrito! | Artigo completo publicado | 402,16 kB | Adobe PDF | Ver/Abrir |