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.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Armbrust, M., Fox, A., Griffith, R., Joseph, A.D., et al.: Above the clouds: A berkeley view of cloud computing. Technical report, EECS Department, University of California, Berkeley, Tech. Rep. UCB/EECS-2009-28 (2009)
Buyya, R., Yeo, C.S., Venugopal, S., et al.: Cloud computing and emerging it platforms: Vision, hype, and reality ford elivering computing as the 5th utility. In: Future Generation Computing Systems, pp. 599–616 (2009)
Microsoft: Msdn library, guid structure (2012), http://msdn.microsoft.com/en-us/library/system.guid%28v=vs.90%29.aspx
Abadi, D.J.: Data management in the cloud: Limitations and opportunities. IEEE Computer Society Technical Committee on Data Engineering 32, 3–12 (2009)
Sousa, F.R.C., Moreira, L.O., de Macêdo, J.A.F., Machado, J.C.: Gerenciamento de dados em nuvem: Conceitos, sistemas e desafios. In: Topicos em sistemas colaborativos, interativos, multimidia, web e bancos de dados, Sociedade Brasileira de Computacao, pp. 101–130 (2010)
Cattell, R.: Scalable sql and nosql data stores. In: SIGMOD (2010)
Amazon: Amazon simpledb (2012), http://aws.amazon.com/en/simpledb/
Amazon: Amazon simpledb, getting started guide (2012), http://docs.amazonwebservices.com/AmazonSimpleDB/latest/GettingStartedGuide
Fielding, R.T.: Architectural Styles and the Design of Network-based Software Architectures. Master’s thesis. University of California (2000)
Friedl, J.E.F.: Mastering Regular Expressions, 2nd edn. OReilly (2002)
Curino, C., Jones, E.P.C., Popa, R.A., et al.: Relational cloud: a database service for the cloud. In: CIDR, pp. 235–240 (2011)
Campbell, D.G., Kakivaya, G., Ellis, N.: Extreme scale with full sql language support in microsoft sqlazure. In: Proceedings of the 2010 ACM SIGMOD International Conference on Management of data, SIGMOD 2010, pp. 1021–1024. ACM, New York (2010)
Amazon: Amazon relational database service (2012), http://aws.amazon.com/en/rds/
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2012 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Calil, A., dos Santos Mello, R. (2012). SimpleSQL: A Relational Layer for SimpleDB. In: Morzy, T., Härder, T., Wrembel, R. (eds) Advances in Databases and Information Systems. ADBIS 2012. Lecture Notes in Computer Science, vol 7503. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-33074-2_8
Download citation
DOI: https://doi.org/10.1007/978-3-642-33074-2_8
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-33073-5
Online ISBN: 978-3-642-33074-2
eBook Packages: Computer ScienceComputer Science (R0)