Análise, projeto e implementação de um esquema MOLAP de data warehouse utilizando o SGBD-OR Oracle 8i.

Abstract

With the emerging relational objects techonologies in relational database management systems (RDBMS), many researchers have directed their research efforts to evaluate the usability of such technology in OLAP queries. This work presents the analysis, design and implementation of a prototype that uses a storage and retrival technology based on n-dimensional matrices (MOLAP) in OLAP queries, making use of Oracle's Oracle 8i resources and functionalities. Some functions were implemented in order to provide a consolidation operation mechanism, as well as a solution for presenting/storing data from a n-dimension matrix into Oracle 8i tables.A comparative analysis between the OLAP response time performance made by the prototype and a Oracle provided ROLAP scheme was performed, showing the advantages of the proposed prototype.