Client-driven commit of distributed write transactions in a database environment

    公开(公告)号:US10936578B2

    公开(公告)日:2021-03-02

    申请号:US15611156

    申请日:2017-06-01

    Applicant: SAP SE

    Abstract: Technologies are described for facilitating transaction processing in a distributed database environment. A database client sends database operations to a slave node, which mediates execution of the transaction. A connection between the database client and the slave node is associated with an identifier, and the transaction has an identifier. The database client sends a commit request to a master node over a network connection between the master node and the database client. The commit request includes the transaction identifier. The commit request can also include an indication of database nodes executing operations in the transaction.

    Delayed snapshot isolation for read service at a database

    公开(公告)号:US10452636B2

    公开(公告)日:2019-10-22

    申请号:US15361760

    申请日:2016-11-28

    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.

    Hybrid database concurrent transaction control

    公开(公告)号:US10402285B2

    公开(公告)日:2019-09-03

    申请号:US15260943

    申请日:2016-09-09

    Applicant: SAP SE

    Abstract: A plurality of database modification statements are received as part of a database transaction that implicates data stored within a database. Thereafter, lock requests are initiated that requesting the database to lock the implicated data. At least one database operation by at least one of the database modification statements is then executed prior to receiving responses from at least a portion of the lock requests. After confirming that prior lock requests made by the transaction are successfully processed, a commit to make changes to the corresponding implicated data permanent is initiated. The implicated data can then be caused to be unlocked after the commit completes. Related apparatus, systems, techniques and articles are also described.

    DISTRIBUTED DATABASE TRANSACTION PROTOCOL
    7.
    发明申请

    公开(公告)号:US20190213203A1

    公开(公告)日:2019-07-11

    申请号:US16351001

    申请日:2019-03-12

    Applicant: SAP SE

    CPC classification number: G06F16/273 G06F16/2379

    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.

    CLIENT-DRIVEN COMMIT OF DISTRIBUTED WRITE TRANSACTIONS IN A DATABASE ENVIRONMENT

    公开(公告)号:US20180349430A1

    公开(公告)日:2018-12-06

    申请号:US15611156

    申请日:2017-06-01

    Applicant: SAP SE

    Abstract: Technologies are described for facilitating transaction processing in a distributed database environment. A database client sends database operations to a slave node, which mediates execution of the transaction. A connection between the database client and the slave node is associated with an identifier, and the transaction has an identifier. The database client sends a commit request to a master node over a network connection between the master node and the database client. The commit request includes the transaction identifier. The commit request can also include an indication of database nodes executing operations in the transaction.

    MULTI-SOURCE ASYNCHRONOUS TABLE REPLICATION
    10.
    发明申请
    MULTI-SOURCE ASYNCHRONOUS TABLE REPLICATION 审中-公开
    多源非线性表复制

    公开(公告)号:US20160371358A1

    公开(公告)日:2016-12-22

    申请号:US14871717

    申请日:2015-09-30

    Applicant: SAP SE

    Abstract: Technologies are described for performing replication within a database environment. Where database operations are carried out at multiple source nodes, the operations can be ordered by the source node on which they were executable prior to being replayed at a replica node. In addition, the operations can be precommitted, so that the operations can be reviewed by a replayer at the replica node before the transaction containing the operations has been fully committed.

    Abstract translation: 描述了在数据库环境中执行复制的技术。 在多个源节点执行数据库操作的地方,可以在复制节点重播之前由其可执行的源节点对操作进行排序。 此外,可以预先提交操作,以便在包含操作的事务完全提交之前,操作可由复制节点上的重播者进行审核。

Patent Agency Ranking