Impact Factor:6.549
 Scopus Suggested Journal: Tracking ID for this title suggestion is: 55EC484EE39417F0

International Journal
of Computer Engineering in Research Trends (IJCERT)

Scholarly, Peer-Reviewed, Platinum Open Access and Multidisciplinary




Welcome to IJCERT

International Journal of Computer Engineering in Research Trends. Scholarly, Peer-Reviewed, Platinum Open Access and Multidisciplinary

ISSN(Online):2349-7084                 Submit Paper    Check Paper Status    Conference Proposal

Back to Current Issues

Relational Database to NoSQL Conversion by Schema Migration and Mapping

Neelima Kuderu, Dr. Vijaya Kumari, , ,
Affiliations
JNTUH, Hyderabad
:10.22362/ijcert/2016/v3/i9/48900


Abstract
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.


Citation
Neelima Kuderu et.al ," Relational Database to NoSQL Conversion by Schema Migration and Mapping”, International Journal of Computer Engineering In Research Trends, Volume 3, Issue 9, September-2016, pp. 506-513


Keywords : Big Data, RDBMS, NoSQL, SQL, Schema Migration, SQL Mapping, CMS, Denormalization

References
[1] S. Lombardo, E. Di Nitto, and D. Ardagna, "Issues in Handling
Complex Data Structures with NoSQL Databases,"
Proceedings of the 14th International Symposium on
Symbolic and Numeric Algorithms for Scientific Computing
(SYNASC), pp. 443-448, Sept. 2012
[2] Yishan Li and S. Manoharan, "A performance comparison of
SQL and NoSQL databases," Proceedings of IEEE Pacific Rim
Conference on Communications, Computers and Signal
Processing (PACRIM), pp. 15- 19, Aug. 2013.
[3] A. Boicea, F. Radulescu, and L.I. Agapin, "MongoDB vs Oracle -
- Database Comparison," Proceedings of The 3rd International
Conference on Emerging Intelligent Data and Web
Technologies (EIDWT), pp.330- 335, Sept. 2012.
[4] K. Grolinger, M. Hayes, W.A. Higashino, A. L'Heureux, D.S.
Allison, and M.A.M. Capretz, "Challenges for MapReduce in
Big Data," Proceedings of IEEE World Congress on Services
(SERVICES), pp.182- 189, Jun. 2014.
[5] W. Naheman and Jianxin Wei, "Review of NoSQL databases
and performance testing on HBase," Proceedings of
International Conference on Mechatronic Sciences, Electric
Engineering and Computer (MEC), pp. 2304-2309, Dec. 2013.
[6] M. Scavuzzo, E. Di Nitto, and S. Ceri, "Interoperable Data
Migration between NoSQL Columnar Databases,"
Proceedings of IEEE 18th International Enterprise Distributed
Object Computing Conference Workshops and
Demonstrations (EDOCW), pp.154-162, Sept. 2014.
[7] Jen-Chun Hsu, Ching-Hsien Hsu, Shih-Chang Chen, and YehChing
Chung, "Correlation Aware Technique for SQL to
NoSQL Transformation," Proceedings of the 7th International
Conference on Ubi-Media Computing and Workshops
(UMEDIA), pp. 43-46, Jul. 2014.
[8] Gansen Zhao, Libo Li, Zijing Li, and Qiaoying Lin, "Multiple
Nested Schema of HBase for Migration from SQL,"
Proceedings of 9th International Conference on P2P, Parallel,
Grid, Cloud and Internet Computing (3PGCIC), pp.338-343,
Nov. 2014.
[9] Gansen Zhao, Qiaoying Lin, Libo Li, and Zijing Li, "Schema
Conversion Model of SQL Database to NoSQL," Proceedings
of 9th International Conference on P2P, Parallel, Grid, Cloud
and Internet Computing (3PGCIC), pp.355-362, Nov. 2014. 
[10] R. Sellami, S. Bhiri, and B. Defude, "ODBAPI: A Unified REST
API for Relational and NoSQL Data Stores," Proceedings of
IEEE International Congress on Big Data (BigData Congress),
pp.653-660, Jun. 2014.
[11] Xiang Li, Zhiyi Ma, and Hongjie Chen, "QODM: A queryoriented
data modeling approach for NoSQL databases,"
Proceedings of IEEE Workshop on Advanced Research and
Technology in Industry Applications (WARTIA), pp.338-345,
Sept. 2014.
[12] A. Gadkari, V.B. Nikam, and B.B. Meshram, "Implementing
Joins over HBase on Cloud Platform," Proceedings of IEEE
International Conference on Computer and Information
Technology (CIT), pp. 547- 554, Sept. 2014.
[13] Zhou Wei, G. Pierre, and Chi-Hung Chi, "Scalable Join Queries
in Cloud Data Stores," Proceedings of the 12th IEEE/ACM
International Symposium on Cluster, Cloud and Grid
Computing (CCGrid), pp.547- 555, May 2012.
[14] R. Lawrence, "Integration and Virtualization of Relational SQL
and NoSQL Systems Including MySQL and MongoDB,"
Proceedings of International Conference on Computational
Science and Computational Intelligence (CSCI), pp.285-290,
Mar. 2014.
[15] D. Van Hieu, S. Smanchat, and P. Meesad, "MapReduce join
strategies for key-value storage," Proceedings of the 11th
International Joint Conference on Computer Science and
Software Engineering (JCSSE), pp.164-169, May 2014.
[16] Mysql proxy. http://dev.mysql.com/refman /5.6/en/mysqlproxy.html.
Accessed:2014-09-24.
[17] Roberto Ierusalimschy, Luiz Henrique de Figueiredo, and
Waldemar Celes Filho. Lua—an: Ex-tensible extension
language. Softw. Pract. Exper., 26(6):635–652, June 1996.
[18] Jsql parser. http://jsqlparser.sourceforge.net/. Accessed:2014-
09-24.
[19] Mongodb mapping chart. http://docs.mongodb.org/
manual/reference/sql-comparison. Accessed:2014-09-24.


DOI Link : http://www.dx.doi.org/10.22362/ijcert/2016/v3/i9/48900

Download :
  V3I909.pdf


Refbacks : There is no refbacks

Support Us


We have kept IJCERT is a free peer-reviewed scientific journal to endorse conservation. We have not put up a paywall to readers, and we do not charge for publishing. But running a monthly journal costs is a lot. While we do have some associates, we still need support to keep the journal flourishing. If our readers help fund it, our future will be more secure.

Quick Links



DOI:10.22362/ijcert


Science Central

Score: 13.30





Submit your paper to editorijcert@gmail.com