The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Nov. 12, 2024
Filed:
May. 05, 2023
Sap SE, Walldorf, DE;
Thomas Werth, Speyer, DE;
Juliane Wagner, Angelbachtal, DE;
Jibi Joseph Vadakayil, Sankt Leon Rot, IN;
Stefan Siebert, Hockenheim, DE;
SAP SE, Walldorf, DE;
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.