The application of the two-phase confirmation of transactions protocol in distributed databases

This paper is devoted to the problem of distributed queries and transactions in distributed heterogeneous databases. Some of the complexity of managing the parallel execution and the possible solutions are highlighted. The main attention in article is given the most difficult mechanisms to ensure the stable and reliable operation of databases in automated systems, - guaranteeing the integrity and consistency of data and to the mechanism of distributed transactions and distributed queries. Here is shown the critical importance of clear governance parallel implementation that avoids dead-ends and contradictions in multiprocessor operations. The solution of this problem lies in the Protocol is two-phase confirmation of transactions. The article shows its implementation in two phases of execution.