title: ÐÑÑÐ»ÐµÐ´Ð¾Ð²Ð°Ð½Ð¸Ðµ Ð°Ð»Ð³Ð¾ÑÐ¸ÑÐ¼Ð° Ð¿ÐµÑÐµÑÐ°ÑÐ¿ÑÐµÐ´ÐµÐ»ÐµÐ½Ð¸Ñ Ð´Ð°Ð½Ð½ÑÑ ÑÐ°Ð±Ð»Ð¸Ñ Ð² ÑÐ°ÑÐ¿ÑÐµÐ´ÐµÐ»ÐµÐ½Ð½Ð¾Ð¹ Ð¡Ð£ÐÐ
title: Ð²ÑÐ¿ÑÑÐºÐ½Ð°Ñ ÐºÐ²Ð°Ð»Ð¸ÑÐ¸ÐºÐ°ÑÐ¸Ð¾Ð½Ð½Ð°Ñ ÑÐ°Ð±Ð¾ÑÐ° Ð±Ð°ÐºÐ°Ð»Ð°Ð²ÑÐ°
titleType: Subtitle
title: Research data tables redistribution algorithm in a distributed database
Creators: name: ÐÐ¾ÑÐ¾Ð²Ð°, ÐÐ°Ð»ÐµÑÐ¸Ñ
Publisher: name: Ð¡Ð°Ð½ÐºÑ-ÐÐµÑÐµÑÐ±ÑÑÐ³ÑÐºÐ¸Ð¹ Ð¿Ð¾Ð»Ð¸ÑÐµÑÐ½Ð¸ÑÐµÑÐºÐ¸Ð¹ ÑÐ½Ð¸Ð²ÐµÑÑÐ¸ÑÐµÑ ÐÐµÑÑÐ° ÐÐµÐ»Ð¸ÐºÐ¾Ð³Ð¾
Year: 2021
Subjects: ÑÐ°ÑÐ¿ÑÐµÐ´ÐµÐ»ÐµÐ½Ð½Ð°Ñ Ð¡Ð£ÐÐ
Ð±Ð°Ð·Ð° Ð´Ð°Ð½Ð½ÑÑ
Ð°Ð»Ð³Ð¾ÑÐ¸ÑÐ¼ ÑÐ°ÑÐ¿ÑÐµÐ´ÐµÐ»ÐµÐ½Ð¸Ñ Ð´Ð°Ð½Ð½ÑÑ
Ð°Ð»Ð³Ð¾ÑÐ¸ÑÐ¼ Ð¿Ð¾ÑÐ¾Ð³Ð¾Ð²Ð¾Ð¹ Ð¾ÑÐµÐ½ÐºÐ¸
distributed DBMS
database
data distribution algorithm
threshold evaluation algorithm

description: ÐÐ°Ð½Ð½Ð°Ñ ÑÐ°Ð±Ð¾ÑÐ° Ð¿Ð¾ÑÐ²ÑÑÐµÐ½Ð° Ð¸ÑÑÐ»ÐµÐ´Ð¾Ð²Ð°Ð½Ð¸Ñ Ð°Ð»Ð³Ð¾ÑÐ¸ÑÐ¼Ð¾Ð² Ð´Ð¸Ð½Ð°Ð¼Ð¸ÑÐµÑÐºÐ¾Ð³Ð¾ ÑÐ°ÑÐ¿ÑÐµÐ´ÐµÐ»ÐµÐ½Ð¸Ñ Ð´Ð°Ð½Ð½ÑÑ Ð² ÑÐ°ÑÐ¿ÑÐµÐ´ÐµÐ»ÐµÐ½Ð½ÑÑ Ð¡Ð£ÐÐ. Ð¡ÑÑÐµÑÑÐ²ÑÐµÑ Ð¼Ð½Ð¾Ð³Ð¾ Ð¿Ð¾Ð´ÑÐ¾Ð´Ð¾Ð² Ðº ÑÐµÑÐµÐ½Ð¸Ñ Ð²Ð¾Ð¿ÑÐ¾ÑÐ° Ð¾Ð± ÑÑÑÐµÐºÑÐ¸Ð²Ð½Ð¾Ð¼ Ð¸ Ð¼Ð°ÑÑÑÐ°Ð±Ð¸ÑÑÐµÐ¼Ð¾Ð¼ ÑÐ¿Ð¾ÑÐ¾Ð±Ðµ ÑÐ°ÑÐ¿ÑÐµÐ´ÐµÐ»ÐµÐ½Ð¸Ñ Ð´Ð°Ð½Ð½ÑÑ Ð´Ð»Ñ Ð¾Ð¿ÑÐ¸Ð¼Ð¸Ð·Ð°ÑÐ¸Ð¸ ÑÐ°Ð±Ð¾ÑÑ ÑÐ¸ÑÑÐµÐ¼ ÑÐ°ÑÐ¿ÑÐµÐ´ÐµÐ»ÐµÐ½Ð½ÑÑ Ð±Ð°Ð· Ð´Ð°Ð½Ð½ÑÑ. Ð Ð½Ð°ÑÑÐ¾ÑÑÐµÐµ Ð²ÑÐµÐ¼Ñ Ð¿ÑÐ¾Ð²Ð¾Ð´ÑÑÑÑ Ð¸ÑÑÐ»ÐµÐ´Ð¾Ð²Ð°Ð½Ð¸Ñ Ð¸ ÑÐ°Ð·ÑÐ°Ð±Ð¾ÑÐºÐ° Ð¿Ð¾Ð´ÑÐ¾Ð´Ð¾Ð² Ðº ÑÐµÑÐµÐ½Ð¸Ñ Ð·Ð°Ð´Ð°ÑÐ¸ Ð¾Ð¿ÑÐ¸Ð¼Ð¸Ð·Ð°ÑÐ¸Ð¸ ÑÐ°Ð·Ð¼ÐµÑÐµÐ½Ð¸Ñ ÑÐµÑÑÑÑÐ¾Ð². ÐÐ°Ð½Ð½ÑÐµ Ð¸ÑÑÐ»ÐµÐ´Ð¾Ð²Ð°Ð½Ð¸Ñ Ð¾ÑÐ½Ð¾Ð²ÑÐ²Ð°ÑÑÑÑ Ð½Ð° ÑÐ¶Ðµ ÑÑÑÐµÑÑÐ²ÑÑÑÐ¸Ñ Ð¾Ð¿ÑÐ¸Ð¼Ð¸Ð·Ð°ÑÐ¸Ð¾Ð½Ð½ÑÑ Ð¼ÐµÑÐ¾Ð´Ð°Ñ. Ð¦ÐµÐ»ÑÑ ÑÐ°Ð±Ð¾ÑÑ ÑÐ²Ð»ÑÐµÑÑÑ ÑÐµÐ°Ð»Ð¸Ð·Ð°ÑÐ¸Ñ Ð¸ Ð¸ÑÑÐ»ÐµÐ´Ð¾Ð²Ð°Ð½Ð¸Ðµ Ð¼ÐµÑÐ¾Ð´Ð° Ð¿Ð¾ÑÐ¾Ð³Ð¾Ð²Ð¾Ð¹ Ð¾ÑÐµÐ½ÐºÐ¸ Ñ Ð¾Ð³ÑÐ°Ð½Ð¸ÑÐµÐ½Ð¸ÐµÐ¼ Ð¿Ð¾ Ð¾Ð±ÑÐµÐ¼Ñ Ð¸ ÑÐ°ÑÑÑÐ¾ÑÐ½Ð¸Ñ Ð´Ð»Ñ Ð¿ÐµÑÐµÑÐ°ÑÐ¿ÑÐµÐ´ÐµÐ»ÐµÐ½Ð¸Ñ Ð´Ð°Ð½Ð½ÑÑ Ð² ÑÐ°ÑÐ¿ÑÐµÐ´ÐµÐ»ÐµÐ½Ð½ÑÑ Ð¡Ð£ÐÐ. Ð Ð·Ð°Ð´Ð°ÑÐ¸ ÑÐ°Ð±Ð¾ÑÑ Ð²ÑÐ¾Ð´Ð¸Ñ Ð¸ÑÑÐ»ÐµÐ´Ð¾Ð²Ð°Ð½Ð¸Ðµ Ð¸ ÑÐµÐ°Ð»Ð¸Ð·Ð°ÑÐ¸Ñ Ð°Ð»Ð³Ð¾ÑÐ¸ÑÐ¼Ð° Ð¿Ð¾ÑÐ¾Ð³Ð¾Ð²Ð¾Ð¹ Ð¾ÑÐµÐ½ÐºÐ¸, Ð°Ð½Ð°Ð»Ð¸Ð· Ð¿Ð°ÑÐ°Ð¼ÐµÑÑÐ¾Ð² Ð°Ð»Ð³Ð¾ÑÐ¸ÑÐ¼Ð°, Ð²Ð»Ð¸ÑÑÑÐ¸Ñ Ð½Ð° ÐºÐ°ÑÐµÑÑÐ²Ð¾ ÑÐ°ÑÐ¿ÑÐµÐ´ÐµÐ»ÐµÐ½Ð¸Ñ Ð¿Ð¾ ÑÐ·Ð»Ð°Ð¼ Ð±Ð°Ð·Ñ Ð´Ð°Ð½Ð½ÑÑ, Ð° ÑÐ°ÐºÐ¶Ðµ Ð¸ÑÑÐ»ÐµÐ´Ð¾Ð²Ð°Ð½Ð¸Ðµ Ð²Ð»Ð¸ÑÐ½Ð¸Ñ Ð¿Ð°ÑÐ°Ð¼ÐµÑÑÐ¾Ð² Ð¿ÑÐµÐ´Ð»Ð¾Ð¶ÐµÐ½Ð½Ð¾Ð³Ð¾ Ð¼ÐµÑÐ¾Ð´Ð° Ð½Ð° Ð¼Ð¾Ð´ÐµÐ»Ð¸ ÑÐ°ÑÐ¿ÑÐµÐ´ÐµÐ»ÐµÐ½Ð½Ð¾Ð¹ Ð±Ð°Ð·Ñ Ð´Ð°Ð½Ð½ÑÑ. ÐÑÑÐ»ÐµÐ´Ð¾Ð²Ð°Ð½Ð¸Ñ Ð¿ÑÐ¾Ð²Ð¾Ð´ÑÑÑÑ Ð¼ÐµÑÐ¾Ð´Ð°Ð¼Ð¸ ÐºÐ¾Ð¼Ð¿ÑÑÑÐµÑÐ½Ð¾Ð³Ð¾ Ð¼Ð¾Ð´ÐµÐ»Ð¸ÑÐ¾Ð²Ð°Ð½Ð¸Ñ. Ð ÑÐµÐ·ÑÐ»ÑÑÐ°ÑÐµ ÑÐ°Ð±Ð¾ÑÑ ÑÐ°Ð·ÑÐ°Ð±Ð¾ÑÐ°Ð½ Ð¼Ð°ÐºÐµÑ Ð±Ð°Ð·Ñ Ð´Ð°Ð½Ð½ÑÑ Ð¸ ÑÐµÐ°Ð»Ð¸Ð·Ð¾Ð²Ð°Ð½Ñ Ð°Ð»Ð³Ð¾ÑÐ¸ÑÐ¼Ñ Ð³ÐµÐ½ÐµÑÐ°ÑÐ¸Ð¸ ÑÐ°Ð±Ð»Ð¸Ñ Ð¸Ð½ÑÐµÐ½ÑÐ¸Ð²Ð½Ð¾ÑÑÐµÐ¹ Ð·Ð°Ð¿ÑÐ¾ÑÐ¾Ð² Ð¸ Ð°Ð»Ð³Ð¾ÑÐ¸ÑÐ¼ Ð¿Ð¾ÑÐ¾Ð³Ð¾Ð²Ð¾Ð¹ Ð¾ÑÐµÐ½ÐºÐ¸, ÐºÐ¾ÑÐ¾ÑÑÐ¹ ÑÐºÑÐ¿ÐµÑÐ¸Ð¼ÐµÐ½ÑÐ°Ð»ÑÐ½Ð¾ Ð¿ÑÐ¾Ð²ÐµÑÐµÐ½ Ð½Ð° Ð¿Ð¾Ð»ÑÑÐµÐ½Ð½Ð¾Ð¼ Ð¼Ð°ÐºÐµÑÐµ Ð±Ð°Ð·Ñ Ð´Ð°Ð½Ð½ÑÑ. Ð ÐµÐ·ÑÐ»ÑÑÐ°ÑÐ°Ð¼Ð¸ ÑÐ°Ð±Ð¾ÑÑ ÑÑÐ°Ð»Ð¾ Ð¿Ð¾Ð´ÑÐ²ÐµÑÐ¶Ð´ÐµÐ½Ð¸Ðµ ÑÑÑÐµÐºÑÐ¸Ð²Ð½Ð¾ÑÑÐ¸ ÑÐ°Ð±Ð¾ÑÑ Ð°Ð»Ð³Ð¾ÑÐ¸ÑÐ¼Ð° Ð¿Ð¾ÑÐ¾Ð³Ð¾Ð²Ð¾Ð¹ Ð¾ÑÐµÐ½ÐºÐ¸ Ð´Ð»Ñ ÑÐ°ÑÐ¿ÑÐµÐ´ÐµÐ»ÐµÐ½Ð½ÑÑ Ð±Ð°Ð· Ð´Ð°Ð½Ð½ÑÑ. ÐÐ¾Ð´ÐµÐ»Ð¸ÑÐ¾Ð²Ð°Ð½Ð¸Ðµ Ð¸ ÑÐºÑÐ¿ÐµÑÐ¸Ð¼ÐµÐ½ÑÑ Ð¿Ð¾ÐºÐ°Ð·Ð°Ð»Ð¸, ÑÑÐ¾ Ð°Ð»Ð³Ð¾ÑÐ¸ÑÐ¼ Ð´Ð°ÐµÑ Ð»ÑÑÑÐ¸Ðµ ÑÐµÐ·ÑÐ»ÑÑÐ°ÑÑ Ð½Ð° Ð±Ð°Ð·Ð°Ñ Ñ Ð¼Ð°Ð»ÑÐ¼ ÐºÐ¾Ð»Ð¸ÑÐµÑÑÐ²Ð¾Ð¼ ÑÑÐ°Ð³Ð¼ÐµÐ½ÑÐ¾Ð², Ð² Ð¾ÑÑÐ°Ð»ÑÐ½ÑÑ ÑÐ»ÑÑÐ°ÑÑ ÑÐµÐ·ÑÐ»ÑÑÐ°Ñ ÑÐ»ÑÑÑÐ°ÐµÑÑÑ Ð¿Ð¾ ÑÑÐ°Ð²Ð½ÐµÐ½Ð¸Ñ Ñ Ð½Ð°ÑÐ°Ð»ÑÐ½ÑÐ¼Ð¸ Ð¿Ð¾ÐºÐ°Ð·Ð°ÑÐµÐ»ÑÐ¼Ð¸, Ð½Ð¾ Ð´Ð°ÐµÑ Ð¼ÐµÐ½ÑÑÐ¸Ð¹ Ð¿ÑÐ¸ÑÐ¾ÑÑ ÑÑÑÐµÐºÑÐ¸Ð²Ð½Ð¾ÑÑÐ¸.
description: The given work is devoted to the study of algorithms for dynamic data dis-tribution in distributed DBMS. There are many approaches to solving the question of an efficient and scalable way to optimize the performance of distributed database systems. Currently, research and development of approaches to solving the prob-lem of optimizing resource allocation is being used. The research data is based on already optimization methods. The aim of the work is to implement and study the method of threshold estimation with restrictions on volume and distance for data redistribution in distributed DBMS. The tasks of the work include the study and implementation of the threshold estimation algorithm, the analysis of the algorithm parameters affecting the quality of the distribution over the database nodes, as well as the study of the influencing parameters of the proposed method on the distributed data model. Testing of com-puter modeling methods. As a result of the work, a database layout and implemented algorithms for generating tables of intensive queries and a threshold estimation algorithm were developed, which was experimentally tested on the resulting database layout. The results of the work were confirmation of the efficiency of the threshold estimation algorithm for distributed databases. Simulations and experiments have shown that the algorithm gives better results on bases with a small result of fragments, in other cases it improves in terms of the initial indicators, but gives a smaller increase in efficiency.