Institutional Repository of Vilnius University
Duomenų migracija iš reliacinių į NoSQL duomenų bazes /
Abstract
dc:descriptionBachelor thesis investigates the process of data migration from relational to non-relational (NoSQL) database management systems. Work analyses the principles of relational systems, specifically PostgreSQL, including their application areas and substantiates the necessity to transition toward more flexible NoSQL solutions, particularly focusing on document-oriented NoSQL system MongoDB. The thesis presents a comparative analysis of PostgreSQL and MongoDB database systems and implements an automated data migration tool developed using Java, ensuring data integrity and validation of migrated data. The developed solution was benchmarked against available general purpose ETL data migration tools. In addition, a query performance analysis on migrated datasets was made. Experimental results indicate that specialized migration tool is faster than general purpose ETL solutions, particularly in handling larger scale data migrations. Further analysis revealed that although PostgreSQL is more efficient at executing complex queries requiring table joins, an optimized and denormalized MongoDB schema significantly improves performance of data retrieval and analytical queries, highlighting clear practical advantages of data migration to NoSQL based systems.
Degree
thesis:*- Grantor dc:publisher
- Institutional Repository of Vilnius University
- Year dc:date
- 2025
Author and committee
dc:creator, dc:contributor.*- Author dc:creator
-
- Sakovičius, Arnoldas,
Rights
dc:rights- Statement dc:rights
-
- info:eu-repo/semantics/openAccess
- Language dc:language
- lit
Identifiers
dc:identifier.*- Repository record dc:identifier
- https://repository.vu.lt/VU:ELABAETD239025347&prefLang=en_US