title: ÐÑÑÐ»ÐµÐ´Ð¾Ð²Ð°Ð½Ð¸Ðµ Ð´Ð¸Ð½Ð°Ð¼Ð¸ÑÐµÑÐºÐ¾Ð³Ð¾ Ð°Ð»Ð³Ð¾ÑÐ¸ÑÐ¼Ð° Ð²Ð¸Ð·ÑÐ°Ð»Ð¸Ð·Ð°ÑÐ¸Ð¸ ÑÑ ÐµÐ¼ ÑÐµÐ»ÑÑÐ¸Ð¾Ð½Ð½ÑÑ Ð±Ð°Ð· Ð´Ð°Ð½Ð½ÑÑ
title: Ð²ÑÐ¿ÑÑÐºÐ½Ð°Ñ ÐºÐ²Ð°Ð»Ð¸ÑÐ¸ÐºÐ°ÑÐ¸Ð¾Ð½Ð½Ð°Ñ ÑÐ°Ð±Ð¾ÑÐ° Ð±Ð°ÐºÐ°Ð»Ð°Ð²ÑÐ°
titleType: Subtitle
title: Study of dynamic algorithm for visualisation of relation database schemas
Creators: name: ÐÐ°Ð²ÑÑÐ»Ð¾Ð², ÐÐ¸ÐºÐ¸ÑÐ°
Publisher: name: Ð¡Ð°Ð½ÐºÑ-ÐÐµÑÐµÑÐ±ÑÑÐ³ÑÐºÐ¸Ð¹ Ð¿Ð¾Ð»Ð¸ÑÐµÑÐ½Ð¸ÑÐµÑÐºÐ¸Ð¹ ÑÐ½Ð¸Ð²ÐµÑÑÐ¸ÑÐµÑ ÐÐµÑÑÐ° ÐÐµÐ»Ð¸ÐºÐ¾Ð³Ð¾
Year: 2024
Subjects: Ð±Ð°Ð·Ð° Ð´Ð°Ð½Ð½ÑÑ
ÑÐµÐ»ÑÑÐ¸Ð¾Ð½Ð½Ð°Ñ Ð±Ð°Ð·Ð° Ð´Ð°Ð½Ð½ÑÑ
ÑÑ ÐµÐ¼Ð° Ð´Ð°Ð½Ð½ÑÑ
Ð³ÑÐ°ÑÐ¸ÑÐµÑÐºÐ°Ñ ÑÑ ÐµÐ¼Ð°
Ð³ÑÐ°Ñ
Ð´ÐµÑÐµÐ²Ð¾
ÑÐ¿ÑÐ°Ð²Ð»ÐµÐ½Ð¸Ðµ ÑÑ ÐµÐ¼Ð¾Ð¹
ÑÑÐ°Ð½ÑÐ»ÑÑÐ¸Ñ
SQL.
database
relational database
data schema
graphical schema
graph
tree
schema management
translation

description: ÐÑÐµÐ´Ð¼ÐµÑÐ½Ð¾Ð¹ Ð¾Ð±Ð»Ð°ÑÑÑÑ Ð´Ð°Ð½Ð½Ð¾Ð¹ ÑÐ°Ð±Ð¾ÑÑ ÑÐ²Ð»ÑÐµÑÑÑ Ð³ÑÐ°ÑÐ¸ÑÐµÑÐºÐ¾Ðµ Ð¿ÑÐµÐ´ÑÑÐ°Ð²Ð»ÐµÐ½Ð¸Ðµ Ð»Ð¾Ð³Ð¸ÑÐµÑÐºÐ¾Ð¹ ÑÑÐµÐ¼Ñ ÑÐµÐ»ÑÑÐ¸Ð¾Ð½Ð½ÑÑ Ð±Ð°Ð· Ð´Ð°Ð½Ð½ÑÑ. ÐÐ»Ð°Ð²Ð½Ð°Ñ Ð¿ÑÐ¾Ð±Ð»ÐµÐ¼Ð° Ð³ÑÐ°ÑÐ¸ÑÐµÑÐºÐ¾Ð³Ð¾ Ð¿ÑÐµÐ´ÑÑÐ°Ð²Ð»ÐµÐ½Ð¸Ñ Ð»Ð¾Ð³Ð¸ÑÐµÑÐºÐ¾Ð¹ ÑÑÐµÐ¼Ñ Ð·Ð°ÐºÐ»ÑÑÐ°ÐµÑÑÑ Ð² Ð½Ð¸Ð·ÐºÐ¾Ð¼ ÐºÐ°ÑÐµÑÑÐ²Ðµ Ð²Ð¾ÑÐ¿ÑÐ¸ÑÑÐ¸Ñ ÑÐ°ÐºÐ¾Ð¹ ÑÑÐµÐ¼Ñ Ð¸Ð·-Ð·Ð° Ð½ÐµÑÐ¾Ð±Ð»ÑÐ´ÐµÐ½Ð¸Ñ Ð³ÑÐ°ÑÐ¸ÑÐµÑÐºÐ¸Ñ, ÑÑÑÐµÑÐ¸ÑÐµÑÐºÐ¸Ñ Ð¸ Ð»Ð¾Ð³Ð¸ÑÐµÑÐºÐ¸Ñ Ð°ÑÐ¿ÐµÐºÑÐ¾Ð² Ð²Ð¸Ð·ÑÐ°Ð»Ð¸Ð·Ð°ÑÐ¸Ð¸.Â  ÐÑÐµÐ´Ð»Ð¾Ð¶ÐµÐ½Ð½Ð¾Ðµ Ð² Ð´Ð°Ð½Ð½Ð¾Ð¹ ÑÐ°Ð±Ð¾ÑÐµ ÑÐµÑÐµÐ½Ð¸Ðµ Ð·Ð°ÐºÐ»ÑÑÐ°ÐµÑÑÑ Ð² Ð¸ÑÐ¿Ð¾Ð»ÑÐ·Ð¾Ð²Ð°Ð½Ð¸Ð¸ Ð¸ ÑÐ¾Ð±Ð»ÑÐ´ÐµÐ½Ð¸Ð¸ ÐºÐ¾Ð¼Ð¿Ð»ÐµÐºÑÐ° Ð²ÑÑÐ²Ð»ÐµÐ½Ð½ÑÑ ÑÑÐµÐ±Ð¾Ð²Ð°Ð½Ð¸Ð¹ Ðº Ð³ÑÐ°ÑÐ¸ÑÐµÑÐºÐ¸Ð¼, ÑÑÑÐµÑÐ¸ÑÐµÑÐºÐ¸Ð¼ Ð¸ Ð»Ð¾Ð³Ð¸ÑÐµÑÐºÐ¸Ð¼ Ð°ÑÐ¿ÐµÐºÑÐ°Ð¼ Ð²Ð¸Ð·ÑÐ°Ð»Ð¸Ð·Ð°ÑÐ¸Ð¸. Ð Ð°Ð·ÑÐ°Ð±Ð¾ÑÐ°Ð½Ð½Ð¾Ðµ ÑÐµÑÐµÐ½Ð¸Ðµ Ð¿Ð¾Ð·Ð²Ð¾Ð»ÑÐµÑ Ð²Ð¸Ð·ÑÐ°Ð»Ð¸Ð·Ð¸ÑÐ¾Ð²Ð°ÑÑ Ð»Ð¾Ð³Ð¸ÑÐµÑÐºÐ¸Ðµ ÑÑÐµÐ¼Ñ ÑÐµÐ»ÑÑÐ¸Ð¾Ð½Ð½ÑÑ Ð±Ð°Ð· Ð´Ð°Ð½Ð½ÑÑ ÑÐ¾ÑÑÐ°Ð½ÑÑ ÐºÐ°ÑÐµÑÑÐ²Ð¾ ÑÐ¸Ð½ÑÐµÐ·Ð° Ð»Ð¾Ð³Ð¸ÑÐµÑÐºÐ¾Ð³Ð¾ ÑÑÑÑÐ¾Ð¹ÑÑÐ²Ð° Ð±Ð°Ð·Ñ Ð´Ð°Ð½Ð½ÑÑ. Ð Ð°Ð±Ð¾ÑÐ° Ð°Ð»Ð³Ð¾ÑÐ¸ÑÐ¼Ð° Ð²Ð¸Ð·ÑÐ°Ð»Ð¸Ð·Ð°ÑÐ¸Ð¸ Ð»Ð¾Ð³Ð¸ÑÐµÑÐºÐ¸Ñ ÑÑÐµÐ¼ Ð¼Ð¾Ð¶ÐµÑ Ð±ÑÑÑ Ð¿ÑÐ¸Ð¼ÐµÐ½ÐµÐ½Ð° Ð² Ð³ÑÐ°ÑÐ¸ÑÐµÑÐºÐ¸Ñ ÑÐµÐ´Ð°ÐºÑÐ¾ÑÐ°Ñ Ð¸ Ð¸Ð½ÑÑÑÑÐ¼ÐµÐ½ÑÐ°Ñ, ÑÐ²ÑÐ·Ð°Ð½Ð½ÑÑ Ñ Ð°Ð½Ð°Ð»Ð¸Ð·Ð¾Ð¼ Ð±Ð°Ð· Ð´Ð°Ð½Ð½ÑÑ. ÐÐ¾Ð¿Ð¾Ð»Ð½Ð¸ÑÐµÐ»ÑÐ½Ð¾, Ð´ÐµÐºÐ¾Ð¼Ð¿Ð¾Ð·Ð¸ÑÐ¸Ñ Ð°Ð»Ð³Ð¾ÑÐ¸ÑÐ¼Ð° Ð¿Ð¾Ð·Ð²Ð¾Ð»ÑÐµÑ Ð¸ÑÐ¿Ð¾Ð»ÑÐ·Ð¾Ð²Ð°ÑÑ ÑÐµÑÐµÐ½Ð¸Ðµ Ð² ÑÐ°Ð·Ð²Ð¾Ð´ÐºÐµ Ð¿ÐµÑÐ°ÑÐ½ÑÑ Ð¿Ð»Ð°Ñ, ÑÐµÐ»ÐµÐºÐ¾Ð¼Ð¼ÑÐ½Ð¸ÐºÐ°ÑÐ¸ÑÑ, Ð°Ð²ÑÐ¾Ð¼Ð°ÑÐ¸Ð·Ð°ÑÐ¸Ð¸ Ð¿ÑÐ¾Ð¸Ð·Ð²Ð¾Ð´ÑÑÐ²ÐµÐ½Ð½ÑÑ Ð»Ð¸Ð½Ð¸Ð¹ Ð¸ Ð² Ð´ÑÑÐ³Ð¸Ñ ÑÐ¼ÐµÐ¶Ð½ÑÑ Ð¾Ð±Ð»Ð°ÑÑÑÑ.Â 
description: The subject area of this paper is the graphical representation of the logical schema of relational databases. The main problem of the graphical representation of the logical schema is the low quality of the perception of such a schema due to non-compliance with the graphical, aesthetic and logical aspects of visualisation.Â  The solution proposed in this paper is to use and comply with a set of identified requirements for graphical, aesthetic and logical aspects of visualisation. The developed solution allows to visualise logical schemes of relational databases preserving the quality of perception of the logical structure of the database. The work of the algorithm of visualisation of logical schemes can be applied in graphical editors and tools related to database analysis. Additionally, the decomposition of the algorithm allows the solution to be used in PCB layout, telecommunications, production line automation and other related fields.