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

TitleNo need to type slowly changing dimensions
Author(s)Santos, Vasco
Belo, Orlando
KeywordsDecision support systems
Data warehousing systems
Data warehouses
ETL processes
Slowly changing dimensions
Issue date2011
PublisherInternational Association for Development of the Information Society (IADIS)
Abstract(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.
TypeConference paper
URIhttp://hdl.handle.net/1822/16286
ISBN9789728939472
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-IADIS-IS-Santos&Belo-CRP-1p.pdf
  Restricted access
1ª Página do Artigo84,15 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