Paper Info
Title
A Case Study of the Aggregation Query Model in Read-Mostly NoSQL Document Stores.
Abstract
In this paper we focus on the aggregate query model implemented over NoSQL document-stores for read-mostly data bases. We discuss that the aggregate query model can be a good fit for read-mostly databases if the following design requirements are met: on-line time range queries, aggregates with predefined filters, frequent schema evolution and no ad-hoc. In our model, we present a composite object schema implementation over NoSQL document-stores, in which data associations are nested in a document under the same search key. We present the design choices to obtain a model adapted to our needs. Our schema is inspired by the star schema of Data Warehouses to reduce accessing data associations in many different documents and computing aggregates within the same composite. We present performance results of our empirical study over a 300 million records database that serves in production for the Ministry of Communications of Brazil. Results show the performance gains and penalties of our star composite schema when compared to the traditional multidimensional schema.
Year
DOI
Venue
2016
10.1145/2938503.2938546
IDEAS
Field
DocType
Citations 
Data warehouse,Data mining,Conceptual schema,Star schema,Computer science,Semi-structured model,View,Database schema,NoSQL,Schema evolution,Database
Conference
0
PageRank 
References 
Authors
0.34
8
6
Name
Order
Citations
PageRank
Diego Pasqualin101.35
Giovanni Souza200.34
Eduardo Luis Buratti300.34
Eduardo Cunha De Almeida46417.33
Marcos Didonet Del Fabro527334.14
Daniel Weingaertner694.34