Uma avaliação experimental de execução de consultas OLAP no POSTGRESQL e MONGODB

Abstract

Over the last few decades, data management has become one of the most important activities in organizations, due to the growth in data generation around the world. Currently, the biggest challenge is to organize information and manipulate in order to assist in decision making. In this scenario, the Data Warehouse (DW) is an important component to support decisions. DW is a non-volatile database, subject-oriented, historical and massive, whose processing of analytic queries results in downtime high answer Techniques are used to improve the performance of processes query processing, among them are the use of data fragmentation, materialized views and indices. Furthermore, NoSQL is an emerging technology whose main features are the improvement of query processing and data storage, becoming an alternative to relational databases. In this work we investigate and compare the implementation of Dw using relational databases and NoSQL, considering the Star Benchmark Schema. Experiments were carried out and the results obtained suggest that, for the scenario explored, relational databases have a superior result in processing of queries to document-oriented NoSQL.