Distributed databases data architecture of continuous corporate learning process control system in the lcc gazprom transgaz nizhny novgorod

Minimization costs is one of the key tasks in the organization of the corporate training process in a large company, which can be partially solved by the introduction of specialized automated systems. Increasing the automation level here should be carried out very carefully, as excessive automation can make the system uncomfortable and not flexible enough. An information technology infrastructure of LCC Gazprom transgaz Nizhny Novgorod currently has a number of significant limitations and requirements for the information system that makes it impossible to use online access to the unified database and using two-phase transactions. This paper presents the development of an original synchronization mechanism of distributed databases data based on the method of asynchronous delivery of the transaction log. The proposed principle of construction of the system minimizes the work on setting up the database on remote nodes. The application problem of ensuring the integration of the local databases residing in some nodes of the computer network to a user running on any node in the network has been solved. The architecture of interaction at different levels is described.