Multi-replica asynchronous table replication

    公开(公告)号:US10095764B2

    公开(公告)日:2018-10-09

    申请号:US14871675

    申请日:2015-09-30

    Applicant: SAP SE

    Abstract: Technologies are described for performing replication within a database environment. Where a database transaction is replicated at multiple replica nodes, a replica node is selected as a coordinator replica node for the transaction. The other replica node or nodes are designated as follower replica nodes for the transaction. A follower replica node sends the coordinator replica node a precommit notification when the follower replica node has precommitted the transaction. The coordinator replica node sends the follower replica node a postcommit notification to commit the transaction when the transaction has been precommitted by all of the replica nodes to which the transaction is to be replicated.

    DISTRIBUTED DATABASE TRANSACTION PROTOCOL
    23.
    发明申请
    DISTRIBUTED DATABASE TRANSACTION PROTOCOL 审中-公开
    分布式数据库交易协议

    公开(公告)号:US20160371356A1

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

    申请号:US14866449

    申请日:2015-09-25

    Applicant: SAP SE

    CPC classification number: G06F17/30578 G06F17/30377

    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.

    Abstract translation: 描述了用于促进具有协调器节点,第一工作者节点和至少第二工作节点的数据库环境内的事务处理的技术。 第一工作节点向协调器节点发送至少由协调器节点维护的第一同步令牌的请求。 第一工作节点从协调器节点接收至少一个第一同步令牌。 第一个工作节点将至少一个第一同步令牌分配给快照作为快照ID值。 快照在第一个工作节点执行。 第一个工作节点将快照ID值转发到至少第二个工作节点。

    Parallel replication across formats

    公开(公告)号:US10860612B2

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

    申请号:US16014935

    申请日:2018-06-21

    Applicant: SAP SE

    Abstract: Disclosed herein are system, method, and computer readable device embodiments for parallel replication of databases across row-store and column-store table formats. An embodiment operates by maintaining a replication log and a storage-level recovery log formatted according to separate respective log formats, logging a record-level SQL execution result, and replicating at least one database table from a primary server to at least one replica server. The primary server and the at least one replica server may each be configured to store data according to one table format of a row-store table format and a column-store table format, such that the primary server's table format is different from the at least one replica server's table format.

    Table replication in a database environment

    公开(公告)号:US10795881B2

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

    申请号:US14975365

    申请日:2015-12-18

    Applicant: SAP SE

    Abstract: Technologies are described for performing replication of data within a database environment having a source node and a replica node. The source node executes a database operation on at least one database table stored by the source node. The source node asynchronously sends the database operation to the replica node. A prepare commit request is synchronously sent from the source node to the replica node. The source node receives a synchronous precommit acknowledgement from the replica node. The precommit acknowledgement indicates that the database operation was executed at the replica node. The source node commits a transaction associated with the database operation.

    MULTI-REPLICA ASYNCHRONOUS TABLE REPLICATION
    29.
    发明申请

    公开(公告)号:US20190005105A1

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

    申请号:US16122617

    申请日:2018-09-05

    Applicant: SAP SE

    Abstract: Technologies are described for performing replication within a database environment. Where a database transaction is replicated at multiple replica nodes, a replica node is selected as a coordinator replica node for the transaction. The other replica node or nodes are designated as follower replica nodes for the transaction. A follower replica node sends the coordinator replica node a precommit notification when the follower replica node has precommitted the transaction. The coordinator replica node sends the follower replica node a postcommit notification to commit the transaction when the transaction has been precommitted by all of the replica nodes to which the transaction is to be replicated.

    Multi-source asynchronous table replication

    公开(公告)号:US10169439B2

    公开(公告)日:2019-01-01

    申请号: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.

Patent Agency Ranking