Patent · US Active

Temporary locking mechanism with shared assignment table

US12141120B1 · kind B1 · utility

0Cited by

6References

20Claims

0Family size

Assignee

SAP SE · DE

Inventors

Thomas Werth · Arlington, US
Juliane Wagner · Angelbachtal, DE
Jibi Joseph Vadakayil · St. Leon-Rot, DE
Stefan Siebert · Hockenheim, DE

Key dates

Filing date	May 5, 2023
Grant date	Nov 12, 2024
Priority date	—
Expiry date	May 5, 2043

Classification

Technology area (CPC G)Physics
CPC primaryG06F16/2343
WIPO fieldComputer technology
WIPO sectorElectrical engineering

Abstract

The example embodiments are directed to systems and methods of a locking mechanism for a database which permits a partial quantity assignment of a data item to a database request. In one example, the method may include receiving a database request comprising a requested quantity value of a data item, setting an exclusive lock on the data item within a database, protecting the requested quantity value by posting a TQA to a table, wherein the TQA comprises an identifier of the requested quantity value, an identifier of the database request, and a timestamp, releasing the exclusive lock for the database request on the data item within the database in response to recording the TQA, and with the exclusive lock released, determining a quantity value of the data item which is available for the database request and confirming the determined quantity via the temporary quantity assignment table.

Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.