title: ÐÐ¾ÑÑÑÐ¾ÐµÐ½Ð¸Ðµ Ð¾Ð¿ÑÐ¸Ð¼Ð°Ð»ÑÐ½Ð¾Ð¹ ÑÑÑÑÐºÑÑÑÑ Ð´Ð¾ÐºÑÐ¼ÐµÐ½ÑÐ½Ð¾Ð¹ Ð±Ð°Ð·Ñ Ð´Ð°Ð½Ð½ÑÑ Ð¿Ð¾ Ð¼ÐµÑÐ°Ð´Ð°Ð½Ð½ÑÐ¼ ÑÐµÐ»ÑÑÐ¸Ð¾Ð½Ð½Ð¾Ð¹ Ð±Ð°Ð·Ñ Ð´Ð°Ð½Ð½ÑÑ
title: Ð²ÑÐ¿ÑÑÐºÐ½Ð°Ñ ÐºÐ²Ð°Ð»Ð¸ÑÐ¸ÐºÐ°ÑÐ¸Ð¾Ð½Ð½Ð°Ñ ÑÐ°Ð±Ð¾ÑÐ° Ð±Ð°ÐºÐ°Ð»Ð°Ð²ÑÐ°
titleType: Subtitle
title: Construction of the optimal structure of a document database based on the metadata of a relational database
Creators: name: ÐÐ°Ð¹ÑÐµÐ²Ð°, ÐÐºÐ°ÑÐµÑÐ¸Ð½Ð°
Publisher: name: Ð¡Ð°Ð½ÐºÑ-ÐÐµÑÐµÑÐ±ÑÑÐ³ÑÐºÐ¸Ð¹ Ð¿Ð¾Ð»Ð¸ÑÐµÑÐ½Ð¸ÑÐµÑÐºÐ¸Ð¹ ÑÐ½Ð¸Ð²ÐµÑÑÐ¸ÑÐµÑ ÐÐµÑÑÐ° ÐÐµÐ»Ð¸ÐºÐ¾Ð³Ð¾
Year: 2022
Subjects: ÑÐµÐ»ÑÑÐ¸Ð¾Ð½Ð½ÑÐµ Ð±Ð°Ð·Ñ Ð´Ð°Ð½Ð½ÑÑ
Ð´Ð¾ÐºÑÐ¼ÐµÐ½ÑÐ½ÑÐµ Ð±Ð°Ð·Ñ Ð´Ð°Ð½Ð½ÑÑ
ÑÑÐ°Ð½ÑÐ»ÑÑÐ¸Ñ Ð´Ð°Ð½Ð½ÑÑ
relational database
document database
data translation

description: Ð¢ÐµÐ¼Ð° Ð²ÑÐ¿ÑÑÐºÐ½Ð¾Ð¹ ÐºÐ²Ð°Ð»Ð¸ÑÐ¸ÐºÐ°ÑÐ¸Ð¾Ð½Ð½Ð¾Ð¹ ÑÐ°Ð±Ð¾ÑÑ: Â«ÐÐ¾ÑÑÑÐ¾ÐµÐ½Ð¸Ðµ Ð¾Ð¿ÑÐ¸Ð¼Ð°Ð»ÑÐ½Ð¾Ð¹ ÑÑÑÑÐºÑÑÑÑ Ð´Ð¾ÐºÑÐ¼ÐµÐ½ÑÐ½Ð¾Ð¹ Ð±Ð°Ð·Ñ Ð´Ð°Ð½Ð½ÑÑ Ð¿Ð¾ Ð¼ÐµÑÐ°Ð´Ð°Ð½Ð½ÑÐ¼ ÑÐµÐ»ÑÑÐ¸Ð¾Ð½Ð½Ð¾Ð¹ Ð±Ð°Ð·Ñ Ð´Ð°Ð½Ð½ÑÑÂ». ÐÐ°Ð½Ð½Ð°Ñ ÑÐ°Ð±Ð¾ÑÐ° Ð¿Ð¾ÑÐ²ÑÑÐµÐ½Ð° ÑÐ°Ð·ÑÐ°Ð±Ð¾ÑÐºÐµ Ð¿ÑÐ¾Ð³ÑÐ°Ð¼Ð¼Ð½Ð¾Ð¹ ÑÐµÐ°Ð»Ð¸Ð·Ð°ÑÐ¸Ð¸ Ð¼ÐµÑÐ¾Ð´Ð° Ð¿Ð¾ÑÑÑÐ¾ÐµÐ½Ð¸Ñ ÑÑÑÑÐºÑÑÑÑ Ð´Ð¾ÐºÑÐ¼ÐµÐ½ÑÐ½Ð¾Ð¹ Ð±Ð°Ð·Ñ Ð´Ð°Ð½Ð½ÑÑ, Ð¾ÑÐ½Ð¾Ð²Ð°Ð½Ð½Ð¾Ð³Ð¾ Ð½Ð° ÑÐµÐ¾ÑÐ¸Ð¸ Ð¼Ð½Ð¾Ð¶ÐµÑÑÐ², Ð° ÑÐ°ÐºÐ¶Ðµ Ð¾ÑÐµÐ½ÐºÐµ ÑÑÑÐµÐºÑÐ¸Ð²Ð½Ð¾ÑÑÐ¸ ÑÐ°ÑÐ¿Ð¾Ð»Ð¾Ð¶ÐµÐ½Ð¸Ñ Ð´Ð°Ð½Ð½ÑÑ Ð² Ð¿Ð¾Ð»ÑÑÐµÐ½Ð½Ð¾Ð¹ ÑÑÑÑÐºÑÑÑÐµ Ð´Ð¾ÐºÑÐ¼ÐµÐ½ÑÐ½Ð¾Ð¹ Ð±Ð°Ð·Ñ Ð´Ð°Ð½Ð½ÑÑ. Ð ÑÐ°Ð±Ð¾ÑÐµ Ð¿ÑÐµÐ´Ð»Ð°Ð³Ð°ÐµÑÑÑ Ð¿ÑÐ¾Ð³ÑÐ°Ð¼Ð¼Ð½Ð¾Ðµ ÑÐµÑÐµÐ½Ð¸Ðµ, ÑÐ¾ÑÑÐ¾ÑÑÐµÐµ Ð¸Ð· Ð¼Ð¾Ð´ÑÐ»Ñ Ð¿Ð¾Ð´ÐºÐ»ÑÑÐµÐ½Ð¸Ñ Ðº Ð±Ð°Ð·Ðµ Ð´Ð°Ð½Ð½ÑÑ Ð¸ ÑÑÐ¸ÑÑÐ²Ð°Ð½Ð¸Ñ ÐµÑ Ð¼ÐµÑÐ°Ð´Ð°Ð½Ð½ÑÑ, Ð¼Ð¾Ð´ÑÐ»Ñ Ð¿Ð°ÑÑÐ¸Ð½Ð³Ð° SQL-Ð·Ð°Ð¿ÑÐ¾ÑÐ¾Ð² Ð¸ Ð¼Ð¾Ð´ÑÐ»Ñ ÑÐµÐ°Ð»Ð¸Ð·Ð°ÑÐ¸Ð¸ Ð²ÑÐ±ÑÐ°Ð½Ð½Ð¾Ð³Ð¾ Ð¼ÐµÑÐ¾Ð´Ð° Ð¿Ð¾ÑÑÑÐ¾ÐµÐ½Ð¸Ñ ÑÑÑÑÐºÑÑÑÑ Ð´Ð¾ÐºÑÐ¼ÐµÐ½ÑÐ½Ð¾Ð¹ Ð±Ð°Ð·Ñ Ð´Ð°Ð½Ð½ÑÑ. Ð¢ÑÐµÐ±Ð¾Ð²Ð°Ð½Ð¸Ñ Ðº Ð¿ÑÐ¾Ð³ÑÐ°Ð¼Ð¼Ð½Ð¾Ð¼Ñ ÑÐµÑÐµÐ½Ð¸Ñ Ð¸ Ð¾Ð¿Ð¸ÑÐ°Ð½Ð¸Ðµ ÐµÐ³Ð¾ Ð°ÑÑÐ¸ÑÐµÐºÑÑÑÑ Ð¿ÑÐµÐ´ÑÑÐ°Ð²Ð»ÐµÐ½Ñ Ð² Ð³Ð»Ð°Ð²Ðµ 2. ÐÐ»Ð°Ð²Ð° 3 Ð¾Ð¿Ð¸ÑÑÐ²Ð°ÐµÑ Ð¿ÑÐ¾ÑÐµÑÑ Ð¿ÐµÑÐµÐ½Ð¾ÑÐ° Ð´Ð°Ð½Ð½ÑÑ Ð¸Ð· ÑÐµÐ»ÑÑÐ¸Ð¾Ð½Ð½Ð¾Ð¹ Ð±Ð°Ð·Ñ Ð´Ð°Ð½Ð½ÑÑ Ð² Ð´Ð¾ÐºÑÐ¼ÐµÐ½ÑÐ½ÑÑ Ð±Ð°Ð·Ñ Ð´Ð°Ð½Ð½ÑÑ. Ð Ð³Ð»Ð°Ð²Ðµ 4 Ð¿ÑÐµÐ´ÑÑÐ°Ð²Ð»ÐµÐ½ ÑÑÐ°Ð²Ð½Ð¸ÑÐµÐ»ÑÐ½ÑÐ¹ Ð°Ð½Ð°Ð»Ð¸Ð· ÑÑÑÐµÐºÑÐ¸Ð²Ð½Ð¾ÑÑÐ¸ Ð´Ð¾ÑÑÑÐ¿Ð° Ðº Ð´Ð°Ð½Ð½ÑÐ¼ Ð² ÑÐµÐ»ÑÑÐ¸Ð¾Ð½Ð½Ð¾Ð¹ Ð±Ð°Ð·Ðµ Ð´Ð°Ð½Ð½ÑÑ Ð¸ Ð² ÑÐ¾Ð·Ð´Ð°Ð½Ð½Ð¾Ð¹ Ð¿Ð¾ Ð¿Ð¾Ð»ÑÑÐµÐ½Ð½Ð¾Ð¹ Ð¸Ð· Ð¿ÑÐ¾Ð³ÑÐ°Ð¼Ð¼Ð½Ð¾Ð³Ð¾ ÑÐµÑÐµÐ½Ð¸Ñ ÑÑÑÑÐºÑÑÑÐµ Ð´Ð¾ÐºÑÐ¼ÐµÐ½ÑÐ½Ð¾Ð¹ Ð±Ð°Ð·Ðµ Ð´Ð°Ð½Ð½ÑÑ. Ð ÑÐµÐ·ÑÐ»ÑÑÐ°ÑÐµ Ð¸ÑÑÐ»ÐµÐ´Ð¾Ð²Ð°Ð½Ð¸Ñ Ð±ÑÐ» ÑÐ°Ð·ÑÐ°Ð±Ð¾ÑÐ°Ð½ Ð¿ÑÐ¾Ð³ÑÐ°Ð¼Ð¼Ð½ÑÐ¹ Ð¼Ð¾Ð´ÑÐ»Ñ, Ð¿Ð¾Ð·Ð²Ð¾Ð»ÑÑÑÐ¸Ð¹ Ð¿Ð¾Ð»ÑÑÐ¸ÑÑ Ð¿Ð¾ Ð¼ÐµÑÐ°Ð´Ð°Ð½Ð½ÑÐ¼ ÑÐ°Ð±Ð»Ð¸Ñ Ð¸ Ð¸Ð½ÑÐ¾ÑÐ¼Ð°ÑÐ¸Ð¸ Ð¾ Ð·Ð°Ð¿ÑÐ¾ÑÐ°Ñ Ðº ÑÐµÐ»ÑÑÐ¸Ð¾Ð½Ð½Ð¾Ð¹ Ð±Ð°Ð·Ðµ Ð´Ð°Ð½Ð½ÑÑ ÑÐ°ÑÐ¿ÑÐµÐ´ÐµÐ»ÐµÐ½Ð¸Ðµ Ð¿Ð¾Ð»ÐµÐ¹ Ð¿Ð¾ ÐºÐ¾Ð»Ð»ÐµÐºÑÐ¸ÑÐ¼ Ð´Ð¾ÐºÑÐ¼ÐµÐ½ÑÐ½Ð¾Ð¹ Ð±Ð°Ð·Ñ Ð´Ð°Ð½Ð½ÑÑ. ÐÑÑÐ»ÐµÐ´Ð¾Ð²Ð°Ð½Ð¸Ðµ ÑÑÑÐµÐºÑÐ¸Ð²Ð½Ð¾ÑÑÐ¸ Ð¿Ð¾ÐºÐ°Ð·Ð°Ð»Ð¾, ÑÑÐ¾ Ð² Ð¿Ð¾Ð»ÑÑÐµÐ½Ð½Ð¾Ð¹ ÑÑÑÑÐºÑÑÑÐµ Ð´Ð¾ÐºÑÐ¼ÐµÐ½ÑÐ½Ð°Ñ Ð±Ð°Ð·Ð° Ð´Ð°Ð½Ð½ÑÑ Ð½Ðµ ÑÑÑÑÐ¿Ð°ÐµÑ Ð² Ð¿ÑÐ¾Ð¸Ð·Ð²Ð¾Ð´Ð¸ÑÐµÐ»ÑÐ½Ð¾ÑÑÐ¸ ÑÐµÐ»ÑÑÐ¸Ð¾Ð½Ð½Ð¾Ð¹ Ð±Ð°Ð·Ðµ Ð´Ð°Ð½Ð½ÑÑ.
description: The subject of the graduate qualification work: "Construction of the optimal structure of a document database based on the metadata of a relational database". The given work is devoted to the development of a software implementation of a method for constructing a document database structure based on set theory, as well as an assessment of the data location efficiency in the resulting document database structure. The paper proposes a software solution consisting of a module for connecting to a database and reading its metadata, a module for parsing SQL queries, and a module for implementing the selected method for constructing the structure of a document database. The requirements for the software solution and a description of its architecture are presented in Chapter 2. Chapter 3 describes the process of migrating data from a relational database to a document database. Chapter 4 presents a comparative analysis of the efficiency of data access in a relational database and in a document database created from a structure obtained from a software solution. As a result of the study, a software module, that allows obtaining the distribution of fields across collections of the document database from the metadata of tables and information about queries to a relational database, was developed. The efficiency study showed that in the resulting structure, the document database is not inferior in performance to the relational database.