Skip to Main content Skip to Navigation
Conference papers

Reduce, You Say: What NoSQL Can Do for Data Aggregation and BI in Large Repositories

Abstract : Data aggregation is one of the key features used in databases, especially for Business Intelligence (e.g., ETL, OLAP) and analytics/data mining. When considering SQL databases, aggregation is used to prepare and visualize data for deeper analyses. However, these operations are often impossible on very large volumes of data regarding memory-and-timeconsumption. In this paper, we show how NoSQL databases such as MongoDB and its key-value stores, thanks to the native MapReduce algorithm, can provide an efficient framework to aggregate large volumes of data. We provide basic material about the MapReduce algorithm, the different NoSQL databases (read intensive vs. write intensive). We investigate how to efficiently modelize the data framework for BI and analytics. For this purpose, we focus on read intensive NoSQL databases using MongoDB and we show how NoSQL and MapReduce can help handling large volumes of data.
Document type :
Conference papers
Complete list of metadata

Cited literature [12 references]  Display  Hide  Download

https://hal-lirmm.ccsd.cnrs.fr/lirmm-00803917
Contributor : Anne Laurent <>
Submitted on : Friday, November 1, 2019 - 6:30:52 PM
Last modification on : Friday, November 15, 2019 - 1:21:22 AM
Long-term archiving on: : Sunday, February 2, 2020 - 1:25:30 PM

File

lirmm-00803917v1.pdf
Files produced by the author(s)

Identifiers

Collections

Citation

Laurent Bonnet, Anne Laurent, Bénédicte Laurent, Michel Sala, Nicolas Sicard. Reduce, You Say: What NoSQL Can Do for Data Aggregation and BI in Large Repositories. 22nd International Workshop on Database and Expert Systems Applications (DEXA), Aug 2011, Toulouse, France. pp.483-488, ⟨10.1109/DEXA.2011.71⟩. ⟨lirmm-00803917⟩

Share

Metrics

Record views

760

Files downloads

689