Unlock instant, AI-driven research and patent intelligence for your innovation.

A Two-stage Commit Transaction Control Method

A control method and two-stage technology, applied in the transaction control field of two-stage commit, can solve the problems of increasing the probability of database lock conflict, prolonging transaction execution time, prolonging transaction time, etc., so as to reduce lock conflict and lock waiting time. , reduce transaction execution time, reduce the effect of transaction time

Active Publication Date: 2019-04-23
INSPUR COMMON SOFTWARE
View PDF7 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

The complex business in a large system puts a lot of pressure on the concurrency of the system, which in turn leads to very frequent data operations in the database, which increases the probability of lock conflicts in the database, which leads to lock waiting and prolongs the database operation time.
The lock waiting process will cause the transaction to be unable to execute, which will prolong the execution time of the transaction, and will further prolong the time of the entire transaction, which will eventually lead to the generation of database operation bottlenecks, which greatly restricts the parallelism of database operations, resulting in similar The phenomenon of "traffic jam effect"

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • A Two-stage Commit Transaction Control Method
  • A Two-stage Commit Transaction Control Method
  • A Two-stage Commit Transaction Control Method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment

[0057] Suppose there is an order business in the application system, and the order has a master-slave structure consisting of an order master table and an order detail table.

[0058] The structure of the order master table is shown in Table 1 below:

[0059] Table 1

[0060] field name

Chinese name

Types of

illustrate

ID

Unique ID of the order

VARCHAR(36)

GUID

Code

order number

VARCHAR(100)

Sum

order amount

MONY

[0061] The structure of the order details table is shown in Table 2 below:

[0062] Table 2

[0063]

[0064] The specific process of using the transaction control method of the present invention's two-stage submission to the order is as follows:

[0065] 1. The created transaction management list information is as follows:

[0066] transaction ID

transaction status

creation time

Start Time

Complete time

describe

T1

created

Time1

N...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention discloses a two-stage commit transaction control method, which belongs to the technical field of program transaction processing of application software. The transaction control method of the two-stage submission of the present invention comprises the following stages: (1) start logical transaction: specifically comprise the following steps: 1.1, register this logical transaction in the transaction management list; 1.2, set up the logical transaction data buffer; 1.3, Mark the state of the logical transaction as started, and return the transaction ID; (2) submit the changed data to the logical transaction data buffer; (3) submit the logical transaction. The two-stage submitted transaction control method of the invention can effectively reduce lock conflicts, lock waiting and transaction execution time, reduce the transaction time of the application system, enable the application system to support a larger amount of concurrency, and have a good promotion and application value.

Description

technical field [0001] The invention relates to the technical field of program transaction processing of application software, and specifically provides a two-stage commit transaction control method. Background technique [0002] The transaction of application software is a group of tasks that must be processed atomically in the computer system. The amount of so-called atomic processing is that only one thread can operate on it at the same time. In atomically processed tasks, if any one of the tasks fails, the changes made by any other successful tasks are rolled back. The result of rollback after a transaction fails in the system is to restore to the initial state before the transaction was started. The realization of transaction of application software in computer system often depends on the realization of transaction of relational database. A relational database transaction is a sequence of database operations defined by the user. These operations are either done or not...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Patents(China)
IPC IPC(8): G06F9/46
CPCG06F9/467
Inventor 孙立新周仑宫保金
Owner INSPUR COMMON SOFTWARE