SimpleSQL: a relational layer for SimpleDB

Authors:
Andre Calil;Ronaldo dos Santos Mello
Affiliations:
Universidade Federal de Santa Catarina, Florianópolis, Santa Catarina, Brazil;Universidade Federal de Santa Catarina, Florianópolis, Santa Catarina, Brazil
Venue:
ADBIS'12 Proceedings of the 16th East European conference on Advances in Databases and Information Systems
Year:
2012

Citing 5
Cited 1

Mastering Regular Expressions

Mastering Regular Expressions
Architectural styles and the design of network-based software architectures

Architectural styles and the design of network-based software architectures
Cloud computing and emerging IT platforms: Vision, hype, and reality for delivering computing as the 5th utility

Future Generation Computer Systems
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

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

Proceedings of International Conference on Information Integration and Web-based Applications & Services

Quantified Score

Hi-index	0.00

Visualization

Abstract

This paper introduces SimpleSQL, a relational layer over Amazon SimpleDB, one of the most popular document-oriented cloud databases. SimpleSQL offers a SQL interface that abstracts any knowledge about data modeling, data persistence and data accessing at SimpleDB. This paper presents the architecture, data and operation mapping from a relational database to SimpleDB, as well as some experiments that evaluate query performance on accessing cloud data using SimpleSQL and using only SimpleDB. Our contribution is a solution for accessing SimpleDB through a relational layer, being the basis for a general approach to relational-to-(document) cloud mapping. The experimental evaluation shows that our solution is promising, since the over-head with data accessing through SimpleSQL is not prohibitive.