skip to main content
Idioma:
Tipo de recurso Mostra resultados com: Mostra resultados com: Índice

Query processing over data warehouse using relational databases and NoSQL

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

2012 XXXVIII Conferencia Latinoamericana En Informatica (CLEI), 2012, p.1-9

IEEE

Texto completo disponível

Citações Citado por
  • Título:
    Query processing over data warehouse using relational databases and NoSQL
  • Autor: Carniel, A. C. ; de Aguiar Sa, A. ; Brisighello, V. H. P. ; Ribeiro, M. X. ; Bueno, R. ; Ciferri, R. R. ; de Aguiar Ciferri, C. D.
  • Assuntos: Amplitude modulation ; Asia ; bitmap join indices ; Computational modeling ; data warehouse ; Data warehouses ; NoSQL ; Query processing ; Relational databases ; Software
  • É parte de: 2012 XXXVIII Conferencia Latinoamericana En Informatica (CLEI), 2012, p.1-9
  • Descrição: 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.
  • Editor: IEEE
  • Idioma: Inglês
Voltar para lista de resultados

  • Realização: ABCD-USP USP   Logos de Redes Sociais: Freepik

Buscando em bases de dados remotas. Favor aguardar.