Author : Piyush Nikam 1
Date of Publication :7th April 2016
Abstract: Dynamic assessment and handling of big data has become tedious task nowadays. Database scalability is a burning issue, when it comes to usage of traditional Relational Database Management System (R DBMS), the scalability becomes a constraint after a certain data limit is reached. In order to deal with this problem parallel databases was proposed as a solution which was later replaced by a more effective and scalable solution known as No SQL database. Dynamic data handling ability of No SQL databases made it easy to store various types of data. Moreover, No SQL databases proved to be more scalable than the existing relational databases. The paper provides a survey of various query mapping techniques from SQL to No SQL. It also provides a comparative study of various mapping techniques based on various factors such as approach used, time complexity and databases used.
Reference :
-
- Chung, W. C., Lin, H. P., Chen, S. C., Jiang, M. F., & Chung, Y. C. (2014). JackHare: a framework for SQL to No SQL translation using MapReduce. Automated Software Engineering, 21(4), 489-508.
- Rocha, L., Vale, F., Cirilo, E., Barbosa, D., & Mourão, F. (2015). A Framework for Migrating Relational Datasets to No SQL. Procedia Computer Science, 51, 2593-2602
- Rith, J., Lehmayr, P. S., & Meyer-Wegener, K. (2014, March). Speaking in tongues: SQL access to No SQL systems. In Proceedings of the 29th Annual ACM Symposium on Applied Computing (pp. 855-857). ACM
- Arora, R., & Aggarwal, R. R. (2013). An Algorithm for Transformation of Data from MySQL to No SQL (Mongo DB). International Journal of Advanced Studies in Computer Science and Engineering (IJASCSE), 2(1).
- Hsu, J. C., Hsu, C. H., Chen, S. C., & Chung, Y. C. (2014, July). Correlation Aware Technique for SQL to No SQL Transformation. In Ubi-Media Computing and Workshops (UMEDIA), 2014 7th International Conference on (pp. 43-46). IEEE.
- Moatassem, N. N. (2015). A Study of Migrating Biological Data from Relational Databases to No SQL Databases (Doctoral dissertation, Youngstown State University)
- Xu, Y., & Hu, S. (2013, May). Qmapper: a tool for sql optimization on hive using query rewriting. In Proceedings of the 22nd international conference on World Wide Web companion (pp. 211-212). International World Wide Web Conferences Steering Committee
- Codd, E. F. (1970). A relational model of data for large shared data banks.Communications of the ACM, 13(6), 377- 387.
- Lee, R., Luo, T., Huai, Y., Wang, F., He, Y., & Zhang, X. (2011, June). Ysmart: Yet another sql-to-mapreduce translator. In Distributed Computing Systems (ICDCS), 2011 31st International Conference on (pp. 25-36). IEEE
- Manoj, V. (2014). Comparative study of No SQL Document, Column Store Databases and Evaluation Of Cassandra. International Journal of Database Management Systems (IJDMS), 6(4), 11-26
- Kumar, R., Gupta, N., Charu, S., Bansal, S., & Yadav, K. (2014). Comparison of SQL with HiveQL. International Journal for Research in Technological Studies, 1(9), 2348- 1439.
- Choi, Y. L., & Yoon, S. H. (2014). Improving Database System Performance by Applying No SQL. Journal of information processing systems, 10(3), 355-364.
- Cattell, R. (2011). Scalable SQL and No SQL data stores. ACM SIGMOD Record, 39(4), 12-27.
- Schram, A., & Anderson, K. M. (2012, October). MySQL to No SQL: data modeling challenges in supporting scalability. In Proceedings of the 3rd annual conference on Systems, programming, and applications: software for humanity(pp. 191-202). ACM.
- Roijackers, J., & Fletcher, G. H. L. (2012). Bridging sql and No SQL. Master's thesis, Eindhoven University of Technology
- Lawrence, R. (2014, March). Integration and virtualization of relational SQL and No SQL systems including MySQL and Mongo DB. In Computational Science and Computational Intelligence (CSCI), 2014 International Conference on (Vol. 1, pp. 285-290). IEEE