Paper Info
Title
Query processing over data warehouse using relational databases and NoSQL
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.
Year
DOI
Venue
2012
10.1109/CLEI.2012.6427228
Informatica
Keywords
Field
DocType
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,NoSQL,bitmap join indices,data warehouse,query processing,relational databases
SQL,Data warehouse,Database model,Relational database,Information retrieval,Computer science,Sargable,In-Memory Processing,View,NoSQL,Database
Conference
ISBN
Citations 
PageRank 
978-1-4673-0794-9
1
0.37
References 
Authors
9
8
Name
Order
Citations
PageRank
Anderson Chaves Carniel1159.52
Aried de Aguiar Sa210.37
Vinicius Henrique Porto Brisighello310.37
M. X. Ribeiro46812.72
Renato Bueno5276.33
Ricardo Rodrigues Ciferri613722.24
Cristina Dutra De Aguiar Ciferri716627.92
de Aguiar Sa, A.810.37