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

TitleUsing relational algebra on the specification of slowly changing dimensions: a first step
Author(s)Santos, Vasco
Belo, Orlando
KeywordsData Warehouses
ETL processes
Slowly Changing dimensions
Relational algebra
component
Issue date2011
PublisherAssociação Ibérica de Sistemas e Tecnologias de Informação (AISTI)
Abstract(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.
TypeConference paper
URIhttp://hdl.handle.net/1822/17236
ISBN9789899624757
Peer-Reviewedyes
AccessRestricted access (UMinho)
Appears in Collections:CAlg - Artigos em livros de atas/Papers in proceedings

Files in This Item:
File Description SizeFormat 
2011-CI-CISTI-Santos&Belo-CRP-1p.pdf
  Restricted access
1ª Página do Artigo98,4 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