Temporary locking mechanism with shared assignment table

    公开(公告)号:US12105698B1

    公开(公告)日:2024-10-01

    申请号:US18312686

    申请日:2023-05-05

    Applicant: SAP SE

    CPC classification number: G06F16/2343

    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.

    Temporary locking mechanism with shared assignment table

    公开(公告)号:US12141120B1

    公开(公告)日:2024-11-12

    申请号:US18312686

    申请日:2023-05-05

    Applicant: SAP SE

    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.

Patent Agency Ranking