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

Laurent Bonnet; Anne Laurent; Bénédicte Laurent; Michel Sala; Nicolas Sicard

doi:10.1109/DEXA.2011.71

Retour

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

Acte de colloque

Open Access

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

Laurent Bonnet, Anne Laurent, Bénédicte Laurent, Michel Sala et Nicolas Sicard

DEXA 2011 - 22nd International Conference on Database and Expert Systems Applications, pp.483-488

DEXA 2011 - 22nd International Conference on Database and Expert Systems Applications (Toulouse, France, 29/08/2011–02/09/2011)

2011

DOI: https://doi.org/10.1109/DEXA.2011.71

Résumé

Massive Data Sets

Data Aggregation

SQL

NoSQL

MapReduce

Read Intensive

Write Intensive

MongoDB

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.

Fichiers et liens (1)

url

Find in HALAfficher

Indicateurs

1 Consultations de la notice

See more details

Détails

Titre: Reduce, You Say: What NoSQL Can Do for Data Aggregation and BI in Large Repositories
Créateurs - sans rôle: Laurent Bonnet - Laboratoire d'Informatique, de Robotique et de Microélectronique de Montpellier
Anne Laurent - Laboratoire d'Informatique, de Robotique et de Microélectronique de Montpellier
Bénédicte Laurent - Namae Concept
Michel Sala - Laboratoire d'Informatique, de Robotique et de Microélectronique de Montpellier
Nicolas Sicard - Engineering School of Information and Digital Technologies
Détails de publication: DEXA 2011 - 22nd International Conference on Database and Expert Systems Applications, pp.483-488
Colloque: DEXA 2011 - 22nd International Conference on Database and Expert Systems Applications (Toulouse, France, 29/08/2011–02/09/2011)
Identifiants: 9938644409311
Unité académique: Laboratoire d'Informatique de Robotique et de Microélectronique de Montpellier - LIRMM
Langue: English
Type de ressource: Conference proceeding
Champs locaux: lirmm-00803917