title: Ð Ð°Ð·ÑÐ°Ð±Ð¾ÑÐºÐ° Ñ ÑÐ°Ð½Ð¸Ð¼ÑÑ Ð¿ÑÐ¾ÑÐµÐ´ÑÑ Ð´Ð»Ñ ÑÐ¸Ð½Ñ ÑÐ¾Ð½Ð¸Ð·Ð°ÑÐ¸Ð¸ ÑÐ°Ð±Ð»Ð¸Ñ Ð¡Ð£ÐÐ 1Ð¡
title: Ð²ÑÐ¿ÑÑÐºÐ½Ð°Ñ ÐºÐ²Ð°Ð»Ð¸ÑÐ¸ÐºÐ°ÑÐ¸Ð¾Ð½Ð½Ð°Ñ ÑÐ°Ð±Ð¾ÑÐ° Ð±Ð°ÐºÐ°Ð»Ð°Ð²ÑÐ°
titleType: Subtitle
title: Development of stored procedures for synchronizing tables in DBMS 1C
Creators: name: Ð¤ÑÐ´Ð¾ÑÐ¾Ð², ÐÐ²Ð°Ð½
Publisher: name: Ð¡Ð°Ð½ÐºÑ-ÐÐµÑÐµÑÐ±ÑÑÐ³ÑÐºÐ¸Ð¹ Ð¿Ð¾Ð»Ð¸ÑÐµÑÐ½Ð¸ÑÐµÑÐºÐ¸Ð¹ ÑÐ½Ð¸Ð²ÐµÑÑÐ¸ÑÐµÑ ÐÐµÑÑÐ° ÐÐµÐ»Ð¸ÐºÐ¾Ð³Ð¾
Year: 2021
Subjects: cÐ¸Ð½Ñ ÑÐ¾Ð½Ð¸Ð·Ð°ÑÐ¸Ñ Ð±Ð°Ð· Ð´Ð°Ð½Ð½ÑÑ
Ñ ÑÐ°Ð½Ð¸Ð¼ÑÐµ Ð¿ÑÐ¾ÑÐµÐ´ÑÑÑ
PosgreSQL
Ð¡Ð£ÐÐ 1C
Python
database synhronization
stored procedures
PostgreSQL
DBMS 1C

description: ÐÐ°Ð½Ð½Ð°Ñ ÑÐ°Ð±Ð¾ÑÐ° Ð¿Ð¾ÑÐ²ÑÑÐµÐ½Ð° Ð¸ÑÑÐ»ÐµÐ´Ð¾Ð²Ð°Ð½Ð¸Ñ ÑÐµÑÐ½Ð¾Ð»Ð¾Ð³Ð¸Ð¹ Ð¾ÑÐ³Ð°Ð½Ð¸Ð·Ð°ÑÐ¸Ð¸ ÑÐ¸Ð½ÑÑÐ¾Ð½Ð¸Ð·Ð°ÑÐ¸Ð¸ ÑÐ°Ð±Ð»Ð¸Ñ Ð´Ð»Ñ Ð¡Ð£ÐÐ 1Ð¡. ÐÐ°Ð´Ð°ÑÐ¸, ÐºÐ¾ÑÐ¾ÑÑÐµ ÑÐµÑÐ°Ð»Ð¸ÑÑ Ð² ÑÐ¾Ð´Ðµ Ð¸ÑÑÐ»ÐµÐ´Ð¾Ð²Ð°Ð½Ð¸Ñ: 1. ÐÑÑÐ»ÐµÐ´Ð¾Ð²Ð°Ð½Ð¸Ðµ Ð¿ÑÐ¾Ð±Ð»ÐµÐ¼Ñ ÑÐ¸Ð½ÑÑÐ¾Ð½Ð¸Ð·Ð°ÑÐ¸Ð¸ Ð±Ð°Ð· Ð´Ð°Ð½Ð½ÑÑ. 2. ÐÐ·ÑÑÐµÐ½Ð¸Ðµ ÑÐµÑÐ½Ð¾Ð»Ð¾Ð³Ð¸Ð¹ ÑÐ¸Ð½ÑÑÐ¾Ð½Ð¸Ð·Ð°ÑÐ¸Ð¸ Ð±Ð°Ð· Ð´Ð°Ð½Ð½ÑÑ. 3. ÐÑÐ±Ð¾Ñ Ð¾Ð¿ÑÐ¸Ð¼Ð°Ð»ÑÐ½Ð¾Ð¹ ÑÐµÑÐ½Ð¾Ð»Ð¾Ð³Ð¸Ð¸ Ð´Ð»Ñ ÐºÐ¾Ð½ÐºÑÐµÑÐ½Ð¾Ð¹ Ð·Ð°Ð´Ð°ÑÐ¸. 4. ÐÐ¿Ð¸ÑÐ°Ð½Ð¸Ðµ Ð²ÑÐ±ÑÐ°Ð½Ð½Ð¾Ð¹ ÑÐµÑÐ½Ð¾Ð»Ð¾Ð³Ð¸Ð¸ ÑÐ¸Ð½ÑÑÐ¾Ð½Ð¸Ð·Ð°ÑÐ¸Ð¸; 5. Ð Ð°Ð·ÑÐ°Ð±Ð¾ÑÐºÐ° ÐºÐ»Ð¸ÐµÐ½ÑÐ° Ð´Ð»Ñ Ð¸Ð¼Ð¿Ð¾ÑÑÐ° Ð±Ð°Ð· Ð² PostgreSQL Ð¸Ð· ÑÐ°Ð¹Ð»Ð¾Ð²Ð¾Ð¹ 1Ð¡. ÐÐ±ÑÐµÐºÑÐ¾Ð¼ Ð¸ÑÑÐ»ÐµÐ´Ð¾Ð²Ð°Ð½Ð¸Ñ ÑÐ²Ð»ÑÑÑÑÑ ÑÐµÑÐ½Ð¾Ð»Ð¾Ð³Ð¸Ð¸ ÑÐ¸Ð½ÑÑÐ¾Ð½Ð¸Ð·Ð°ÑÐ¸Ð¸ Ð±Ð°Ð· Ð´Ð°Ð½Ð½ÑÑ. Ð ÐºÐ°ÑÐµÑÑÐ²Ðµ Ð¿ÑÐµÐ´Ð¼ÐµÑÐ° Ð¸ÑÑÐ»ÐµÐ´Ð¾Ð²Ð°Ð½Ð¸Ñ Ð²ÑÐ±Ð¸ÑÐ°ÐµÑÑÑ Ð·Ð°Ð´Ð°ÑÐ° ÑÐ¸Ð½ÑÑÐ¾Ð½Ð¸Ð·Ð°ÑÐ¸Ð¸ ÑÐ°Ð±Ð»Ð¸Ñ Ð¡Ð£ÐÐ 1Ð¡. Ð ÑÐ°Ð¼ÐºÐ°Ñ ÑÐ°Ð±Ð¾ÑÑ Ð¸ÑÑÐ»ÐµÐ´Ð¾Ð²Ð°Ð½Ð° Ð¿ÑÐ¾Ð±Ð»ÐµÐ¼Ð° ÑÐ¸Ð½ÑÑÐ¾Ð½Ð¸Ð·Ð°ÑÐ¸Ð¸ Ð±Ð°Ð· Ð´Ð°Ð½Ð½ÑÑ, Ð¾Ð¿Ð¸ÑÐ°Ð½Ñ Ð·Ð°Ð´Ð°ÑÐ¸, ÐºÐ¾ÑÐ¾ÑÑÐµ Ð¿ÑÐ¸Ð²Ð¾Ð´ÑÑ Ðº Ð½ÐµÐ¾Ð±ÑÐ¾Ð´Ð¸Ð¼Ð¾ÑÑÐ¸ Ð¾ÑÑÑÐµÑÑÐ²Ð»ÐµÐ½Ð¸Ñ ÑÐ¸Ð½ÑÑÐ¾Ð½Ð¸Ð·Ð°ÑÐ¸Ð¸. Ð Ð°ÑÑÐ¼Ð¾ÑÑÐµÐ½Ñ Ð¾ÑÐ½Ð¾Ð²Ð½ÑÐµ ÑÐµÑÐ½Ð¾Ð»Ð¾Ð³Ð¸Ð¸ ÑÐ¸Ð½ÑÑÐ¾Ð½Ð¸Ð·Ð°ÑÐ¸Ð¸, Ð¸ Ð¿ÑÐ¾Ð²Ð¾Ð´Ð¸ÑÑÑ Ð²ÑÐ±Ð¾Ñ Ð¸ Ð¾Ð±Ð¾ÑÐ½Ð¾Ð²Ð°Ð½Ð¸Ðµ Ð¸Ð½ÑÑÑÑÐ¼ÐµÐ½ÑÐ¾Ð² ÑÐ°Ð·ÑÐ°Ð±Ð¾ÑÐºÐ¸. Ð ÐµÐ·ÑÐ»ÑÑÐ°ÑÐ¾Ð¼ ÑÑÐ°Ð» ÐºÐ»Ð¸ÐµÐ½Ñ, ÑÐ¾ÑÐ¼Ð¸ÑÑÑÑÐ¸Ð¹ ÑÑÐ°Ð½Ð¸Ð¼ÑÐµ Ð¿ÑÐ¾ÑÐµÐ´ÑÑÑ Ð´Ð»Ñ Ð¸Ð¼Ð¿Ð¾ÑÑÐ° Ð±Ð°Ð· Ð² PostgreSQL Ð¸Ð· ÑÐ°Ð¹Ð»Ð¾Ð²Ð¾Ð¹ 1Ð¡.
description: The given work is devoted to studying technologies for organizing table synchronization for 1C DBMS. The research set the following goals: 1. Investigation of the problem of database synchronization. 2. Study of database synchronization technologies. 3. Selection of the optimal technology for a specific task. 4. Description of the selected synchronization technology; 5. Development of a client for importing databases into PostgreSQL from file database 1C. The object of research is database synchronization technologies. The subject of research is the task of synchronizing the tables of the 1C DBMS. Within the framework of the work, the problem of data-base synchronization has been investigated, the tasks that lead to the need for synchronization are described. The main synchronization technologies are considered, and the selection and justification of development tools is carried out. The result was a client that generates stored procedures for importing databases into PostgreSQL from file database 1C.