# US 2025/0165459 A1 · Managing global transactions in hybrid database paradigms

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 2025/0165459 A1
- Document ID: US20250165459A1
- Status: Published application
- Kind: A1
- Application number: 18/515,526
- Filed: 2023-11-21
- Published: 2025-05-22
- Earliest claimed: 2023-11-21
- Assignees: Sap SE
- Applicants: Sap SE
- Inventors: Hui Li; Xia Yu
- Web page: https://patentgrep.com/patent/US20250165459A1

## CPC

- G06F 16/2379: {Updates performed during online database operations; commit processing}
- G06F 16/2365: {Ensuring data consistency and integrity}
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

Methods, systems, and computer-readable storage media for executing, by a first database system, a first sub-transaction of a global transaction, the first sub-transaction impacting a primary record in a first database, in response to successful execution of the first sub-transaction, executing, by a second database system, a second sub-transaction including setting a status of a secondary record to a pending status in a status column of a table that stores data of the secondary record, in response to successfully setting the status, executing, by the first database system, one or more operations to commit changes to the primary record, and selectively setting, by the second database system, the status to one of a first final status and a second final status.

## Claims

### Claim 1

A computer-implemented method for executing global transactions that impact records in multiple, disparate database systems, the method being executed by one or more processors and comprising:
executing, by a first database system, a first sub-transaction of a global transaction, the first sub-transaction impacting a primary record of a first data table stored within a first database of the database system;
in response to successful execution of the first sub-transaction, executing, by a second database system, a second sub-transaction comprising setting a status of a secondary record to a pending status in a status column of a second data table that stores the secondary record, the pending status inhibiting the second record from being used to generate responses to queries executed over the second data table;
in response to successfully setting the status, executing, by the first database system, one or more operations to commit changes to the primary record; and
selectively setting, by the second database system, the status to one of a first final status and a second final status.

### Claim 2 (depends on 1)

The method of claim 1, wherein the pending status comprises an invalidate pending status and one of:
the first final status comprises an invalid status that is set in response to determining that the changes to the primary record are successfully committed; and
the first final status comprises a valid status that is set in response to determining that the changes to the primary record failed to be committed.

### Claim 3 (depends on 1)

The method of claim 1, wherein the pending status comprises a validate pending status and one of:
the second final status comprises a valid status that is set in response to determining that the changes to the primary record are successfully committed; and
the second final status comprises an invalid status that is set in response to determining that the changes to the primary record failed to be committed.

### Claim 4 (depends on 1)

The method of claim 1, wherein execution of the second sub-transaction results in one of adding the secondary record to the secondary database and deleting the secondary record from the secondary database.

### Claim 5 (depends on 1)

The method of claim 1, wherein selectively setting the status to one of a first final status and a second final status comprises at least one retry to set the status to one of a first final status and a second final status.

### Claim 6 (depends on 1)

The method of claim 1, wherein the primary record and the secondary record are representative of an entity.

### Claim 7 (depends on 1)

The method of claim 1, wherein the first database comprises a relational database management system (RDBMS) database and the second database comprises a non-RDBMS database.

### Claim 8

A non-transitory computer-readable storage medium coupled to one or more processors and having instructions stored thereon which, when executed by the one or more processors, cause the one or more processors to perform operations for executing global transactions that impact records in multiple, disparate database systems, the operations comprising:
executing, by a first database system, a first sub-transaction of a global transaction, the first sub-transaction impacting a primary record of a first data table stored within a first database of the database system;
in response to successful execution of the first sub-transaction, executing, by a second database system, a second sub-transaction comprising setting a status of a secondary record to a pending status in a status column of a second data table that stores the secondary record, the pending status inhibiting the second record from being used to generate responses to queries executed over the second data table;
in response to successfully setting the status, executing, by the first database system, one or more operations to commit changes to the primary record; and
selectively setting, by the second database system, the status to one of a first final status and a second final status.

### Claim 9 (depends on 8)

The non-transitory computer-readable storage medium of claim 8, wherein the pending status comprises an invalidate pending status and one of:
the first final status comprises an invalid status that is set in response to determining that the changes to the primary record are successfully committed; and
the first final status comprises a valid status that is set in response to determining that the changes to the primary record failed to be committed.

### Claim 10 (depends on 8)

The non-transitory computer-readable storage medium of claim 8, wherein the pending status comprises a validate pending status and one of:
the second final status comprises a valid status that is set in response to determining that the changes to the primary record are successfully committed; and
the second final status comprises an invalid status that is set in response to determining that the changes to the primary record failed to be committed.

### Claim 11 (depends on 8)

The non-transitory computer-readable storage medium of claim 8, wherein execution of the second sub-transaction results in one of adding the secondary record to the secondary database and deleting the secondary record from the secondary database.

### Claim 12 (depends on 8)

The non-transitory computer-readable storage medium of claim 8, wherein selectively setting the status to one of a first final status and a second final status comprises at least one retry to set the status to one of a first final status and a second final status.

### Claim 13 (depends on 8)

The non-transitory computer-readable storage medium of claim 8, wherein the primary record and the secondary record are representative of an entity.

### Claim 14 (depends on 8)

The non-transitory computer-readable storage medium of claim 8, wherein the first database comprises a relational database management system (RDBMS) database and the second database comprises a non-RDBMS database.

### Claim 15

A system, comprising:
computing device; and
non-transitory computer-readable storage devices coupled to the computing devices and having instructions stored thereon which, when executed by the computing devices, cause the computing devices to perform operations for executing global transactions that impact records in multiple, disparate database systems, the operations comprising:
executing, by a first database system, a first sub-transaction of a global transaction, the first sub-transaction impacting a primary record of a first data table stored within a first database of the database system;
in response to successful execution of the first sub-transaction, executing, by a second database system, a second sub-transaction comprising setting a status of a secondary record to a pending status in a status column of a second data table that stores the secondary record, the pending status inhibiting the second record from being used to generate responses to queries executed over the second data table;
in response to successfully setting the status, executing, by the first database system, one or more operations to commit changes to the primary record; and
selectively setting, by the second database system, the status to one of a first final status and a second final status.

### Claim 16 (depends on 15)

The system of claim 15, wherein the pending status comprises an invalidate pending status and one of:
the first final status comprises an invalid status that is set in response to determining that the changes to the primary record are successfully committed; and
the first final status comprises a valid status that is set in response to determining that the changes to the primary record failed to be committed.

### Claim 17 (depends on 15)

The system of claim 15, wherein the pending status comprises a validate pending status and one of:
the second final status comprises a valid status that is set in response to determining that the changes to the primary record are successfully committed; and
the second final status comprises an invalid status that is set in response to determining that the changes to the primary record failed to be committed.

### Claim 18 (depends on 15)

The system of claim 15, wherein execution of the second sub-transaction results in one of adding the secondary record to the secondary database and deleting the secondary record from the secondary database.

### Claim 19 (depends on 15)

The system of claim 15, wherein selectively setting the status to one of a first final status and a second final status comprises at least one retry to set the status to one of a first final status and a second final status.

### Claim 20 (depends on 15)

The system of claim 15, wherein the primary record and the secondary record are representative of an entity.