title: ÐÐ»Ð³Ð¾ÑÐ¸ÑÐ¼ Ð´Ð¸Ð½Ð°Ð¼Ð¸ÑÐµÑÐºÐ¾Ð¹ Ð±Ð°Ð»Ð°Ð½ÑÐ¸ÑÐ¾Ð²ÐºÐ¸ SQL Ð¸ NoSQL ÑÑ ÐµÐ¼Ñ Ñ ÑÐ°Ð½Ð¸Ð»Ð¸ÑÐ° Ð´Ð°Ð½Ð½ÑÑ Ð¿ÑÐ¸Ð»Ð¾Ð¶ÐµÐ½Ð¸Ñ
title: Ð²ÑÐ¿ÑÑÐºÐ½Ð°Ñ ÐºÐ²Ð°Ð»Ð¸ÑÐ¸ÐºÐ°ÑÐ¸Ð¾Ð½Ð½Ð°Ñ ÑÐ°Ð±Ð¾ÑÐ° Ð¼Ð°Ð³Ð¸ÑÑÑÐ°
titleType: Subtitle
title: Algorithm of dynamic balancing of SQL and NoSQL application data storage scheme
Creators: name: ÐÑÑÐ»Ð¾Ð², Ð¡ÐµÑÐ³ÐµÐ¹
Publisher: name: Ð¡Ð°Ð½ÐºÑ-ÐÐµÑÐµÑÐ±ÑÑÐ³ÑÐºÐ¸Ð¹ Ð¿Ð¾Ð»Ð¸ÑÐµÑÐ½Ð¸ÑÐµÑÐºÐ¸Ð¹ ÑÐ½Ð¸Ð²ÐµÑÑÐ¸ÑÐµÑ ÐÐµÑÑÐ° ÐÐµÐ»Ð¸ÐºÐ¾Ð³Ð¾
Year: 2023
Subjects: Ð¼ÑÐ»ÑÑÐ¸Ð¼Ð¾Ð´ÐµÐ»Ñ
Ð¾Ð±ÑÐµÐºÑÐ½Ð¾-ÑÐµÐ»ÑÑÐ¸Ð¾Ð½Ð½Ð¾Ðµ Ð¿ÑÐµÐ¾Ð±ÑÐ°Ð·Ð¾Ð²Ð°Ð½Ð¸Ðµ
multi-model
object-relational transformation
sql
nosql

description: Ð ÐºÐ¾Ð½ÑÐµÐºÑÑÐµ ÑÐ¾Ð²ÑÐµÐ¼ÐµÐ½Ð½ÑÑ ÑÐµÑÐ½Ð¾Ð»Ð¾Ð³Ð¸Ð¹ Ð±Ð°Ð· Ð´Ð°Ð½Ð½ÑÑ Ð½Ð°Ð±Ð»ÑÐ´Ð°ÐµÑÑÑ ÑÐ²ÐµÐ»Ð¸ÑÐµÐ½Ð¸Ðµ Ð¿ÑÐ¸Ð¼ÐµÐ½ÐµÐ½Ð¸Ñ Ð¼ÑÐ»ÑÑÐ¸-Ð¼Ð¾Ð´ÐµÐ»ÑÐ½ÑÑ Ð±Ð°Ð·, Ð¿Ð¾ÑÐºÐ¾Ð»ÑÐºÑ ÑÐ°Ð·Ð»Ð¸ÑÐ½ÑÐµ Ð¼Ð¾Ð´ÐµÐ»Ð¸ Ð¾Ð¿ÑÐ¸Ð¼Ð°Ð»ÑÐ½Ð¾ Ð¿Ð¾Ð´ÑÐ¾Ð´ÑÑ Ð´Ð»Ñ ÑÐ°Ð·Ð½Ð¾Ð¾Ð±ÑÐ°Ð·Ð½ÑÑ Ð¾Ð±Ð»Ð°ÑÑÐµÐ¹ Ð¿ÑÐ¸Ð¼ÐµÐ½ÐµÐ½Ð¸Ñ Ð¸ ÑÑÐµÐ½Ð°ÑÐ¸ÐµÐ² Ð¸ÑÐ¿Ð¾Ð»ÑÐ·Ð¾Ð²Ð°Ð½Ð¸Ñ. NoSQL ÑÑÑÑÐºÑÑÑÑ Ð·Ð°Ð½Ð¸Ð¼Ð°ÑÑ Ð·Ð½Ð°ÑÐ¸Ð¼Ð¾Ðµ Ð¼ÐµÑÑÐ¾ Ð² Ð¾Ð±Ð»Ð°ÑÑÐ¸ Ð¼ÑÐ»ÑÑÐ¸-Ð¼Ð¾Ð´ÐµÐ»ÑÐ½ÑÑ, Ð±Ð¾Ð»ÑÑÐ¸Ñ Ð¸ Ð¿ÐµÑÐµÐ¼ÐµÐ½Ð½ÑÑ Ð½Ð°Ð±Ð¾ÑÐ¾Ð² Ð´Ð°Ð½Ð½ÑÑ. ÐÐµÑÐ¼Ð¾ÑÑÑ Ð½Ð° ÑÑÐ½ÐºÑÐ¸Ð¾Ð½Ð°Ð»ÑÐ½Ð¾ÑÑÑ ÑÑÐ¸Ñ Ð¿Ð¾Ð´ÑÐ¾Ð´Ð¾Ð², Ð²Ð¾Ð·Ð½Ð¸ÐºÐ°ÑÑ ÑÐ»Ð¾Ð¶Ð½Ð¾ÑÑÐ¸, ÑÐ²ÑÐ·Ð°Ð½Ð½ÑÐµ Ñ Ð¿ÑÐ¾Ð¸Ð·Ð²Ð¾Ð´Ð¸ÑÐµÐ»ÑÐ½Ð¾ÑÑÑÑ Ð²ÑÐ¿Ð¾Ð»Ð½ÐµÐ½Ð¸Ñ Ð¾Ð¿ÐµÑÐ°ÑÐ¸Ð¹, ÑÐµÐ°Ð»Ð¸Ð·Ð°ÑÐ¸ÐµÐ¹ Ð²Ð·Ð°Ð¸Ð¼Ð¾ÑÐ²ÑÐ·ÐµÐ¹ Ð¸, ÐºÐ°Ðº ÑÐ»ÐµÐ´ÑÑÐ²Ð¸Ðµ, ÑÑÑÐµÐºÑÐ¸Ð²Ð½Ð¾ÑÑÐ¸ Ð¾Ð±ÑÐµÐºÑÐ½Ð¾-ÑÐµÐ»ÑÑÐ¸Ð¾Ð½Ð½Ð¾Ð³Ð¾ Ð¿ÑÐµÐ¾Ð±ÑÐ°Ð·Ð¾Ð²Ð°Ð½Ð¸Ñ Ð¼ÐµÐ¶Ð´Ñ Ð¼Ð¾Ð´ÐµÐ»ÑÐ¼Ð¸. Ð Ð°Ð±Ð¾ÑÐ° Ð¿Ð¾ÑÐ²ÑÑÐµÐ½Ð° ÑÐ°Ð·ÑÐ°Ð±Ð¾ÑÐºÐµ Ð¸ Ð¸Ð·ÑÑÐµÐ½Ð¸Ñ Ð¼ÐµÑÐ¾Ð´Ð° Ð¸ Ð°Ð»Ð³Ð¾ÑÐ¸ÑÐ¼Ð° Ð´Ð¸Ð½Ð°Ð¼Ð¸ÑÐµÑÐºÐ¾Ð¹ Ð±Ð°Ð»Ð°Ð½ÑÐ¸ÑÐ¾Ð²ÐºÐ¸ SQL Ð¸ NoSQL ÑÑÐµÐ¼ Ð² Ð¼ÑÐ»ÑÑÐ¸-Ð¼Ð¾Ð´ÐµÐ»ÑÐ½ÑÑ Ð±Ð°Ð·Ð°Ñ Ð´Ð°Ð½Ð½ÑÑ. Ð ÑÐ¾Ð´Ðµ Ð¸ÑÑÐ»ÐµÐ´Ð¾Ð²Ð°Ð½Ð¸Ñ Ð¿ÑÐµÐ´Ð»Ð¾Ð¶ÐµÐ½ ÐºÑÐ¸ÑÐµÑÐ¸Ð¹ Ð¾Ð¿ÑÐ¸Ð¼Ð°Ð»ÑÐ½Ð¾ÑÑÐ¸ Ð¾ÑÐ½Ð¾Ð²Ð°Ð½Ð½ÑÐ¹ Ð½Ð° Ð¾ÑÐµÐ½ÐºÐµ Ð¾Ð±ÑÐµÐ¼Ð° Ð¸ Ð²ÑÐµÐ¼ÐµÐ½Ð¸ Ð²ÑÐ¿Ð¾Ð»Ð½ÐµÐ½Ð¸Ñ Ð·Ð°Ð¿ÑÐ¾ÑÐ° Ð² Ð¿ÑÐ¾ÑÐµÑÑÐµ ÑÐ¾Ð²Ð¼ÐµÑÐµÐ½Ð¸Ñ ÑÐµÐ»ÑÑÐ¸Ð¾Ð½Ð½ÑÑ Ð¸ Ð½ÐµÑÐµÐ»ÑÑÐ¸Ð¾Ð½Ð½ÑÑ ÑÑÑÑÐºÑÑÑ. ÐÐ¾Ð»ÑÑÐµÐ½Ð½ÑÐµ ÑÐµÐ·ÑÐ»ÑÑÐ°ÑÑ Ð¼Ð¾Ð³ÑÑ Ð±ÑÑÑ Ð¿ÑÐ¸Ð¼ÐµÐ½ÐµÐ½Ñ Ð´Ð»Ñ ÑÑÑÐµÐºÑÐ¸Ð²Ð½Ð¾Ð³Ð¾ Ð¿ÑÐ¾ÐµÐºÑÐ¸ÑÐ¾Ð²Ð°Ð½Ð¸Ñ Ð¸ ÑÐµÑÐ°ÐºÑÐ¾ÑÐ¸Ð½Ð³Ð° Ð¼ÑÐ»ÑÑÐ¸-Ð¼Ð¾Ð´ÐµÐ»ÑÐ½ÑÑ ÑÑÐµÐ¼ Ð¸ Ð°Ð½Ð°Ð»Ð¸Ð·Ð° Ð±Ð°Ð· Ð´Ð°Ð½Ð½ÑÑ Ñ ÑÐµÐ»ÑÑ Ð¸Ñ Ð¾Ð¿ÑÐ¸Ð¼Ð¸Ð·Ð°ÑÐ¸Ð¸ Ð¸ ÑÐ»ÑÑÑÐµÐ½Ð¸Ñ Ð¿ÑÐ¾Ð¸Ð·Ð²Ð¾Ð´Ð¸ÑÐµÐ»ÑÐ½Ð¾ÑÑÐ¸.
description: In the context of modern database technologies, there has been an increase in the use of multi-model databases because different models are optimal for a variety of applications and use cases. NoSQL structures occupy a significant place in the area of multi-model, large and variable datasets. Despite the functionality of these approaches, there are challenges related to the performance of operations, the implementation of relationships and, consequently, the efficiency of object-relational transformation between models. This paper is devoted to developing and studying the method and algorithm for dynamic balancing of SQL and NoSQL schemes in multi-model databases. In the study, an optimality criterion based on the evaluation of the volume and time of query execution in the process of combining relational and non-relational structures is proposed. The obtained results can be applied to effectively design and refactor multi-model schemas and analyze databases to optimize and improve their performance.