research-article

Model Transformation From Object Relational Database to NoSQL Document Database

Authors:

Toufik Fouad,

Bahaj MohamedAuthors Info & Claims

NISS '19: Proceedings of the 2nd International Conference on Networking, Information Systems & Security

Article No.: 49, Pages 1 - 5

https://doi.org/10.1145/3320326.3320381

Published: 27 March 2019 Publication History

Get Access

Abstract

With the high increase of data growing, NoSQL databases play a key role in storing large amount of data, to gain flexibility and scalability many industries are now replacing their relational and object relational databases by adopting NoSQL database technology for business application. However, a lot of work have been done to transform the schema and migrate the data from relational database to MongoDB, but as far as we know a few approaches has been proposed to cover the object relational database transformation. This paper describes some approaches of migration, and proposes an approach of model transformation from object relational database to NoSQL document database (MongoDB).

References

[1]

M. Fotache, C. Strîmbei, "Object-Relational Databases: An Area with Some Theoretical Promises and Few Practical Achievements", Communications of the IBIMA, v.9, 2009, ISSN 1943-7765.

Google Scholar

[2]

Z.Gansen, L.Qiaoying, L.Libo, L.Zijing, Schema Conversion Model of SQL Database to NoSQL, 2014 Ninth International Conference on P2P, Parallel, Grid, Cloud and Internet Computing

Digital Library

Google Scholar

[3]

Parker, Zachary, POE, Scott, et Vrbsky, Susan V. Comparing nosql mongodb to an sql db. In: Proceedings of the 51st ACM Southeast Conference. ACM, 2013. p. 5.

Digital Library

Google Scholar

[4]

G. Zhao, W. Huang, S. Liang, and Y. Tang, "Modeling mongodb with relational model," in Emerging Intelligent Data and Web Technologies (EIDWT), 2013 Fourth InternationalConference on. IEEE, 2013, pp. 115--121.

Digital Library

Google Scholar

[5]

A. Kanade, A. Gopal, and S. Kanade, "A study of normalization and embedding in mongodb," in Advance Computing Conference (IACC), 2014 IEEE International. IEEE, 2014,pp. 416--421.

Google Scholar

[6]

Apache Software Foundation http://sqoop.apache.org/

Google Scholar

[7]

M. Casters, R. Bouman, and J. Van Dongen, Pentaho Kettle solutions: building open source ETL solutions with Pentaho Data Integration. John Wiley & Sons, 2010.

Digital Library

Google Scholar

[8]

Chung, Wu-Chun, LIN, Hung-Pin, Chen, Shih-Chang, et al. JackHare: a framework for SQL to NoSQL translation using MapReduce. Automated Software Engineering, 2014, vol. 21, no 4, p. 489--508.

Digital Library

Google Scholar

[9]

C. Li, "Transforming relational database into hbase: A case study," in Software Engineering and Service Sciences (ICSESS), 2010 IEEE International Conference on. IEEE, 2010, pp. 683--687.

Google Scholar

[10]

Lawrence, Roger. Integration and virtualization of relational SQL and NoSQL systems including MySQL and MongoDB. In: Computational Science and Computational Intelligence (CSCI), 2014 International Conference on. IEEE, 2014. p. 285--290.

Digital Library

Google Scholar

[11]

T. Jia, X. Zhao, Z. Wang, D. Gong, G. Ding, "Model transformation and data migration from relational database to mongodb", 2016 IEEE International Congress on Big Data (BigData Congress), pp. 60--67, June 2016.

Crossref

Google Scholar

[12]

MongoDB Documentation https://docs.mongodb.com/

Google Scholar

Cited By

View all

Aggoune ANamoune M(2022)P3 Process for Object-Relational Data Migration to NoSQL Document-Oriented DatastoreInternational Journal of Software Science and Computational Intelligence10.4018/IJSSCI.30999414:1(1-20)Online publication date: 30-Sep-2022
https://dl.acm.org/doi/10.4018/IJSSCI.309994
Ha MShichkina Y(2022)Translating a Distributed Relational Database to a Document DatabaseData Science and Engineering10.1007/s41019-022-00181-97:2(136-155)Online publication date: 3-Mar-2022
https://doi.org/10.1007/s41019-022-00181-9
Ha MShichkina YFatkieva R(2022)NoSql Database Optimization Based on Metadata About Queries and Relationships Between ObjectsComputational Science and Its Applications – ICCSA 2022 Workshops10.1007/978-3-031-10542-5_40(588-602)Online publication date: 4-Jul-2022
https://dl.acm.org/doi/10.1007/978-3-031-10542-5_40
Show More Cited By

Index Terms

Model Transformation From Object Relational Database to NoSQL Document Database
1. Software and its engineering
  1. Software creation and management
    1. Software post-development issues
      1. Software reverse engineering

Recommendations

Comparing NoSQL MongoDB to an SQL DB
ACMSE '13: Proceedings of the 51st annual ACM Southeast Conference

NoSQL database solutions are becoming more and more prevalent in a world currently dominated by SQL relational databases. NoSQL databases were designed to provide database solutions for large volumes of data that is not structured. However, the ...
Model Transformation From Object Relational Database to NoSQL Column Based Database
NISS '20: Proceedings of the 3rd International Conference on Networking, Information Systems & Security

NoSQL 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 ...
A Framework to Convert NoSQL to Relational Model
ACIT '18: Proceedings of the 6th ACM/ACIS International Conference on Applied Computing and Information Technology

Due to the exponential growth of NoSQL databases and in addition the circumstance of perusing humongous volumes of information, maximum applications switch RDBMS to NoSQL and pick it as information stockpiling framework. But we all know that RDBMS have ...

Comments

Please enable JavaScript to view thecomments powered by Disqus.

Information & Contributors

Information

Published In

NISS '19: Proceedings of the 2nd International Conference on Networking, Information Systems & Security

March 2019

512 pages

ISBN:9781450366458

DOI:10.1145/3320326

Editors:
Badr Abouelmajd
FSR, Mohammed V University, Morocco
,
Mohamed Ben Ahmed
FSTT, Abdelmalek Essaâdi University, Morocco
,
Boudhir Anouar Abdelhakim
FSTT, Abdelmalek Essaâdi University, Morocco
,
Hassan El Ghazi
INPT, Morocco

Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 27 March 2019

Permissions

Request permissions for this article.

Request Permissions

Check for updates

Author Tags

Qualifiers

Research-article
Research
Refereed limited

Conference

NISS19

NISS19: Networking, Information Systems & Security

March 27 - 29, 2019

Rabat, Morocco

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

6
Total Citations
View Citations
362
Total Downloads

Downloads (Last 12 months)28
Downloads (Last 6 weeks)1

Reflects downloads up to 29 Nov 2024

Other Metrics

View Author Metrics

Citations

Cited By

View all

Aggoune ANamoune M(2022)P3 Process for Object-Relational Data Migration to NoSQL Document-Oriented DatastoreInternational Journal of Software Science and Computational Intelligence10.4018/IJSSCI.30999414:1(1-20)Online publication date: 30-Sep-2022
https://dl.acm.org/doi/10.4018/IJSSCI.309994
Ha MShichkina Y(2022)Translating a Distributed Relational Database to a Document DatabaseData Science and Engineering10.1007/s41019-022-00181-97:2(136-155)Online publication date: 3-Mar-2022
https://doi.org/10.1007/s41019-022-00181-9
Ha MShichkina YFatkieva R(2022)NoSql Database Optimization Based on Metadata About Queries and Relationships Between ObjectsComputational Science and Its Applications – ICCSA 2022 Workshops10.1007/978-3-031-10542-5_40(588-602)Online publication date: 4-Jul-2022
https://dl.acm.org/doi/10.1007/978-3-031-10542-5_40
Hayat S(2020)Modeling and Transformation from Temporal Object Relational Database into Mongodb: RulesAdvances in Science, Technology and Engineering Systems Journal10.25046/aj0504735:4(618-625)Online publication date: 2020
https://doi.org/10.25046/aj050473
Fouad TMohamed BBen Ahmed MBoudhir A(2020)Model Transformation From Object Relational Database to NoSQL Column Based DatabaseProceedings of the 3rd International Conference on Networking, Information Systems & Security10.1145/3386723.3387881(1-5)Online publication date: 31-Mar-2020
https://dl.acm.org/doi/10.1145/3386723.3387881
AGGOUNE ANAMOUNE M(2020)A Method for Transforming Object-relational to Document-oriented Databases2020 2nd International Conference on Mathematics and Information Technology (ICMIT)10.1109/ICMIT47780.2020.9047011(154-158)Online publication date: Feb-2020
https://doi.org/10.1109/ICMIT47780.2020.9047011

View Options

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Cited By

Index Terms

Recommendations

Comparing NoSQL MongoDB to an SQL DB

Model Transformation From Object Relational Database to NoSQL Column Based Database

A Framework to Convert NoSQL to Relational Model