|
Title:
|
NO NEED TO TYPE SLOWLY CHANGING DIMENSIONS |
|
Author(s):
|
Vasco Santos, Orlando Belo |
|
ISBN:
|
978-972-8939-47-2 |
|
Editors:
|
Miguel Baptista Nunes, Pedro Isaías and Philip Powell |
|
Year:
|
2011 |
|
Edition:
|
Single |
|
Keywords:
|
Decision Support Systems, Data Warehousing Systems, Data Warehouses, ETL Processes, Slowly Changing Dimensions. |
|
Type:
|
Full Paper |
|
First Page:
|
129 |
|
Last Page:
|
136 |
|
Language:
|
English |
|
Cover:
|
|
|
Full Contents:
|
click to dowload 
|
|
Paper Abstract:
|
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. |
|
|
|
|
|
|
