Utilize este identificador para referenciar este registo:
https://hdl.handle.net/1822/38346
Título: | Using relational algebra on the specification of real world ETL processes |
Autor(es): | Santos, Vasco Belo, O. |
Palavras-chave: | Data Warehousing Systems ETL Processes ETL Conceptual and Logical Modeling Relational Algebra component |
Data: | 26-Out-2015 |
Editora: | IEEE |
Resumo(s): | Modeling Extract-Transform-Load (ETL) processes of a Data Warehousing System has always been a challenge. The heterogeneity of the sources, the quality of the data obtained and the conciliation process are some of the issues that must be addressed in the design phase of this critical component. Commercial ETL tools often provide proprietary diagrammatic components and modeling languages that are not standard, thus not providing the ideal separation between a modeling platform and an execution platform. This separation in conjunction with the use of standard notations and languages is critical in a system that tends to evolve through time and which cannot be undermined by a normally expensive tool that becomes an unsatisfactory component. In this paper we demonstrate the application of Relational Algebra as a modeling language of an ETL system as an effort to standardize operations and provide a basis for uncommon ETL execution platforms. |
Tipo: | Artigo em ata de conferência |
URI: | https://hdl.handle.net/1822/38346 |
ISBN: | 9781509001545 |
DOI: | 10.1109/CIT/IUCC/DASC/PICOM.2015.128 |
Arbitragem científica: | yes |
Acesso: | Acesso restrito UMinho |
Aparece nas coleções: |
Ficheiros deste registo:
Ficheiro | Descrição | Tamanho | Formato | |
---|---|---|---|---|
2015-CI-CIT-Santos&Belo-CRP.pdf Acesso restrito! | Artigo completo publicado. | 643,24 kB | Adobe PDF | Ver/Abrir |