Migration from NoSQL to SQL
Liberman, Daniel (2023)
2023
All rights reserved. This publication is copyrighted. You may download, display and print it for Your own personal use. Commercial use is prohibited.
Julkaisun pysyvä osoite on
https://urn.fi/URN:NBN:fi:amk-2023052413902
https://urn.fi/URN:NBN:fi:amk-2023052413902
Tiivistelmä
The thesis was under Nokia's premises, and the goal was to research and find methods for migrating from NoSQL to SQL. Moreover, part of the research identifies and analyses flaws in the NoSQL to learn from and act upon when shifting toward the new database. Furthermore, the research should also identify the functionalities of the new database, which would provide efficiency, maintainability, scalability, and security.
The research involves experimenting with different technologies like Python, JavaScript, SQL, and Docker. The programming languages provide the ability to create scripts and analyse the data flow and performance in real-time. Docker simplifies the process of experimenting with new technologies, such as PostgreSQL, as it provides a plug-and-play service to ease the development process.
The migration involves two significant components, NoSQL and SQL databases. Hence, the research splits into three different sections, consisting of an overview of the current state of MongoDB, the migration process, and PostgreSQL as the new database. Each section strives to provide insights into possible ways of structuring and developing toward best practices.
The study provides an overview of the migration process and its outcome. These insights can support others as a guideline for migrating from NoSQL to SQL. Although, each application is an individual case. However, there are core concepts that can assist in simplifying the process. The act of migration assists with the productization of Nokia's project, providing the necessary security, maintainability, and scalability to provide an exceptional product for its customers.
The research involves experimenting with different technologies like Python, JavaScript, SQL, and Docker. The programming languages provide the ability to create scripts and analyse the data flow and performance in real-time. Docker simplifies the process of experimenting with new technologies, such as PostgreSQL, as it provides a plug-and-play service to ease the development process.
The migration involves two significant components, NoSQL and SQL databases. Hence, the research splits into three different sections, consisting of an overview of the current state of MongoDB, the migration process, and PostgreSQL as the new database. Each section strives to provide insights into possible ways of structuring and developing toward best practices.
The study provides an overview of the migration process and its outcome. These insights can support others as a guideline for migrating from NoSQL to SQL. Although, each application is an individual case. However, there are core concepts that can assist in simplifying the process. The act of migration assists with the productization of Nokia's project, providing the necessary security, maintainability, and scalability to provide an exceptional product for its customers.