Optimization slowly changing dimensions of a data warehouse using object-relational

A Data Warehouse is designed with a multidimensional structure using fact tables and dimension tables, oriented towards indicator systems that support decision-making. The most common loads associated with these systems are applied to the fact table, assuming that all dimensions are common or time-i...

Full description

Saved in:

Bibliographic Details
Published in:	2015 34th International Conference of the Chilean Computer Science Society (SCCC) pp. 1 - 6
Main Authors:	Cofre Loyola, Rodrigo, Urrutia Sepulveda, Angelica, Wilson Hernandez, Manuel
Format:	Conference Proceeding
Language:	English
Published:	IEEE 01-11-2015
Subjects:	Cities and towns Data Warehouse (DW) Data warehouses History Object-Relational Database (ORDB) Proposals Relational Database (RDB) Relational databases Slowly Changing Dimensions (SCD) Time factors
Online Access:	Get full text
Tags:	Add Tag No Tags, Be the first to tag this record!

Description
Summary:	A Data Warehouse is designed with a multidimensional structure using fact tables and dimension tables, oriented towards indicator systems that support decision-making. The most common loads associated with these systems are applied to the fact table, assuming that all dimensions are common or time-independent, which can lead to abnormalities in data representation at the Front End level. Proposals have been made for updating the dimension tables which call this process Slowly Changing Dimensions (SCD), focusing on relational database design. In this research, an improved response time is shown for queries associated with a Data Warehouse design for Changing Dimensions tables, comparing response times for SCD data in Relational Database and Object-Relational. The research focuses on proposing a general design for Object-Relational of SCD data types 1-4, illustrated with an example that allows to compare the performance.
DOI:	10.1109/SCCC.2015.7416593