An Effective Scalable SQL Engine for NoSQL Databases

Abstract : NoSQL databases were initially devised to support a few concrete extreme scale applications. Since the specificity and scale of the target systems justified the investment of manually crafting application code their limited query and indexing capabilities were not a major impediment. However, with a considerable number of mature alternatives now available there is an increasing willingness to use NoSQL databases in a wider and more diverse spectrum of applications and, to most of them, hand-crafted query code is not an enticing trade-off.In this paper we address this shortcoming of current NoSQL databases with an effective approach for executing SQL queries while preserving their scalability and schema flexibility. We show how a full-fledged SQL engine can be integrated atop of HBase leading to an ANSI SQL compliant database. Under a standard TPC-C workload our prototype scales linearly with the number of nodes in the system and outperforms a NoSQL TPC-C implementation optimized for HBase.
Type de document :
Communication dans un congrès
Jim Dowling; François Taïani. 13th International Conference on Distributed Applications and Interoperable Systems (DAIS), Jun 2013, Florence, Italy. Springer, Lecture Notes in Computer Science, LNCS-7891, pp.155-168, 2013, Distributed Applications and Interoperable Systems. 〈10.1007/978-3-642-38541-4_12〉
Liste complète des métadonnées

Littérature citée [25 références]  Voir  Masquer  Télécharger

https://hal.inria.fr/hal-01489453
Contributeur : Hal Ifip <>
Soumis le : mardi 14 mars 2017 - 14:19:19
Dernière modification le : mardi 14 mars 2017 - 16:07:25
Document(s) archivé(s) le : jeudi 15 juin 2017 - 14:10:17

Fichier

978-3-642-38541-4_12_Chapter.p...
Fichiers produits par l'(les) auteur(s)

Licence


Distributed under a Creative Commons Paternité 4.0 International License

Identifiants

Citation

Ricardo Vilaça, Francisco Cruz, José Pereira, Rui Oliveira. An Effective Scalable SQL Engine for NoSQL Databases. Jim Dowling; François Taïani. 13th International Conference on Distributed Applications and Interoperable Systems (DAIS), Jun 2013, Florence, Italy. Springer, Lecture Notes in Computer Science, LNCS-7891, pp.155-168, 2013, Distributed Applications and Interoperable Systems. 〈10.1007/978-3-642-38541-4_12〉. 〈hal-01489453〉

Partager

Métriques

Consultations de la notice

187

Téléchargements de fichiers

114