Research on Data Migration Features from Relational to Document-Oriented Model Using Studio 3T GUI Client

Abstract

The article examines the features of data migration from the MySQL relational database to the MongoDB document-oriented database. The object of the study is the process of migrating a relational data model to a document-oriented one, taking into account the structural differences between SQL and NoSQL approaches. The subject of the study is the methods of representing relational relationships in MongoDB and the tools for their implementation. The purpose of the article is to analyze approaches to migrating tables and one-to-one and one-to-many relationships into the MongoDB document structure using the Studio 3T graphical client. The work uses the relational world schema as an example data source for migration into MongoDB document collections. Strategies of denormalization, reference preservation, and embedding related entities into documents, as well as the use of arrays of scalar values and arrays of nested objects, are analyzed. It is shown that the choice of data storage model in MongoDB depends on the nature of queries, the frequency of information updates, and system performance requirements. Practical data migration was performed using Studio 3T, and the capabilities of this tool for designing and testing document structure were evaluated. The obtained results confirm the feasibility of using document-oriented databases for systems requiring fast access to related data, and can be used in educational and applied tasks of NoSQL storage design.