Please use this identifier to cite or link to this item: http://repositorio.inesctec.pt/handle/123456789/4164
Title: An effective scalable SQL engine for NoSQL databases
Authors: Ricardo Pereira Vilaça
Francisco Miguel Cruz
José Orlando Pereira
Rui Carlos Oliveira
Issue Date: 2013
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. © 2013 IFIP International Federation for Information Processing.
URI: http://repositorio.inesctec.pt/handle/123456789/4164
http://dx.doi.org/10.1007/978-3-642-38541-4_12
metadata.dc.type: conferenceObject
Publication
Appears in Collections:HASLab - Indexed Articles in Conferences

Files in This Item:
File Description SizeFormat 
P-008-ER0.pdf647.53 kBAdobe PDFView/Open


Items in DSpace are protected by copyright, with all rights reserved, unless otherwise indicated.