Data Migration Methodology from Relational to NoSQL Databases

Authors: Mohamed Hanine, Abdesadik Bendarag, Omar Boutkhoum

Abstract:

Currently, the field of data migration is very topical. As the number of applications developed rapidly, the ever-increasing volume of data collected has driven the architectural migration from Relational Database Management System (RDBMS) to NoSQL (Not Only SQL) database. This very recent technology is important enough in the field of database management. The main aim of this paper is to present a methodology for data migration from RDBMS to NoSQL database. To illustrate this methodology, we implement a software prototype using MySQL as a RDBMS and MongoDB as a NoSQL database. Although this is a hard engineering work, our results show that the proposed methodology can successfully accomplish the goal of this study.

Keywords: Data Migration, MySQL, RDBMS, NoSQL, MongoDB.

Digital Object Identifier (DOI): doi.org/10.5281/zenodo.1339211

References:

[1] B. Walek, K. Cyril, “A methodology for Data Migration between Different Database Management Systems”. World Academy of Science, Engineering and Technology Vol:6 2012-05-23
[2] B. Walek, K. Cyril, “Data Migration between Document-Oriented and Relational Databases”. World Academy of Science, Engineering and Technology Vol:6 2012-09-22
[3] M. Alam, and Krishan Wasan S. “Migration from Relational Database into Object Oriented Database”. Journal of Computer Science 2 (10): 781-784, 2006.
[4] X. Lixian, L. Yanhong, “Design and application of data migration system in heterogeneous Database”. International Forum on Information Technology and Applications 2010.
[5] N. Cory, L. Travis, I. Reenu, H. Gary, “Nosql Vs Rdbms - Why There Is Room for Both”. Proceedings of the Southern Association for Information Systems Conference, Savannah, GA, USA March 8th–9th, 2013.
[6] M.A Mohamed, O.G Altrafi, M.O Ismail, “Relational vs. NoSQL Databases: A Survey”. International Journal of Computer and Information Technology (ISSN: 2279 – 0764) Volume 03 – Issue 03, May 2014.
[7] R. Cattell, “Scalable SQL and NoSQL Data Stores”. SIGMOD Record, December 2010 (Vol. 39, No. 4)
[8] MongoDB, (2014) The MongoDB 2.6 Manual: http://docs.mongodb.org/manual
[9] NoSQL, (2014) Making sense of NoSQL, A guide for managers and the rest of us: Dan McCreary et Ann Kelly. 2014.
[10] Migration Guide, (2015) RDBMS to MongoDB Migration Guide Considerations and Best Practices a MongoDB White Paper February 2015.