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

• 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
• DOI: 10.1109/SCCC.2015.7416593

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.