title: Ð¡ÑÐ°Ð²Ð½Ð¸ÑÐµÐ»ÑÐ½ÑÐ¹ Ð°Ð½Ð°Ð»Ð¸Ð· ÑÐµÐ»ÑÑÐ¸Ð¾Ð½Ð½Ð¾Ð³Ð¾ Ð¸ Ð´Ð¾ÐºÑÐ¼ÐµÐ½ÑÐ¾-Ð¾ÑÐ¸ÐµÐ½ÑÐ¸ÑÐ¾Ð²Ð°Ð½Ð½Ð¾Ð³Ð¾ Ð¿Ð¾Ð´Ñ Ð¾Ð´Ð° Ðº Ð¾ÑÐ³Ð°Ð½Ð¸Ð·Ð°ÑÐ¸Ð¸ Ð±Ð°Ð· Ð´Ð°Ð½Ð½ÑÑ Ð² Ð¡Ð£ÐÐ MySQL
title: Ð²ÑÐ¿ÑÑÐºÐ½Ð°Ñ ÐºÐ²Ð°Ð»Ð¸ÑÐ¸ÐºÐ°ÑÐ¸Ð¾Ð½Ð½Ð°Ñ ÑÐ°Ð±Ð¾ÑÐ° Ð±Ð°ÐºÐ°Ð»Ð°Ð²ÑÐ°
titleType: Subtitle
title: Comparative analysis of relational and document-oriented approach to the organization of databases in MySQL DBMS
Creators: name: ÐÑÐ¾Ð¿ÑÑÐºÐ¾Ð²Ð°, ÐÐ½Ð°ÑÑÐ°ÑÐ¸Ñ
Publisher: name: Ð¡Ð°Ð½ÐºÑ-ÐÐµÑÐµÑÐ±ÑÑÐ³ÑÐºÐ¸Ð¹ Ð¿Ð¾Ð»Ð¸ÑÐµÑÐ½Ð¸ÑÐµÑÐºÐ¸Ð¹ ÑÐ½Ð¸Ð²ÐµÑÑÐ¸ÑÐµÑ ÐÐµÑÑÐ° ÐÐµÐ»Ð¸ÐºÐ¾Ð³Ð¾
Year: 2022
Subjects: Ð±Ð°Ð·Ð° Ð´Ð°Ð½Ð½ÑÑ
Ñ ÑÐ°Ð½Ð¸Ð»Ð¸ÑÐµ Ð´Ð¾ÐºÑÐ¼ÐµÐ½ÑÐ¾Ð² MySQL
JSON
ÑÐµÐ»ÑÑÐ¸Ð¾Ð½Ð½ÑÐµ Ð±Ð°Ð·Ñ Ð´Ð°Ð½Ð½ÑÑ
Ð½ÐµÑÐµÐ»ÑÑÐ¸Ð¾Ð½Ð½ÑÐµ Ð±Ð°Ð·Ñ Ð´Ð°Ð½Ð½ÑÑ
database
MySQL document store
comparative analysis
relational databases
non-relational databases

description: Ð¢ÐµÐ¼Ð° Ð²ÑÐ¿ÑÑÐºÐ½Ð¾Ð¹ ÐºÐ²Ð°Ð»Ð¸ÑÐ¸ÐºÐ°ÑÐ¸Ð¾Ð½Ð½Ð¾Ð¹ ÑÐ°Ð±Ð¾ÑÑ: Â«Ð¡ÑÐ°Ð²Ð½Ð¸ÑÐµÐ»ÑÐ½ÑÐ¹ Ð°Ð½Ð°Ð»Ð¸Ð· ÑÐµÐ»ÑÑÐ¸Ð¾Ð½Ð½Ð¾Ð³Ð¾ Ð¸ Ð´Ð¾ÐºÑÐ¼ÐµÐ½ÑÐ¾-Ð¾ÑÐ¸ÐµÐ½ÑÐ¸ÑÐ¾Ð²Ð°Ð½Ð½Ð¾Ð³Ð¾ Ð¿Ð¾Ð´ÑÐ¾Ð´Ð° Ðº Ð¾ÑÐ³Ð°Ð½Ð¸Ð·Ð°ÑÐ¸Ð¸ Ð±Ð°Ð· Ð´Ð°Ð½Ð½ÑÑ Ð² Ð¡Ð£ÐÐ MySQLÂ».ÐÑÐµÐ´Ð¼ÐµÑÐ¾Ð¼ Ð¸ÑÑÐ»ÐµÐ´Ð¾Ð²Ð°Ð½Ð¸Ñ ÑÐ²Ð»ÑÑÑÑÑ ÑÐµÐ»ÑÑÐ¸Ð¾Ð½Ð½ÑÐµ Ð¸ Ð´Ð¾ÐºÑÐ¼ÐµÐ½ÑÐ¾-Ð¾ÑÐ¸ÐµÐ½ÑÐ¸ÑÐ¾Ð²Ð°Ð½Ð½ÑÐµ Ð±Ð°Ð·Ñ Ð´Ð°Ð½Ð½ÑÑ Ð¿Ð¾Ð´ ÑÐ¿ÑÐ°Ð²Ð»ÐµÐ½Ð¸ÐµÐ¼ Ð¡Ð£ÐÐ MySQL.Ð¦ÐµÐ»Ñ Ð´Ð°Ð½Ð½Ð¾Ð¹ ÑÐ°Ð±Ð¾ÑÑ: Ð¿ÑÐ¾Ð²ÐµÑÑÐ¸ ÑÑÐ°Ð²Ð½Ð¸ÑÐµÐ»ÑÐ½ÑÐ¹ Ð°Ð½Ð°Ð»Ð¸Ð· ÑÑÑÐµÐºÑÐ¸Ð²Ð½Ð¾ÑÑÐ¸ ÑÑÐ°Ð½ÐµÐ½Ð¸Ñ Ð¸ Ð¿Ð¾Ð¸ÑÐºÐ° Ð´Ð°Ð½Ð½ÑÑ Ð² ÑÐµÐ»ÑÑÐ¸Ð¾Ð½Ð½Ð¾Ð¹ Ð¸ Ð´Ð¾ÐºÑÐ¼ÐµÐ½ÑÐ¾-Ð¾ÑÐ¸ÐµÐ½ÑÐ¸ÑÐ¾Ð²Ð°Ð½Ð½Ð¾Ð¹ Ð±Ð°Ð·Ð°Ñ Ð´Ð°Ð½Ð½ÑÑ. ÐÐ°Ð´Ð°ÑÐ¸, ÐºÐ¾ÑÐ¾ÑÑÐµ Ð±ÑÐ»Ð¸ ÑÐµÑÐµÐ½Ñ Ð² ÑÐ¾Ð´Ðµ ÑÐ°Ð±Ð¾ÑÑ:1. Ð¡ÑÐ°Ð²Ð½Ð¸ÑÑ Ð¾ÑÐ¾Ð±ÐµÐ½Ð½Ð¾ÑÑÐ¸ ÑÑÐ°Ð½ÐµÐ½Ð¸Ñ Ð´Ð°Ð½Ð½ÑÑ Ð² ÑÐµÐ»ÑÑÐ¸Ð¾Ð½Ð½ÑÑ Ð¸ Ð½ÐµÑÐµÐ»ÑÑÐ¸Ð¾Ð½Ð½ÑÑ ÑÑÑÑÐºÑÑÑÐ°Ñ Ð´Ð°Ð½Ð½ÑÑ;2. ÐÐ·ÑÑÐ¸ÑÑ Ð´Ð¾ÐºÑÐ¼ÐµÐ½ÑÐ¾-Ð¾ÑÐ¸ÐµÐ½ÑÐ¸ÑÐ¾Ð²Ð°Ð½Ð½ÑÐµ Ð±Ð°Ð·Ñ Ð´Ð°Ð½Ð½ÑÑ Ñ ÑÑÐ°Ð½ÐµÐ½Ð¸ÐµÐ¼ Ð² JSON;3. ÐÑÐµÐ½Ð¸ÑÑ ÑÑÑÐµÐºÑÐ¸Ð²Ð½Ð¾ÑÑÑ ÑÑÐ°Ð½ÐµÐ½Ð¸Ñ Ð¸ Ð¿Ð¾Ð¸ÑÐºÐ° Ð² ÑÑÑÑÐºÑÑÑÐ°Ñ Ð´Ð°Ð½Ð½ÑÑ, Ð²Ð»Ð¸ÑÐ½Ð¸Ðµ Ð¸Ð½Ð´ÐµÐºÑÐ¾Ð² Ð½Ð° Ð²ÑÐµÐ¼Ñ Ð²ÑÐ¿Ð¾Ð»Ð½ÐµÐ½Ð¸Ñ Ð·Ð°Ð¿ÑÐ¾ÑÐ¾Ð²;4. ÐÑÑÐ²Ð¸ÑÑ Ð¾ÑÐ¾Ð±ÐµÐ½Ð½Ð¾ÑÑÐ¸ Ð¸ÑÐ¿Ð¾Ð»ÑÐ·Ð¾Ð²Ð°Ð½Ð¸Ñ MySQL ÐºÐ°Ðº ÑÑÐ°Ð½Ð¸Ð»Ð¸ÑÐ° Ð´Ð¾ÐºÑÐ¼ÐµÐ½ÑÐ¾Ð²;5. ÐÑÐ¾Ð²ÐµÑÑÐ¸ ÑÐºÑÐ¿ÐµÑÐ¸Ð¼ÐµÐ½Ñ ÑÐ¾ ÑÑÐ°Ð²Ð½Ð¸ÑÐµÐ»ÑÐ½ÑÐ¼ Ð°Ð½Ð°Ð»Ð¸Ð·Ð¾Ð¼ ÑÐºÐ¾ÑÐ¾ÑÑÐ¸ Ð¾Ð±ÑÐ°Ð±Ð¾ÑÐºÐ¸ Ð·Ð°Ð¿ÑÐ¾ÑÐ¾Ð² Ð² ÑÐµÐ»ÑÑÐ¸Ð¾Ð½Ð½ÑÑ ÑÐ°Ð±Ð»Ð¸ÑÐ°Ñ Ð¸ JSON Ð´Ð¾ÐºÑÐ¼ÐµÐ½ÑÐ°Ñ. ÐÑÐ¿Ð¾Ð»ÑÐ·ÑÐµÐ¼Ð°Ñ Ð² ÑÐ°Ð±Ð¾ÑÐµ Ð±Ð°Ð·Ð° Ð´Ð°Ð½Ð½ÑÑ ÑÐ¾Ð´ÐµÑÐ¶Ð¸Ñ Ð´Ð°Ð½Ð½ÑÐµ Ð² ÑÐµÐ»ÑÑÐ¸Ð¾Ð½Ð½Ð¾Ð¼ Ð¸ Ð´Ð¾ÐºÑÐ¼ÐµÐ½ÑÐ¾-Ð¾ÑÐ¸ÐµÐ½ÑÐ¸ÑÐ¾Ð²Ð°Ð½Ð½Ð¾Ð¼ Ð²Ð¸Ð´Ðµ.6. ÐÑÐµÐ½Ð¸ÑÑ ÑÐºÐ¾ÑÐ¾ÑÑÑ Ð²ÑÐ¿Ð¾Ð»Ð½ÐµÐ½Ð¸Ñ Ð·Ð°Ð¿ÑÐ¾ÑÐ¾Ð² Ð´Ð»Ñ Ð´Ð²ÑÑ ÑÑÑÑÐºÑÑÑ Ð´Ð°Ð½Ð½ÑÑ. Ð ÑÐµÐ·ÑÐ»ÑÑÐ°ÑÐµ Ð±ÑÐ»Ð¸ ÑÐ°Ð·ÑÐ°Ð±Ð¾ÑÐ°Ð½Ñ ÑÐµÐºÐ¾Ð¼ÐµÐ½Ð´Ð°ÑÐ¸Ð¸ Ð¸ Ð¾Ð¿ÑÐµÐ´ÐµÐ»ÐµÐ½Ð° Ð¾Ð±ÑÐ°Ñ ÑÑÐµÐ¼Ð° ÑÐ°Ð±Ð¾ÑÑ Ð¿Ð¾ Ð²ÑÐ±Ð¾ÑÑ ÑÐµÐ»ÑÑÐ¸Ð¾Ð½Ð½Ð¾Ð¹ Ð¸Ð»Ð¸ Ð´Ð¾ÐºÑÐ¼ÐµÐ½ÑÐ¾-Ð¾ÑÐ¸ÐµÐ½ÑÐ¸ÑÐ¾Ð²Ð°Ð½Ð½Ð¾Ð¹ ÑÑÑÑÐºÑÑÑ Ð´Ð»Ñ Ð¾Ð¿ÑÐµÐ´ÐµÐ»ÐµÐ½Ð½ÑÑ Ð·Ð°Ð´Ð°Ñ.
description: The topic of the final qualifying work: "Comparative analysis of the relational and document-oriented approach to the organization of databases in the MySQL database management system". The subject of the study is relational and document-oriented databases managed by the MySQL database management system. The purpose of this work is to conduct a comparative analysis of the efficiency of data storage and retrieval in relational and document-oriented databases. Tasks that were solved during the work:1. Compare the features of data storage in relational and non-relational data structures;2. Study document-oriented databases with storage in JSON;3. Evaluate the efficiency of storage and search in data structures, the impact of indexes on query execution time optimization;4. Identify the features of using MySQL as a document repository;5. Conduct an experiment with a comparative analysis of query processing speed in relational tables and JSON documents. The database used in the work contains data in a relational and document-oriented form.6. Evaluate the query execution speed for two data structures.As a result, recommendations were developed and a general scheme of work was defined for choosing relational or document-oriented structures for certain tasks.