Query processing over data warehouse using relational databases and NoSQL

Author

Carniel, A.C. ; de Aguiar Sa, A. ; Brisighello, V.H.P. ; Ribeiro, Marcela X. ; Bueno, Renato ; Ciferri, R.R. ; de Aguiar Ciferri, C.D.

Author_Institution

Dept. de Comput., Univ. Fed. de Sao Carlos, Sao Carlos, Brazil

fYear

2012

fDate

1-5 Oct. 2012

Firstpage

1

Lastpage

9

Abstract

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.

Keywords

SQL; competitive intelligence; data handling; data warehouses; decision making; query processing; relational databases; DW; NoSQL; analytical queries; business intelligence; data fragmentation; data storage; data warehouse; query processing; relational databases; star schema benchmark; strategic decision making support; Amplitude modulation; Asia; Computational modeling; Data warehouses; Query processing; Relational databases; Software; NoSQL; bitmap join indices; data warehouse; query processing; relational databases;

fLanguage

English

Publisher

ieee

Conference_Titel

Informatica (CLEI), 2012 XXXVIII Conferencia Latinoamericana En

Conference_Location

Medellin

Print_ISBN

978-1-4673-0794-9

Type

conf

DOI

10.1109/CLEI.2012.6427228

Filename

6427228