Database lock management with cache-optimized hash table

    公开(公告)号:US11341112B2

    公开(公告)日:2022-05-24

    申请号:US16918057

    申请日:2020-07-01

    Applicant: SAP SE

    Inventor: Chang Gyoo Park

    Abstract: Lock table management is provided for a lock manager of a database system, in which lock management is provided in a manner that is fast and efficient, and that conserves processing, memory, and other computational resources. For example, the lock table management can use a hashmap in which keys and values are stored in separate arrays, which can be loaded into separate CPU cache lines.

    Delayed snapshot isolation for read service at a database

    公开(公告)号:US11200221B2

    公开(公告)日:2021-12-14

    申请号:US16576498

    申请日:2019-09-19

    Applicant: SAP SE

    Abstract: A computer implemented method is provided comprising receiving a group of transaction logs from a first database, allocating transaction logs from the group of transaction logs to a first queue and to a second queue, generating an end-of-group transaction log indicative of an end of the group of transaction logs, allocating the end-of-group log to the first queue and the second queue; replaying transaction logs from the first queue including the end-of-group transaction log allocated to the first queue, replaying transaction logs from the second queue including the end-of-group transaction log allocated to the second queue; and changing visibility of one or more transactions in response to replaying the end-of-group transaction log allocated to the first queue and the end-of-group transaction log allocated to the second queue. Related apparatus, systems, techniques and articles are also described.

    Distributed database transaction protocol

    公开(公告)号:US11003689B2

    公开(公告)日:2021-05-11

    申请号:US16351001

    申请日:2019-03-12

    Applicant: SAP SE

    Abstract: Technologies are described for facilitating transaction processing within a database environment having a coordinator node, a first worker node, and at least a second worker node. The first worker node sends a request from to the coordinator node for at least a first synchronization token maintained by the coordinator node. The first worker node receives the at least a first synchronization token from the coordinator node. The first worker node assigns the at least a first synchronization token to a snapshot as a snapshot ID value. The snapshot is executed at the first worker node. The first worker node forwards the snapshot ID value to the at least a second worker node.

    Distributed database transaction protocol

    公开(公告)号:US10572510B2

    公开(公告)日:2020-02-25

    申请号:US14977372

    申请日:2015-12-21

    Applicant: SAP SE

    Abstract: Technologies are described for facilitating transaction processing within a database environment having a coordinator node, a first worker node, and at least a second worker node. The coordinator node receives local transaction tokens from the first and the at least a second worker nodes. The coordinator nodes determines a synchronized transaction token using at least the local transaction tokens from the first and the at least a second worker nodes. The coordinator node sends the synchronized transaction token to the first and the at least a second worker nodes.

    DISTRIBUTED DATABASE TRANSACTION PROTOCOL
    57.
    发明申请

    公开(公告)号:US20200034373A1

    公开(公告)日:2020-01-30

    申请号:US16595505

    申请日:2019-10-08

    Applicant: SAP SE

    Abstract: Technologies are described for facilitating transaction processing within a database environment having a coordinator node, a first worker node, and at least a second worker node. The coordinator node receives local transaction tokens from the first and the at least a second worker nodes. The coordinator nodes determines a synchronized transaction token using at least the local transaction tokens from the first and the at least a second worker nodes. The coordinator node sends the synchronized transaction token to the first and the at least a second worker nodes.

    Delayed Snapshot Isolation for Read Service at a Database

    公开(公告)号:US20200012633A1

    公开(公告)日:2020-01-09

    申请号:US16576498

    申请日:2019-09-19

    Applicant: SAP SE

    Abstract: A computer implemented method is provided comprising receiving a group of transaction logs from a first database, allocating transaction logs from the group of transaction logs to a first queue and to a second queue, generating an end-of-group transaction log indicative of an end of the group of transaction logs, allocating the end-of-group log to the first queue and the second queue; replaying transaction logs from the first queue including the end-of-group transaction log allocated to the first queue, replaying transaction logs from the second queue including the end-of-group transaction log allocated to the second queue; and changing visibility of one or more transactions in response to replaying the end-of-group transaction log allocated to the first queue and the end-of-group transaction log allocated to the second queue. Related apparatus, systems, techniques and articles are also described.

    Distributed database transaction protocol

    公开(公告)号:US10268743B2

    公开(公告)日:2019-04-23

    申请号:US14866449

    申请日:2015-09-25

    Applicant: SAP SE

    Abstract: Technologies are described for facilitating transaction processing within a database environment having a coordinator node, a first worker node, and at least a second worker node. The first worker node sends a request from to the coordinator node for at least a first synchronization token maintained by the coordinator node. The first worker node receives the at least a first synchronization token from the coordinator node. The first worker node assigns the at least a first synchronization token to a snapshot as a snapshot ID value. The snapshot is executed at the first worker node. The first worker node forwards the snapshot ID value to the at least a second worker node.

Patent Agency Ranking