-
1.
公开(公告)号:US20200320051A1
公开(公告)日:2020-10-08
申请号:US16372644
申请日:2019-04-02
申请人: SAP SE
发明人: Juchang Lee , Hyejeong Lee , Kyu Hwan Kim , Friedrich Keller , Mihnea Andrei
摘要: 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.
-
公开(公告)号:US10545995B2
公开(公告)日:2020-01-28
申请号:US15601008
申请日:2017-05-22
申请人: SAP SE
发明人: Juchang Lee , Chang Gyoo Park , Hyejeong Lee , Kyu Hwan Kim , Mihnea Andrei
摘要: 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.
-
公开(公告)号:US20190243823A1
公开(公告)日:2019-08-08
申请号:US16386776
申请日:2019-04-17
申请人: SAP SE
发明人: Juchang Lee , Chang Gyoo Park , Hyejeong Lee
IPC分类号: G06F16/23 , G06F16/2455 , G06F16/27 , G06F11/14 , G06F11/00
CPC分类号: G06F16/2379 , G06F11/00 , G06F11/14 , G06F11/1474 , G06F16/2455 , G06F16/273 , G06F2201/80
摘要: Technologies are provided for reducing or eliminating transaction consistency anomalies that can occur during data replication, such as during database table replication. For example, commit values can be used to coordinate requests so that the requests are not performed on database tables with inconsistent data.
-
公开(公告)号:US10303679B2
公开(公告)日:2019-05-28
申请号:US14945296
申请日:2015-11-18
申请人: SAP SE
发明人: Juchang Lee , Chang Gyoo Park , Hyejeong Lee
摘要: Technologies are provided for reducing or eliminating transaction consistency anomalies that can occur during data replication, such as during database table replication. For example, commit values can be used to coordinate requests so that the requests are not performed on database tables with inconsistent data.
-
公开(公告)号:US11347705B2
公开(公告)日:2022-05-31
申请号:US16372644
申请日:2019-04-02
申请人: SAP SE
发明人: Juchang Lee , Hyejeong Lee , Kyu Hwan Kim , Friedrich Keller , Mihnea Andrei
摘要: 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.
-
公开(公告)号:US20180336258A1
公开(公告)日:2018-11-22
申请号:US15601008
申请日:2017-05-22
申请人: SAP SE
发明人: Juchang Lee , Chang Gyoo Park , Hyejeong Lee , Kyu Hwan Kim , Mihnea Andrei
IPC分类号: G06F17/30
CPC分类号: G06F16/273 , G06F11/36 , G06F16/219 , G06F16/2358 , G06F16/2379 , G06F16/2455
摘要: 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.
-
公开(公告)号:US10095764B2
公开(公告)日:2018-10-09
申请号:US14871675
申请日:2015-09-30
申请人: SAP SE
发明人: Chang Gyoo Park , Juchang Lee , Kyu Hwan Kim , Hyoung Jun Na , Hyejeong Lee
摘要: 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.
-
公开(公告)号:US20190005105A1
公开(公告)日:2019-01-03
申请号:US16122617
申请日:2018-09-05
申请人: SAP SE
发明人: Chang Gyoo Park , Juchang Lee , Kyu Hwan Kim , Hyoung Jun Na , Hyejeong Lee
摘要: 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.
-
公开(公告)号:US10997161B2
公开(公告)日:2021-05-04
申请号:US16386776
申请日:2019-04-17
申请人: SAP SE
发明人: Juchang Lee , Chang Gyoo Park , Hyejeong Lee
摘要: Technologies are provided for reducing or eliminating transaction consistency anomalies that can occur during data replication, such as during database table replication. For example, commit values can be used to coordinate requests so that the requests are not performed on database tables with inconsistent data.
-
公开(公告)号:US09965360B2
公开(公告)日:2018-05-08
申请号:US14657938
申请日:2015-03-13
申请人: SAP SE
发明人: Juchang Lee , Kyu-Hwan Kim , Hyoung-Jun Na , Chang-Gyoo Park , Hyejeong Lee
CPC分类号: G06F11/1469 , G06F11/1464 , G06F17/30368 , G06F17/30371 , G06F17/30377 , G06F17/30575 , G06F17/30578 , G06F17/30876 , G06F2201/80
摘要: Disclosed herein are system, method, and computer program product embodiments for synchronizing lost change between a source table and a replica table. An embodiment operates by detecting a restart at a source node or a replica node. Row-ID values of replication log entries are then compared to row-ID column values of rows at a replica table of the replica node. Replication errors at a source table or the replica table are then determined based on the row-ID comparison. The rows of the source table and the replica table are then updated based on the determination.
-
-
-
-
-
-
-
-
-