SUPPORTING SCALABLE DISTRIBUTED SECONDARY INDEX USING REPLICATION ENGINE FOR HIGH-PERFORMANCE DISTRIBUTED DATABASE SYSTEMS

    公开(公告)号:US20200320051A1

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

    申请号:US16372644

    申请日:2019-04-02

    申请人: SAP SE

    IPC分类号: G06F16/22 G06F16/27

    摘要: Implementations of the present disclosure include providing, at each node in a set of nodes of a database system, a table partition of a plurality of table partitions, the plurality of table partitions being provided by partitioning a table using a primary key, providing, at each node in the set of nodes of the database system, a secondary index partition of a plurality of secondary index partitions, each secondary index partition including a replicate table of at least a portion of the table, the plurality of secondary index partitions being provided by partitioning the table using one or more secondary keys, and for at least one operation executed on a table partition, executing a replication protocol to replicate the at least one operation on a secondary index partition that corresponds to the table partition.

    Validating query results during asynchronous database replication

    公开(公告)号:US10545995B2

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

    申请号:US15601008

    申请日:2017-05-22

    申请人: SAP SE

    摘要: An oldest version timestamp is received from a first database. A current commit timestamp is received from a second database configured to asynchronously replicate the first database. The current global commit timestamp corresponds to a commit transaction executed in the first database and subsequently replicated in the second database. A first test query is then issued to the second database including a request for a current timestamp of the second database. A second test query is issued to the primary database requesting records associated with a target update version that has a target timestamp equal to the current snapshot timestamp. A determination is then made that a first return associated with the first test query and a second return associated with the second test query are identical indicating a successful validation. Related apparatus, systems, techniques and articles are also described.

    Supporting scalable distributed secondary index using replication engine for high-performance distributed database systems

    公开(公告)号:US11347705B2

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

    申请号:US16372644

    申请日:2019-04-02

    申请人: SAP SE

    IPC分类号: G06F16/22 G06F16/27

    摘要: Implementations of the present disclosure include providing, at each node in a set of nodes of a database system, a table partition of a plurality of table partitions, the plurality of table partitions being provided by partitioning a table using a primary key, providing, at each node in the set of nodes of the database system, a secondary index partition of a plurality of secondary index partitions, each secondary index partition including a replicate table of at least a portion of the table, the plurality of secondary index partitions being provided by partitioning the table using one or more secondary keys, and for at least one operation executed on a table partition, executing a replication protocol to replicate the at least one operation on a secondary index partition that corresponds to the table partition.

    Validating Query Results During Asynchronous Database Replication

    公开(公告)号:US20180336258A1

    公开(公告)日:2018-11-22

    申请号:US15601008

    申请日:2017-05-22

    申请人: SAP SE

    IPC分类号: G06F17/30

    摘要: An oldest version timestamp is received from a first database. A current commit timestamp is received from a second database configured to asynchronously replicate the first database. The current global commit timestamp corresponds to a commit transaction executed in the first database and subsequently replicated in the second database. A first test query is then issued to the second database including a request for a current timestamp of the second database. A second test query is issued to the primary database requesting records associated with a target update version that has a target timestamp equal to the current snapshot timestamp. A determination is then made that a first return associated with the first test query and a second return associated with the second test query are identical indicating a successful validation. Related apparatus, systems, techniques and articles are also described.

    Multi-replica asynchronous table replication

    公开(公告)号:US10095764B2

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

    申请号:US14871675

    申请日:2015-09-30

    申请人: SAP SE

    IPC分类号: G06F17/30 G06F11/14

    摘要: 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-REPLICA ASYNCHRONOUS TABLE REPLICATION

    公开(公告)号:US20190005105A1

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

    申请号:US16122617

    申请日:2018-09-05

    申请人: SAP SE

    IPC分类号: G06F17/30 G06F11/14

    摘要: 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.