Synchronization Mechanism for Serialized Data Log Replay in Database Systems

    公开(公告)号:US20180150540A1

    公开(公告)日:2018-05-31

    申请号:US15409234

    申请日:2017-01-18

    Applicant: SAP SE

    Abstract: A computer implemented method for updating a secondary database includes receiving transaction log information from a primary database system at a secondary database system. The transaction log information comprises a first marker identifying a beginning of an operation comprising a plurality of sub-operations and a second marker identifying an end of the operation. The transaction log information is sequentially parsed, a first marker is identified, and a lock state is created after replaying the first marker to ensure proper serialization of the plurality of sub-operations. The lock state is terminated after replaying the second marker. Related apparatus, systems, techniques and articles are also described.

    ATOMIC PROCESSING OF COMPOUND DATABASE TRANSACTIONS THAT MODIFY A METADATA ENTITY

    公开(公告)号:US20200257672A1

    公开(公告)日:2020-08-13

    申请号:US16730528

    申请日:2019-12-30

    Applicant: SAP SE

    Abstract: Technologies are described for facilitating transaction processing within a database environment. A commit protocol provides for the atomic commit or rollback of a transaction that includes an operation that modifies a metadata entity of the database system and one or more other operations that modify metadata entities or data records of the database system. Innovations are provided for detecting and resolving deadlocks that may arise during transaction processing. Innovations are also provided for providing versioning of metadata entities, including invalidating metadata entities cached at a slave node during the commit at a master node of a transaction that creates a new version of the metadata entity.

    Atomic processing of compound database transactions that modify a metadata entity

    公开(公告)号:US10585873B2

    公开(公告)日:2020-03-10

    申请号:US15589740

    申请日:2017-05-08

    Applicant: SAP SE

    Abstract: Technologies are described for facilitating transaction processing within a database environment. A commit protocol provides for the atomic commit or rollback of a transaction that includes an operation that modifies a metadata entity of the database system and one or more other operations that modify metadata entities or data records of the database system. Innovations are provided for detecting and resolving deadlocks that may arise during transaction processing. Innovations are also provided for providing versioning of metadata entities, including invalidating metadata entities cached at a slave node during the commit at a master node of a transaction that creates a new version of the metadata entity.

    Atomic processing of compound database transactions that modify a metadata entity

    公开(公告)号:US11314716B2

    公开(公告)日:2022-04-26

    申请号:US16730528

    申请日:2019-12-30

    Applicant: SAP SE

    Abstract: Technologies are described for facilitating transaction processing within a database environment. A commit protocol provides for the atomic commit or rollback of a transaction that includes an operation that modifies a metadata entity of the database system and one or more other operations that modify metadata entities or data records of the database system. Innovations are provided for detecting and resolving deadlocks that may arise during transaction processing. Innovations are also provided for providing versioning of metadata entities, including invalidating metadata entities cached at a slave node during the commit at a master node of a transaction that creates a new version of the metadata entity.

Patent Agency Ranking