US 12,625,861 B2Granted

Future transaction processing

AssigneeOracle International Corporation

InventorsDouglas Ray Cosby, Anurag Garg, Byron Kevin McKenzie

Life of this patent

Estimating the term…

Loading patent…

Abstract

Techniques for managing requests to modify a data set at future times are disclosed. The system receives a request to modify the data set at a future time, such as in a future time window. The system generates a representation of the data set at the future time. The system determines the future state of the data set based on the current state of the data set and requested future modifications to the data set. The system determines whether a conflict exists between the request to modify the data set at the future time and another scheduled request to modify the data set at the future time. Based on determining whether a conflict exists, the system performs one or more of scheduling the request to modify the data set at the future time and performing a remediation action to address the conflict.

Claims27

Dependent claims

One or more non-transitory computer readable media comprising instructions which, when executed by one or more hardware processors, cause performance of operations comprising:

receiving by a database server a first request corresponding to a first database transaction for modifying a first database record;
determining, by the database server, a first present state of a first set of one or more database records including the first database record at a first moment in time at least by:
querying a database, comprising the first set of one or more database records, to identify the first present state of the first set of one or more database records;
determining, by the database server in real-time and in response to receiving the first request, whether the first database transaction conflicts with the first present state of the first set of one or more database records;
based on determining the first database transaction does not conflict with the first present state of the first set of one or more database records, (a) refraining from performing any remediation action by the database server and (b) storing, by the database server, the first request to perform the first database transaction in a first queue;
receiving, by the database server, a second request corresponding to a second database transaction for adding, modifying, or deleting at least one database record in the database;
while the first request is stored in the first queue and in response to receiving the second request:
executing, by the database server, the second database transaction for adding, modifying, or deleting the at least one database record;
while the first request is stored in the first queue and subsequent to executing the second request, determining, by the database server, a second present state of a second set of one or more database records at a second moment in time subsequent to the first moment in time, wherein the second present state of the second set of one or more database records is based at least in part on the adding, modifying, or deleting of the at least one database record;
determining, by the database server, whether the first database transaction conflicts with the second present state of the second set of one or more database records;
and
based on determining the first database transaction conflicts with the second present state of the second set of one or more database records:
applying, by the database server, a set of conflict remediation rules to the first request to perform a remediation action corresponding to the first request.

10 more elements

A method, comprising:

receiving by a database server a first request corresponding to a first database transaction for modifying a first database record;
determining, by the database server, a first present state of a first set of one or more database records including the first database record at a first moment in time at least by:
querying a database, comprising the first set of one or more database records, to identify the first present state of the first set of one or more database records;
determining, by the database server in real-time and in response to receiving the first request, whether the first database transaction conflicts with the first present state of the first set of one or more database records;
based on determining the first database transaction does not conflict with the first present state of the first set of one or more database records, (a) refraining from performing any remediation action by the database server and (b) storing, by the database server, the first request to perform the first database transaction in a first queue;
receiving, by the database server, a second request corresponding to a second database transaction for adding, modifying, or deleting at least one database record in the database;
while the first request is stored in the first queue and in response to receiving the second request:
executing, by the database server, the second database transaction for adding, modifying, or deleting the at least one database record;
while the first request is stored in the first queue and subsequent to executing the second request, determining, by the database server, a second present state of a second set of one or more database records at a second moment in time subsequent to the first moment in time, wherein the second present state of the second set of one or more database records is based at least in part on the adding, modifying, or deleting of the at least one database record;
determining, by the database server, whether the first database transaction conflicts with the second present state of the second set of one or more database records;
and
based on determining the first database transaction conflicts with the second present state of the second set of one or more database records:
applying, by the database server, a set of conflict remediation rules to the first request to perform a remediation action corresponding to the first request.

10 more elements

A system comprising:

at least one device including a hardware processor, the system being configured to perform operations comprising:
receiving by a database server a first request corresponding to a first database transaction for modifying a first database record;
determining, by the database server, a first present state of a first set of one or more database records including the first database record at a first moment in time at least by:
querying a database, comprising the first set of one or more database records, to identify the first present state of the first set of one or more database records;
determining, by the database server in real-time and in response to receiving the first request, whether the first database transaction conflicts with the first present state of the first set of one or more database records;
based on determining the first database transaction does not conflict with the first present state of the first set of one or more database records, (a) refraining from performing any remediation action by the database server and (b) storing, by the database server, the first request to perform the first database transaction in a first queue;
receiving, by the database server, a second request corresponding to a second database transaction for adding, modifying, or deleting at least one database record in the database;
while the first request is stored in the first queue and in response to receiving the second request:
executing, by the database server, the second database transaction for adding, modifying, or deleting the at least one database record;
while the first request is stored in the first queue and subsequent to executing the second request, determining, by the database server, a second present state of a second set of one or more database records at a second moment in time subsequent to the first moment in time, wherein the second present state of the second set of one or more database records is based at least in part on the adding, modifying, or deleting of the at least one database record;
determining, by the database server, whether the first database transaction conflicts with the second present state of the second set of one or more database records;
and
based on determining the first database transaction conflicts with the second present state of the second set of one or more database records:
applying, by the database server, a set of conflict remediation rules to the first request to perform a remediation action corresponding to the first request.

11 more elements

Dependencies are inferred from the claim text.

Facts

Application: 18/787,034Filed 29 Jul 2024 · continuation
Priority: 26 Jan 2022
Published: US 2024/0386011 A121 Nov 2024
Granted: 12 May 2026
Term ends: Not estimatedThe source records don’t support an estimate.

Classification3 codes

G06F 16/2372
Updating: updates performed during offline database operations
G06F 16/2322
Optimistic concurrency control: using timestamps
G06F
Computing and data processing

Family

Application63/303,251Us provisional application · filed 26 Jan 2022
Application17/861,579Parent of this continuation · filed 11 Jul 2022
US 2024/0386011 A1Pre-grant publication · published 21 Nov 2024
US 12,072,867 B2Parent of this continuation
US 2023/0259505 A1Published application
US 12,625,861 B2This patent

From the US filing history. Foreign family members aren’t listed.