Benchmarking SQL on MapReduce systems using large astronomy databases - Inria - Institut national de recherche en sciences et technologies du numérique Accéder directement au contenu
Article Dans Une Revue Distributed and Parallel Databases Année : 2016

Benchmarking SQL on MapReduce systems using large astronomy databases

Amin Mesmoudi
Mohand-Saïd Hacid

Résumé

In the era of bigdata, with a massive set of digital information of unprecedented volumes being collected and/or produced in several application domains , it becomes more and more difficult to manage and query large data repositories. In the framework of the PetaSky project (http://com.isima.fr/Petasky), we focus on the problem of managing scientific data in the field of cosmology. The data we consider are those of the LSST project (http://www.lsst.org/). The overall size of the database that will be produced is expected to exceed 60 PB [28]. In order to evaluate the performances of existing SQL On MapReduce data management systems, we conducted extensive experiments by using data and queries from the area of cosmology. The goal of this work is to report on the ability of such systems to support large scale declarative queries. We mainly investigated the impact of data partitioning, indexing and compression on query execution performances.
Fichier principal
Vignette du fichier
bench_sql_mapr.pdf (527.32 Ko) Télécharger le fichier
Origine : Fichiers produits par l'(les) auteur(s)
Loading...

Dates et versions

hal-01221665 , version 1 (28-10-2015)

Identifiants

Citer

Amin Mesmoudi, Mohand-Saïd Hacid, Farouk Toumani. Benchmarking SQL on MapReduce systems using large astronomy databases. Distributed and Parallel Databases, 2016, 34 (3), pp.347-378. ⟨10.1007/s10619-014-7172-8⟩. ⟨hal-01221665⟩
347 Consultations
566 Téléchargements

Altmetric

Partager

Gmail Facebook X LinkedIn More