An integral approach for complete migration from a relational database to MongoDB


  • Abdelhak Erraji RITM ESTC Laboratory Hassan II University, ENSEM Casablanca, Morocco
  • Abderrahim Maizate RITM ESTC Laboratory Hassan II University, ESTC Casablanca, Morocco
  • Mohamed Ouzzif RITM ESTC Laboratory Hassan II University, ESTC Casablanca, Morocco


Data Migration, Database Transformation, NoSQL, Big Data, Data, ETL, approach


Today, computing has become an obligation in the lives of individuals and institutions alike. This magical sector uses and develops very rich, important, and sensitive tools and solutions, which make everyone's life easier. Computers with their tools have become indispensable and they have transformed the world into a small town. These tools revolve around data, the type, nature, and size of which continually increases up to zeta bytes of storage capacity, thus creating BigData. Considering that Relational databases present difficulties in the management of BigData, and Knowing that companies want to keep their data accumulated over decades of exercises and studies on the market, and also taking into account the cost impact if they kept both systems in terms of software, technical support and user training; therefore it is legitimate to find a reliable way to migrate their data from the relational system to a NoSQL system, which designed specifically to handle BigData. In this optic, several studies and approaches have been developed, but they present a lack or weaknesses in the treatment of the main components of the database, which we are going to deal with in our new and integrated approach to migration from the relational database system to MongoDB as a NoSQL system. In this article, we will present our contribution by developing a complete concept of our approach, starting with an introduction, which will be followed by a discussion of what other researchers have done in this direction, then we move on to a phase of analysis and modeling to develop the models and meta-models of the two systems: source and destination, also during this section we also present our analysis and modeling methodology, to present our global approach which divides its treatment into three axes, each of which processes a part of the RDBMS with a particular nature of data: data stored in tables, data carried on the structure of the RDBMS and data coming from the semantics of relational databases. The overall architecture of our approach, which we named ''TMSDRDND'', is formed by two layers: ''TSRSNLayer'' which deals with the transformation of the structure and the transfer of semantic data, and the ''MDRSNLayer'' layer, Which takes care of data migration using an ETL to be developed according to a specific concept and architecture and exploiting the results of the first layer.


The digital universe of opportunities, Available:

Data is eating the world, Available:

O. J. Ibidoja, F. P. Shan, J. Sulaiman & M. K. M. Ali, “Robust Mestimators and Machine Learning Algorithms for Improving the Predictive Accuracy of Seaweed Contaminated Big Data”, Journal of the Nigerian Society of Physical Sciences 5 (2023) 1137. DOI:

M. A. Okono, E. P. Agbo, B. J. Ekah, U. J. Ekah, E. B. Ettah & C. O. Edet, “Statistical analysis and distribution of global solar radiation and temperature over southern Nigeria”, Journal of the Nigerian Society of Physical Sciences 4 (2022) 588. DOI:

M. V. Sokolova, F. J. G´omez & L. N. Borisoglebskaya, “Migration from an SQL to a hybrid SQL/NoSQL data model”, Journal of Management Analytics 7 (2020) 1. DOI:

V. F. de Oliveira, M. A. de Oliveira Pessoa, F. Junqueira & P. E. Miyagi, “SQL and NoSQL Databases in the Context of Industry 4.0”, Machines 10.1 (2022) 20. DOI:

I. Mearaj, P. Maheshwari & M. J. Kaur, “Data conversion from the traditional relational database to MongoDB using XAMPP and NoSQL”, In 2018 Fifth HCT Information Technology Trends (ITT) (2018) 94. DOI:

M. G. Gopalan, C. Prasanna, Y. S. Krishna, B. Shanthini & A. Arulkumar, “MYSQL to cassandra conversion engine.”, In 2017 Third International Conference on Sensing, Signal Processing and Security (ICSSS) (2017) 503. DOI:

Y. S. Wijaya & A. A. Arman, “A framework for data migration between different datastore of NoSQL database”, In 2018 International Conference on ICT for Smart Society (ICISS) (2018) 1. DOI:

J. Kachaoui & A. Belangour, “MQL2SQL: A proposal data transformation algorithm from mongoDB to RDBMS.”, International Journal of Advanced Trends in Computer Science and Engineering in progress (2020). DOI:

G. B. Solanke & K. Rajeswari, “Migration of relational database to MongoDB and Data Analytics using Na¨?ve Bayes classifier based on Mapreduce approach”, In 2017 International Conference on Computing, Communication, Control and Automation (ICCUBEA) (2017) 1. DOI:

K. C? ernjeka, D. Jaks?ic´ & V. Jovanovic, “NoSQL document store translation to data vault based EDW”, In 2018 41st International Convention on Information and Communication Technology, Electronics and Microelectronics (MIPRO) (2018) 1197. DOI:

B. Namdeo & U. Suman, “Schema design advisor model for RDBMS to NoSQL database migration”, International Journal of Information Technology 13 (2021) 277. DOI:

S. Ghule & R. Vadali, “Transformation of SQL system to NoSQL system and performing data analytics using SVM”, In 2017 International Conference on Trends in Electronics and Informatics (ICEI) (2017) (883). DOI:

F. Yassine & M. A. Awad, “Migrating from SQL to NOSQL Database: Practices and Analysis”, In 2018 International Conference on Innovations in Information Technology (IIT) (2018) 58. DOI:

K. Shiromoto, T. Hochin & H. Nomiya, “Integrated usage between relational DBs and NoSQL DB”, In 2019 20th IEEE/ACIS International Conference on Software Engineering, Artificial Intelligence, Networking and Parallel/Distributed Computing (SNPD) (2019) 244. DOI:

B. Jose & S. Abraham, “Exploring the merits of nosql: A study based on mongodb”, In 2017 International Conference on Networks and Advances in Computational Technologies (NetACT) (2017) (266). DOI:

D. Sevilla Ruiz, S. F. Morales & J. Garc´?a Molina,“Inferring versioned schemas from NoSQL databases and its applications”, In Conceptual Modeling: 34th International Conference, ER 2015, Stockholm, Sweden, Proceedings 34 (2015) 467. DOI:

MongoDB Manual, Available:



How to Cite

Erraji, A., Maizate, A., & Ouzzif, M. (2023). An integral approach for complete migration from a relational database to MongoDB. Journal of the Nigerian Society of Physical Sciences, 5(2), 1089.



Review Article