An Effective Scalable SQL Engine for NoSQL Databases

Vilaça, Ricardo; Cruz, Francisco; Pereira, Jorge; Oliveira, Rui

doi:10.1007/978-3-642-38541-4_12

Cited by 16 publications

(10 citation statements)

References 18 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…The query processing module of the RDBMS makes requests to the modified storage manager that, in turn, maps relational data to data in compliance with a NoSQL data model. Three works fit into this category: Phoenix [50], CloudyStore [51] and DQE [52]. They are also detailed in the following in terms of architectural issues, schema mapping, and join processing.…”

Section: Storage Enginementioning

confidence: 99%

When Relational-Based Applications Go to NoSQL Databases: A Survey

2019

View full text Add to dashboard Cite

Several data-centric applications today produce and manipulate a large volume of data, the so-called Big Data. Traditional databases, in particular, relational databases, are not suitable for Big Data management. As a consequence, some approaches that allow the definition and manipulation of large relational data sets stored in NoSQL databases through an SQL interface have been proposed, focusing on scalability and availability. This paper presents a comparative analysis of these approaches based on an architectural classification that organizes them according to their system architectures. Our motivation is that wrapping is a relevant strategy for relational-based applications that intend to move relational data to NoSQL databases (usually maintained in the cloud). We also claim that this research area has some open issues, given that most approaches deal with only a subset of SQL operations or give support to specific target NoSQL databases. Our intention with this survey is, therefore, to contribute to the state-of-art in this research area and also provide a basis for choosing or even designing a relational-to-NoSQL data wrapping solution.

show abstract

Section: Storage Enginementioning

confidence: 99%

When Relational-Based Applications Go to NoSQL Databases: A Survey

2019

View full text Add to dashboard Cite

show abstract

“…Attempting to provide an SQL access layer on top of selected NoSQL database, a lot of efforts have been made by many scholars to increase the portability of the software system.…”

Section: Related Workmentioning

confidence: 99%

“…Some scholars studied the implementation method of SQL access layer of HBase database system. In literature, Apache Phoenix was used, which is an open‐source SQL translator for HBase , and it allows database users who are familiar with SQL to access HBase with frequently used SQL commands.…”

Section: Related Workmentioning

confidence: 99%

“…This reduces portability and requires system‐specific code . In order to solve the problem, many scholars have used different techniques to build SQL access layer for some NoSQL databases. The usual practice of these researchers was building an intermediate layer that parses SQL queries and translates them to the query languages or APIs of specific NoSQL systems.…”

Section: Introductionmentioning

confidence: 99%

See 1 more Smart Citation

An integration approach of hybrid databases based on SQL in cloud computing environment

2018

Softw Pract Exp

View full text Add to dashboard Cite

As the applications with big data in cloud computing environment grow, many existing systems expect to expand their service to support the dramatic increase of data, and modern software development for services computing and cloud computing software systems is no longer based on a single database but on existing multidatabases and this convergence needs new software architecture design. This paper proposes an integration approach to support hybrid database architecture, including MySQL, MongoDB, and Redis, to make it possible of allowing users to query data simultaneously from both relational SQL systems and NoSQL systems in a single SQL query. Two mechanisms are provided for constructing Redis's indexes and semantic transforming between SQL and Mon-goDB API to add the SQL feature for these NoSQL databases. With the proposed approach, hybrid database systems can be performed in a flexible manner, ie, access can be either relational database or NoSQL, depending on the size of data. The approach can effectively reduce development complexity and improve development efficiency of the software systems with multidatabases. This is the result of further research on the related topic, which fills the gap ignored by relevant scholars in this field to make a little contribution to the further development of NoSQL technology. /journal/spe 401 402 LI AND GU applications of NoSQL (not only SQL) database systems become more and more popular, it also poses a greater challenge to the development methods and technical architecture of software systems. A dramatic change, or called a revolution, is taking place in the field of database management technology as the growing of applications with big data in cloud computing environment. In June 1970, Edgar Frank Codd, a researcher of IBM company, published the famous paper, ie, A Relational Model of Data for Large Shared Data Banks, in Communications of ACM, which established the theoretical model of relational database. After decades of development, the relational database management system has gradually become mature, and the SQL (structured query language) used to access the relational database system also has been developed into the standard of all relational databases. However, big data and hybrid database system are becoming popular as cloud service blooms, and NoSQL database systems, such as Redis, 9 MongoDB, 10 HBase, 11 and Neo4J, 12 also have been developed rapidly.NoSQL systems have been developed to support applications not well served by relational systems, often involving big data processing. 13 Therefore, related research works have academic significance and practical values. Typical applications of NoSQL databases involve many important areas, such as the Internet, 14 mobile computation, 15 telecommunications, 16 bioinformatics, 17 education, 18 and energy. 19 Major NoSQL databases can be classified into four categories, [20][21][22] including key-value store, column-oriented store, document-oriented store, and graph store. Representative NoSQL database products include...

show abstract

“…One VM hosts the HBase Master, Zookeeper and Namenode. Derby [25] and the TPC-C benchmark are hosted in separate VMs. Each region server uses 1GB of memory as a shared cache across all underlying region instances.…”

Section: Tpc-c Experiments On a Cloud Platformmentioning

confidence: 99%

Rethinking HBase: Design and Implementation of an Elastic Key-Value Store over Log-Structured Local Volumes

Saloustros

Magoutis

2015

2015 14th International Symposium on Parallel and Distributed Computing

View full text Add to dashboard Cite

HBase is a prominent NoSQL system used widely in the domain of big data storage and analysis. It is structured as two layers: a lower-level distributed file system (HDFS) supporting the higher-level layer responsible for data distribution, indexing, and elasticity. Layered systems have in many occasions proven to suffer from overheads due to the isolation between layers; HBase is increasingly seen as an instance of this. To overcome this problem we designed, implemented, and evaluated HBase-BDB, an alternative to HBase that replaces the HDFS store with a thinner layer of a log-structured B+ tree key value store (Berkeley DB) operating over local volumes. We show that HBase-BDB overcomes HBase's performance bottlenecks (while retaining compatibility with HBase applications) without losing on elasticity features. We evaluate the performance of HBase and HBase-BDB using the Yahoo! Cloud Serving Benchmark (YCSB) and online transaction processing (OLTP) workloads on a commercial public Cloud provider. We find that HBase-BDB outperforms a tuned HBase configuration by up to 85% under a write-intensive workload due to HBase-BDB's reduced background-write activity. HBase-BDB's novel elasticity mechanisms operating over local volumes are shown to be as performant as HBase's equivalent features when stresstested under TPC-C workloads.

show abstract

An Effective Scalable SQL Engine for NoSQL Databases

Cited by 16 publications

References 18 publications

When Relational-Based Applications Go to NoSQL Databases: A Survey

When Relational-Based Applications Go to NoSQL Databases: A Survey

An integration approach of hybrid databases based on SQL in cloud computing environment

Rethinking HBase: Design and Implementation of an Elastic Key-Value Store over Log-Structured Local Volumes

Contact Info

Product

Resources

About