On Providing DDL Support for a Relational Layer over a Document NoSQL Database

Authors:
Gabriel dos Santos Ferreira;Andre Calil;Ronaldo dos Santos Mello
Affiliations:
Departamento de Informática e Estatística, Universidade Federal de Santa Catarina Florianópolis, Brazil;Departamento de Informática e Estatística, Universidade Federal de Santa Catarina Florianópolis, Brazil;Departamento de Informática e Estatística, Universidade Federal de Santa Catarina Florianópolis, Brazil
Venue:
Proceedings of International Conference on Information Integration and Web-based Applications & Services
Year:
2013

Citing 10
Cited 0

Mastering Regular Expressions

Mastering Regular Expressions
Cloud computing and emerging IT platforms: Vision, hype, and reality for delivering computing as the 5th utility

Future Generation Computer Systems
SQL databases v. NoSQL databases

Communications of the ACM
Extreme scale with full SQL language support in microsoft SQL Azure

Proceedings of the 2010 ACM SIGMOD International Conference on Management of data
Scalable SQL and NoSQL data stores

ACM SIGMOD Record
Adapting microsoft SQL server for cloud computing

ICDE '11 Proceedings of the 2011 IEEE 27th International Conference on Data Engineering
Phoenix: A Relational Storage Component for the Cloud

CLOUD '11 Proceedings of the 2011 IEEE 4th International Conference on Cloud Computing
SQLMR: A Scalable Database Management System for Cloud Computing

ICPP '11 Proceedings of the 2011 International Conference on Parallel Processing
NoSQL databases: a step to database scalability in web environment

Proceedings of the 13th International Conference on Information Integration and Web-based Applications and Services
SimpleSQL: a relational layer for SimpleDB

ADBIS'12 Proceedings of the 16th East European conference on Advances in Databases and Information Systems

Quantified Score

Hi-index	0.00

Visualization

Abstract

NoSQL databases are gaining ground due to the need for several applications to manipulate large volumes of data without worrying about database system tuning and scaling. However, many applications still use relational databases and do not want to replace their access methods in order to properly manipulate their data on the cloud using now a NoSQL technology. To deal with this problem, a relational-cloud mapping strategy, in terms of data model and data operations, is able to provide a relational view of NoSQL data, eliminating the need for adjustments in the application interface for data management. SimpleSQL is a solution for this problematic. It is a relational layer for Amazon SimpleDB, one of the most popular document NoSQL databases. Although SimpleSQL had proved to be a promising approach in terms of performance, its current version provides only the mapping of SQL DML operations. This paper presents an extension of SimpleSQL to support also DDL operations. This extension allows the creation and manipulation of the database schema from the application (client) side, abstracting any knowledge about data definition at SimpleDB. Preliminary experiments show that our solution continues to be feasible, since the overhead with DDL operations through SimpleSQL is not prohibitive.