Transaction committing method and device based on distributed type real-time database system

Abstract

The invention provides a transaction committing method and device based on a distributed type real-time database system. The method comprises the steps as follows: a coordinator takes a participant who sends and complete information of data operation as a candidate coordinator and sends preparation information and appointment information to the candidate coordinator; the coordinator sends the preparation information to an ordinary participant and the coordinator; the coordinator receives obtained processing feedback information of the candidate coordinator, the ordinary participant and the coordinator after the candidate coordinator, the ordinary participant and the coordinator receive the preparation information and process transactions of the candidate coordinator, the ordinary participant and the coordinator, and sends final decision information to the candidate coordinator, the ordinary participant and the coordinator according to the processing feedback information; and under the condition that the candidate coordinator, the ordinary participant and the coordinator all don't receive the final decision information within a preset time, the candidate coordinator is changed into a coordinator automatically, and the step of executing the reception of the information that all participants complete data operation is returned to, so that the blocking probability is reduced, and the timeliness of transaction committing is improved.

Description

technical field [0001] This application relates to the field of database transaction submission, in particular to a transaction submission method and device based on a distributed real-time database system. Background technique [0002] A distributed database system is a database that distributes a group of related data in a computer network and is managed uniformly by a distributed database management system. [0003] With the popularity of real-time applications, an execution deadline is introduced on the basis of distributed database systems, and a distributed real-time database system is obtained. [0004] One method used to commit database transactions is the two-phase commit method. In the two-phase commit method, after the participants receive the prepare message sent by the coordinator, the participants send a commit message or an abort message to the coordinator to inform the coordinator whether they can submit their respective sub-transactions. After the particip...

AI Technical Summary

Problems solved by technology

[0005] When the database transaction commit processing is implemented by the two-phase commit method, when the sub-transaction currently processed by the participant is in the pre-commit state and the coordinator fails, all locks and all data resources associated with the sub-transaction currently processed by the participant will not Release, so that other database transactions cannot use unreleased data resources, resulting in blocking of other database transactions, reducing the real-time performance of other transaction submissions

[0006] It can be seen from the above that when the two-phase commit method is applied to a distributed real-time database system, during any transaction commit process, when the sub-transaction currently processed by the participant is in the pre-commit state and the coordinator fails, it will cause other database transactions to fail. The probability of blocking reaches 100%, which reduces the real-time performance of other database transaction submissions

Images