Utilize este identificador para referenciar este registo:
https://hdl.handle.net/1822/16286
Título: | No need to type slowly changing dimensions |
Autor(es): | Santos, Vasco Belo, Orlando |
Palavras-chave: | Decision support systems Data warehousing systems Data warehouses ETL processes Slowly changing dimensions |
Data: | 2011 |
Editora: | International Association for Development of the Information Society (IADIS) |
Resumo(s): | Data warehouses are designed to store data in a consistent and integrated way, being refreshed periodically with new data accordingly with some decision making business requirements. The refreshment process, also known as ETL, is one of the most important pieces of a data warehousing system, due to its own heterogeneous nature, complexity and resource demanding. Usually, during an ETL process new data is gathered, transformed and integrated into the data warehouse in specific multi-dimensional structures designed and implemented accordingly the main lines of analysis of decision agents. However, not only new facts are added to the data warehouse. There could be also changes at dimensions‟ data level. Dealing correctly with these changes is a critical success factor to the future of a Data Warehousing System. In this paper, we present and discuss the common methodologies used to deal with slowly changing dimensions, and reveal that there is no need to type such kind of changes, since they can all be treated in the a same manner. Using a different approach to deal with slowly changing dimensions might help to reduce the complexity of the ETL design, improve the ETL process performance, and minimize future data analysis computation. |
Tipo: | Artigo em ata de conferência |
URI: | https://hdl.handle.net/1822/16286 |
ISBN: | 9789728939472 |
Arbitragem científica: | yes |
Acesso: | Acesso restrito UMinho |
Aparece nas coleções: |
Ficheiros deste registo:
Ficheiro | Descrição | Tamanho | Formato | |
---|---|---|---|---|
2011-CI-IADIS-IS-Santos&Belo-CRP-1p.pdf Acesso restrito! | 1ª Página do Artigo | 84,15 kB | Adobe PDF | Ver/Abrir |