US 12,105,698 B1
Temporary locking mechanism with shared assignment table
Thomas Werth, Speyer (DE); Juliane Wagner, Angelbachtal (DE); Jibi Joseph Vadakayil, Sankt Leon Rot (IN); and Stefan Siebert, Hockenheim (DE)
Assigned to SAP SE, Walldorf (DE)
Filed by SAP SE, Walldorf (DE)
Filed on May 5, 2023, as Appl. No. 18/312,686.
Int. Cl. G06F 17/30 (2006.01); G06F 16/23 (2019.01)
CPC G06F 16/2343 (2019.01) 20 Claims
OG exemplary drawing
 
1. A computing system comprising:
a processor configured to:
receive a database request comprising a requested quantity value of a data item,
determine a unique database request timestamp specific to the database request,
set an exclusive lock for the database request on the data item within a database,
protect the requested quantity value by posting a temporary quantity assignment (TQA) for the database request to a table, wherein the TQA comprises an identifier of the requested quantity value, an identifier of the database request, and a TQA timestamp,
release 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, determine a quantity value of the data item which is available for the database request and confirm the determined quantity via the temporary quantity assignment table.