An Effective Scalable SQL Engine for NoSQL Databases - Distributed Applications and Interoperable Systems
Conference Papers Year : 2013

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.
Fichier principal
Vignette du fichier
978-3-642-38541-4_12_Chapter.pdf (647.53 Ko) Télécharger le fichier
Origin Files produced by the author(s)
Loading...

Dates and versions

hal-01489453 , version 1 (14-03-2017)

Licence

Identifiers

Cite

Ricardo Vilaça, Francisco Cruz, José Pereira, Rui Oliveira. An Effective Scalable SQL Engine for NoSQL Databases. 13th International Conference on Distributed Applications and Interoperable Systems (DAIS), Jun 2013, Florence, Italy. pp.155-168, ⟨10.1007/978-3-642-38541-4_12⟩. ⟨hal-01489453⟩
278 View
443 Download

Altmetric

Share

More