Transaction Processing Method and Cloud-Native Database System

Patent metadata

Field	Value
Publication number	US-2026099485-A1
Application number	US-202519416090-A
Country	US
Kind code	A1
Filing date	Dec 11, 2025
Priority date	Jun 12, 2023
Publication date	Apr 9, 2026
Grant date	—

Abstract

A transaction processing method includes: a first database computing node that responds to a transaction request of a user and starts to process a target transaction; the first database computing node stores state information of the target transaction into a database state node in a process of processing the target transaction; in the process in which the first database computing node processes the target transaction, the first database computing node suspends processing the target transaction; and a second database computing node obtains the state information of the target transaction from the database state node, and continues to process the target transaction based on the state information of the target transaction.

First claim

1 . A method, applied to a cloud-native database system, and comprising:
responding, by a first database computing node of the cloud-native database system, to a transaction request of a user by starting a first process of processing a target transaction, wherein the target transaction performs at least one of a read operation or a write operation on data of a database in a database storage node of the cloud-native database system; storing, by the first database computing node in the first process, state information of the target transaction into a database state node of the cloud-native database system; suspending, by the first database computing node, the first process; obtaining, by a second database computing node of the cloud-native database system, the state information from the database state node; and continuing, by the second database computing node, the first process based on the state information.

2 . The method of claim 1 , wherein the state information is for recording an execution state of a structured query language (SQL) statement that is being executed in the target transaction before the target transaction is suspended, and wherein continuing the first process based on the state information comprises continuing, by the second database computing node based on the execution state, to execute the SQL statement.

3 . The method of claim 1 , wherein storing the state information comprises storing, by the first database computing node, a log of the target transaction into the database state node, and wherein continuing the first process based on the state information comprises continuing, by the second database computing node based on the log, to perform the write operation.

4 . The method of claim 3 , wherein storing the state information comprises storing, by the first database computing node into the database state node, a table locked state of the write operation that is being performed in the target transaction before the target transaction is suspended, and wherein continuing the first process based on the state information comprises continuing, by the second database computing node based on the log and the table locked state, to perform the write operation.

5 . The method of claim 1 , wherein storing the state information comprises storing, by the first database computing node into the database state node, a query execution plan tree and an intermediate result of a structured query language (SQL) statement that corresponds to the read operation and that is being executed in the target transaction before the target transaction is suspended, and wherein continuing the first process based on the state information comprises continuing, by the second database computing node based on the query execution plan tree and the intermediate result, to perform the read operation.

6 . The method of claim 1 , wherein storing the state information of the target transaction comprises storing, by the first database computing node in the first process into the database state node, a structured query language (SQL) statement that corresponds to the read operation and that is currently being executed in the target transaction before the target transaction is suspended, and wherein continuing the first process based on the state information comprises re-executing, by the second database computing node, the SQL statement.

7 . The method of claim 6 , wherein storing the state information comprises storing, by the first database computing node in the first process into the database state node, an execution result of the SQL statement, and wherein continuing the first process based on the state information further comprises, continuing, by the second database computing node and after re-executing the SQL statement, to process the target transaction based on the execution result.

8 . (canceled)

9 . The method of claim 1 , further comprising:
pushing down, by the first database computing node to the database storage node for execution, a target operator of a structured query language (SQL) statement that is being executed in the target transaction before the target transaction is suspended, wherein the target operator is a part of operators comprised in a query execution plan tree of the SQL statement; and storing, by the database storage node, an execution result of the target operator, wherein obtaining after the first database computing node suspends processing the target transaction, the state information comprises obtaining, by the second database computing node after the first database computing node suspends processing the target transaction, the state information from the database state node, and obtaining the execution result of the target operator from the database storage node, and wherein continuing to process the target transaction based on the state information comprises continuing, by the second database computing node based on the state information and the execution result of the target operator, to execute the SQL statement.

10 . The method of claim 1 , wherein the state information comprises a session state.

11 . A cloud-native database system comprising:
a database storage node configured to store data of a database; a database state node; a first database computing node configured to:
respond to a transaction request of a user by starting a first process of processing a target transaction, wherein the target transaction performs at least one of a read operation or a write operation on the data, and wherein the database storage node is configured to store the data;
store, in the first process, state information of the target transaction into the database state node; and
suspend the first process; and
a second database computing node configured to:
obtain the state information from the database state node; and
continue the first process based on the state information.

12 . The cloud-native database system of claim 11 , wherein the state information is for recording an execution state of a structured query language (SQL) statement that is being executed in the target transaction before the target transaction is suspended, and wherein the second database computing node is further configured to further continue the first process based on the state information by continuing, based on the execution state, to execute the SQL statement.

13 . The cloud-native database system of claim 11 , wherein the first database computing node is further configured to further store the state information by storing a log of the target transaction into the database state node, and wherein the second database computing node is further configured to further continue the first process based on the state information by continuing, based on the log, to perform the write operation.

14 . The cloud-native database system of claim 13 , wherein the first database computing node is further configured to further store the state information by storing, into the database state node, a table locked state of the write operation, and wherein the second database computing node is further configured to further continue the first process based on the state information by continuing, based on the log and the table locked state, to perform the write operation.

15 . The cloud-native database system of claim 11 , wherein the first database computing node is further configured to further store the state information by storing, into the database state node, a query execution plan tree and an intermediate result of an SQL statement that corresponds to the read operation and that is being executed in the target transaction before the targ

Assignees

• Huawei Cloud Computing Tech Co Ltd

Inventors

• Ma Wenlong
• Zhang Wenliang
• Peng Lixun

Classifications

• G06F2201/80

  Database-specific techniques · CPC title

• G06F16/2471

  Distributed queries · CPC title

• G06F16/2343 Primary

  Locking methods, e.g. distributed locking or locking implementation details · CPC title

• G06F16/2358

  Change logging, detection, and notification (replication G06F16/27) · CPC title

• G06F16/2379 Primary

  Updates performed during online database operations; commit processing · CPC title