Impact Factor:6.549
 Scopus Suggested Journal: UNDER REVIEW for TITLE INCLUSSION

International Journal
of Computer Engineering in Research Trends (IJCERT)

Scholarly, Peer-Reviewed, Open Access and Multidisciplinary


Welcome to IJCERT

International Journal of Computer Engineering in Research Trends. Scholarly, Peer-Reviewed,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

Announcements


Authors are not required to pay any article-processing charges (APC) for their article to be published open access in Journal IJCERT. No charge is involved in any stage of the publication process, from administrating peer review to copy editing and hosting the final article on dedicated servers. This is free for all authors. 

News & Events


Latest issue :Volume 10 Issue 1 Articles In press

A plagiarism check will be implemented for all the articles using world-renowned software. Turnitin.


Digital Object Identifier will be assigned for all the articles being published in the Journal from September 2016 issue, i.e. Volume 3, Issue 9, 2016.


IJCERT is a member of the prestigious.Each of the IJCERT articles has its unique DOI reference.
DOI Prefix : 10.22362/ijcert


IJCERT is member of The Publishers International Linking Association, Inc. (“PILA”)


Emerging Sources Citation Index (in process)


IJCERT title is under evaluation by Scopus.


Key Dates


☞   INVITING SUBMISSIONS FOR THE NEXT ISSUE :
☞   LAST DATE OF SUBMISSION : 31st March 2023
☞  SUBMISSION TO FIRST DECISION :
In 7 Days
☞  FINAL DECISION :
IN 3 WEEKS FROM THE DAY OF SUBMISSION

Important Announcements


All the authors, conference coordinators, conveners, and guest editors kindly check their articles' originality before submitting them to IJCERT. If any material is found to be duplicate submission or sent to other journals when the content is in the process with IJCERT, fabricated data, cut and paste (plagiarized), at any stage of processing of material, IJCERT is bound to take the following actions.
1. Rejection of the article.
2. The author will be blocked for future communication with IJCERT if duplicate articles are submitted.
3. A letter regarding this will be posted to the Principal/Director of the Institution where the study was conducted.
4. A List of blacklisted authors will be shared among the Chief Editors of other prestigious Journals
We have been screening articles for plagiarism with a world-renowned tool: Turnitin However, it is only rejected if found plagiarized. This more stern action is being taken because of the illegal behavior of a handful of authors who have been involved in ethical misconduct. The Screening and making a decision on such articles costs colossal time and resources for the journal. It directly delays the process of genuine materials.

Citation Index


Citations Indices All
Citations 1026
h-index 14
i10-index 20
Source: Google Scholar

Acceptance Rate (By Year)


Acceptance Rate (By Year)
Year Rate
2021 10.8%
2020 13.6%
2019 15.9%
2018 14.5%
2017 16.6%
2016 15.8%
2015 18.2%
2014 20.6%

Important Links



Conference Proposal




DOI:10.22362/ijcert