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.
- Amazon Relational Database Service. http://aws.amazon.com/rds/, 2013.Google Scholar
- REST API. http://docs.aws.amazon.com/AmazonSimpleDB/latest/DeveloperGuide/MakingRESTRequests.html, 2013.Google Scholar
- Simple DB. http://aws.amazon.com/simpledb/, 2013.Google Scholar
- D. Arnaut, R. Schroeder, and C. S. Hara. Phoenix: A Relational Storage Component for the Cloud. In IEEE CLOUD, pages 684--691, July 2011. Google ScholarDigital Library
- P. A. Bernstein, I. Cseri, N. Dani, N. Ellis, A. Kalhan, G. Kakivaya, D. B. Lomet, R. Manne, L. Novik, and T. Talius. Adapting Microsoft SQL Server for Cloud Computing. In 27th International Conference on Data Engineering (ICDE), pages 1255--1263, April 2011. Google ScholarDigital Library
- R. Buyya, C. S. Yeo, S. Venugopal, J. Broberg, and I. Brandic. Cloud Computing and Emerging IT Platforms: Vision, Hype, and Reality for Delivering Computing as the 5th Utility. Future Generation Computer Systems, 25(6):599--616, June 2009. Google ScholarDigital Library
- A. Calil and R. dos Santos Mello. SimpleSQL: A Relational Layer for SimpleDB. 16th East-European Conference on Advances in Databases and Information Systems (ADBIS) - Lecture Notes in Computer Science, 39:99--110, September 2012. Google ScholarDigital Library
- D. G. Campbell, G. Kakivaya, and N. Ellis. Extreme Scale with Full SQL Language Support in Microsoft SQL Azure. In ACM SIGMOD International Conference on Management of Data, pages 1021--1024, June 2010. Google ScholarDigital Library
- R. Cattell. Scalable SQL and NoSQL Data Stores. SIGMOD Record, 39(4):12--27, December 2010. Google ScholarDigital Library
- C. Curino, E. P. C. Jones, R. A. Popa, N. Malviya, E. Wu, S. Madden, H. Balakrishnan, and N. Zeldovich. Relational Cloud: a Database Service for the Cloud. In 5th Biennial Conference on Innovative Data Systems Research (CIDR), pages 235--240, January 2011.Google Scholar
- D. Egger. SQL in the Cloud. Master's thesis, Swiss Federal Institute of Technology Zurich (ETH), Swiss, 2009.Google Scholar
- J. E. F. Friedl. Mastering Regular Expressions. O Reilly, 2002. Google ScholarDigital Library
- J. Han, E. Haihong, G. Le, and J. Du;. "Survey on NoSQL Database. In 6th International Conference on Pervasive Computing and Applications (ICPCA), pages 363--366, October 2011.Google Scholar
- M.-J. Hsieh, C.-R. Chang, L.-Y. Ho, J.-J. Wu, and P. Liu. SQLMR: A Scalable Database Management System for Cloud Computing. In International Conference on Parallel Processing (ICPP), pages 315--324, September 2011. Google ScholarDigital Library
- A. B. M. Moniruzzaman and S. A. Hossain. NoSQL Database: New Era of Databases for Big data Analytics - Classification, Characteristics and Comparison. International Journal of Database Theory and Application, 6(4), 2013.Google Scholar
- J. Pokorny. NoSQL Databases: A Step to Database Scalability in Web Environment. In 13th International Conference on Information Integration and Web-based Applications and Services (iiWAS), pages 278--283, December 2011. Google ScholarDigital Library
- M. Stonebreaker. SQL Databases v. NoSQL Databases. Communications of the ACM, 53(4):10, 2010. Google ScholarDigital Library
- R. Vilaça, F. Cruz, J. Pereira, and R. Oliveira. An Effective Scalable SQL Engine for NoSQL Databases. In Distributed Applications and Interoperable Systems - 13th IFIP WG 6.1 International Conference (DAIS), pages 155--168, June 2013.Google Scholar
Index Terms
- On Providing DDL Support for a Relational Layer over a Document NoSQL Database
Recommendations
Model Transformation From Object Relational Database to NoSQL Column Based Database
NISS '20: Proceedings of the 3rd International Conference on Networking, Information Systems & SecurityNoSQL databases play an important role in saving a huge amount of data. To benefit from the advantages of horizontal scalability and flexibility and with the fast data growing many companies are now replacing their traditional database management ...
Incorporating NoSQL into a database course
This article introduces the concepts of Big Data and NoSQL and describes a semester long web-based project that uses both a relational database (Oracle 11g) and a NoSQL (MongoDB) database for an undergraduate database course. The relational database ...
Migration of Relational Database to Document-Oriented Database: Structure Denormalization and Data Transformation
CICSYN '15: Proceedings of the 2015 7th International Conference on Computational Intelligence, Communication Systems and NetworksRelational databases remain the leading data storage technology. Nevertheless, many companies want to reduce operating expenses, to make scalable applications that use cloud computing technologies. Use of NoSQL database is one of the possible solutions, ...
Comments