Result: Duomenų migravimas tarp SQL ir NoSQL duomenų bazių / ; Data migration between sql and nosql databases.

Title:
Duomenų migravimas tarp SQL ir NoSQL duomenų bazių / ; Data migration between sql and nosql databases.
Contributors:
Ričkus, Liutauras
Publisher Information:
Institutional Repository of Vilnius University
Publication Year:
2020
Collection:
Vilnius University Virtual Library (VU VL) / Vilniaus universitetas virtuali biblioteka
Document Type:
Dissertation/ Thesis bachelor thesis
File Description:
application/pdf
Language:
Lithuanian
Rights:
info:eu-repo/semantics/openAccess
Accession Number:
edsbas.BA9C194D
Database:
BASE

Further Information

Nowadays, many programs and software applications are facing a constant growing of data that has to be stored and manipulated efficiently, which has proved to be a tough challenge for the rigid traditional relational SQL databases. This has increased the popularity of much less schema restricted document type NoSQL databases which are much better suited to handle large amounts of unstructured data. However, migrating data from relational to document NoSQL databases can be a challenging task, because it requires knowledge of relational schema to select an optimal migration strategy. Proposed solution to this problem - an application that utilizes schema denormalization strategy to perform automatic data migration from „MySQL“ to „MongoDB“. The automatic migration of data is performed by analyzing existing relationships between relational tables and using embedding method to store related entries as a single „MongoDB“ collection document. In this document the migration process of test „MySQL“ database to „MongoDB“ has been described in detail to provide a better understanding of how the algorithm behind proposed application works.