Utilize este identificador para referenciar este registo:
https://hdl.handle.net/1822/17236
Título: | Using relational algebra on the specification of slowly changing dimensions: a first step |
Autor(es): | Santos, Vasco Belo, Orlando |
Palavras-chave: | Data Warehouses ETL processes Slowly Changing dimensions Relational algebra component |
Data: | 2011 |
Editora: | Associação Ibérica de Sistemas e Tecnologias de Informação (AISTI) |
Resumo(s): | Data Warehouses are refreshed periodically with data from source systems. Nevertheless this data is not only related to new facts, but also to dimension data. Some dimensions have the particularity of evolving through time, either by having new data or by changes that occur in source systems and must be reflected in the data warehouses. Dealing with these, so called, Slowly Changing Dimensions is a complex task that the Extract, Transform and Load process is responsible. Common approaches are based on typing these dimensions and act accordingly, which adds to the already complex nature of the process. In this paper we analyze these different types of slowly changing dimensions, proposing a relational algebra specification to deal with them. |
Tipo: | Artigo em ata de conferência |
URI: | https://hdl.handle.net/1822/17236 |
ISBN: | 9789899624757 |
Arbitragem científica: | yes |
Acesso: | Acesso restrito UMinho |
Aparece nas coleções: |
Ficheiros deste registo:
Ficheiro | Descrição | Tamanho | Formato | |
---|---|---|---|---|
2011-CI-CISTI-Santos&Belo-CRP-1p.pdf Acesso restrito! | 1ª Página do Artigo | 98,4 kB | Adobe PDF | Ver/Abrir |