Query processing over data warehouse using relational databases and NoSQL

Data warehouse (DW) is an important component of Business Intelligence used to support strategic decision making. DW is a subject-oriented, nonvolatile, historical and massive database, which the processing of analytical queries, results in high response times. There known techniques for improving the performance processing of queries on DW. Among them is the use of data fragmentation, materialized views and indices. In addition, the NoSQL is an emerging technology whose main characteristics are improved query processing and data storage, and an alternative to relational databases. In this paper we investigate and compare the implementation of DW using relational databases and NoSQL, considering the Star Schema Benchmark. The results showed that the column-oriented model of the software FastBit showed a better performance, with gains of 25.4% to 99.4% if compared to other models NoSQL and the relational model, in the processing of queries on DW.