Relational Database to NoSQL Conversion by Schema Migration and Mapping

In pc software development, migration from a Data Base Management System (DBMS) to NOSQL, specifically applications like material administration systems with distinct attributes is a challenge for coders and database directors. Changes in the application rule in purchase to comply with new DBMS tend to be generally vast, causing migrations infeasible. In order to tackle this problem that is nagging we present RDBDMS-to-NoSQL by schema migration and query mapping to help conveniently migrating from relational DBMS to NoSQL DBMS. This framework is presented in two components: (1) schema mapping by reverting the forms that are regular, (2) mapping SQL query to NoSQL. Initial one is a set of practices enabling migration that is smooth relational DBMS to NOSQL DBMS. The latter provides a persistence layer to process database needs, becoming capable to translate and execute these demands in any DBMS, going back the information in a format that is suitable really. Experiments shown that the proposed design is scalable and robust to manage volume that is huge of of applications such CMS that contrasted to conventional relational DBMS techniques.

[1]  Zijing Li,et al.  Multiple Nested Schema of HBase for Migration from SQL , 2014, 2014 Ninth International Conference on P2P, Parallel, Grid, Cloud and Internet Computing.

[2]  Marco Scavuzzo,et al.  Interoperable Data Migration between NoSQL Columnar Databases , 2014, 2014 IEEE 18th International Enterprise Distributed Object Computing Conference Workshops and Demonstrations.

[3]  Wumuti Naheman,et al.  Review of NoSQL databases and performance testing on HBase , 2013, Proceedings 2013 International Conference on Mechatronic Sciences, Electric Engineering and Computer (MEC).

[4]  Sami Bhiri,et al.  ODBAPI: A Unified REST API for Relational and NoSQL Data Stores , 2014, 2014 IEEE International Congress on Big Data.

[5]  Ching-Hsien Hsu,et al.  Correlation Aware Technique for SQL to NoSQL Transformation , 2014, 2014 7th International Conference on Ubi-Media Computing and Workshops.

[6]  Danilo Ardagna,et al.  Issues in Handling Complex Data Structures with NoSQL Databases , 2012, 2012 14th International Symposium on Symbolic and Numeric Algorithms for Scientific Computing.

[7]  Phayung Meesad,et al.  MapReduce join strategies for key-value storage , 2014, 2014 11th International Joint Conference on Computer Science and Software Engineering (JCSSE).

[8]  Xiang Li,et al.  QODM: A query-oriented data modeling approach for NoSQL databases , 2014, 2014 IEEE Workshop on Advanced Research and Technology in Industry Applications (WARTIA).

[9]  Zhou Wei,et al.  Scalable Join Queries in Cloud Data Stores , 2012, 2012 12th IEEE/ACM International Symposium on Cluster, Cloud and Grid Computing (ccgrid 2012).

[10]  Ramon Lawrence.  Integration and Virtualization of Relational SQL and NoSQL Systems Including MySQL and MongoDB , 2014, 2014 International Conference on Computational Science and Computational Intelligence.

[11]  B. B. Meshram,et al.  Implementing Joins over HBase on Cloud Platform , 2014, 2014 IEEE International Conference on Computer and Information Technology.

[12]  Sathiamoorthy Manoharan,et al.  A performance comparison of SQL and NoSQL databases , 2013, 2013 IEEE Pacific Rim Conference on Communications, Computers and Signal Processing (PACRIM).

[13]  Zijing Li,et al.  Schema Conversion Model of SQL Database to NoSQL , 2014, 2014 Ninth International Conference on P2P, Parallel, Grid, Cloud and Internet Computing.

[14]  Miriam A. M. Capretz,et al.  Challenges for MapReduce in Big Data , 2014, 2014 IEEE World Congress on Services.

[15]  Florin Radulescu,et al.  MongoDB vs Oracle -- Database Comparison , 2012, 2012 Third International Conference on Emerging Intelligent Data and Web Technologies.