-
公开(公告)号:US10095764B2
公开(公告)日:2018-10-09
申请号:US14871675
申请日:2015-09-30
Applicant: SAP SE
Inventor: Chang Gyoo Park , Juchang Lee , Kyu Hwan Kim , Hyoung Jun Na , Hyejeong Lee
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.
-
公开(公告)号:US20170357576A1
公开(公告)日:2017-12-14
申请号:US15231566
申请日:2016-08-08
Applicant: SAP SE
Inventor: Juchang Lee , Chang Gyoo Park , Jaeyun Noh , Sung Heun Wi
IPC: G06F12/02
CPC classification number: G06F12/0253 , G06F3/0619 , G06F3/0641 , G06F3/065 , G06F3/067 , G06F12/0261 , G06F12/0269 , G06F16/2322 , G06F16/2329 , G06F2212/1044 , G06F2212/702
Abstract: Technologies for performing garbage collection in database systems, such as multi-version concurrency control (MVCC) database systems, are described. For example, different garbage collection techniques can be used separately or in various combinations, including interval garbage collection, group garbage collection, table garbage collection, and combinations. For example, a particular type of combination, called hybrid garbage collection, uses technique from interval garbage collection and group garbage collection, or from interval, group, and table garbage collection.
-
公开(公告)号:US20160371356A1
公开(公告)日:2016-12-22
申请号:US14866449
申请日:2015-09-25
Applicant: SAP SE
Inventor: Juchang Lee , Chang Gyoo Park , Kyu Hwan Kim , Deok Koo Kim
IPC: G06F17/30
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值转发到至少第二个工作节点。
-
公开(公告)号:US10860612B2
公开(公告)日:2020-12-08
申请号:US16014935
申请日:2018-06-21
Applicant: SAP SE
Inventor: Juchang Lee , Hyoung Jun Na , Kyu Hwan Kim , Deok Hoe Kim , Chang Gyoo Park
IPC: G06F16/27 , G06F11/14 , G06F3/06 , G06F16/17 , G06F16/182 , G06F16/2453 , G06F16/2455
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.
-
公开(公告)号:US10795881B2
公开(公告)日:2020-10-06
申请号:US14975365
申请日:2015-12-18
Applicant: SAP SE
Inventor: Juchang Lee , Chang Gyoo Park , Kyu Hwan Kim , Hyoung Jun Na , Deok Koo Kim , Joo Yeon Lee
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.
-
公开(公告)号:US20190236081A1
公开(公告)日:2019-08-01
申请号:US16376963
申请日:2019-04-05
Applicant: SAP SE
Inventor: Chang Gyoo Park , Deok Koo Kim , Kyu Hwan Kim , Juchang Lee
IPC: G06F16/27 , G06F16/2458 , G06F16/23 , G06F16/951 , G06F16/28
CPC classification number: G06F16/273 , G06F11/1451 , G06F16/2343 , G06F16/2379 , G06F16/2471 , G06F16/285 , G06F16/951
Abstract: Technologies are described for performing synchronization within a database environment. A source host stores multiple database tables and a replica host stores copies of the multiple database tables. During synchronization, replication log replay is blocked at the replica node, and a multithreaded process locks the multiple database tables of the source hosts, reactivates replication log generation for each of the multiple database tables, and then unlocks the database tables. A synchronization timestamp is acquired and used to synchronize the multiple database tables with the copies of the multiple database tables. After synchronization, replication log replay is reactivated at the replica host for the copies of the multiple database tables.
-
公开(公告)号:US20190222658A1
公开(公告)日:2019-07-18
申请号:US16362286
申请日:2019-03-22
Applicant: SAP SE
Inventor: Chang Gyoo Park , Juchang Lee , Kyu Hwan Kim , Chul Won Lee , Myunggon Park , Eunjin Song , Nosub Sung
IPC: H04L29/08 , G06F16/2455 , G06F16/20
CPC classification number: H04L67/22 , G06F16/20 , G06F16/2455 , H04L45/742
Abstract: Technologies are described for facilitating replay of requests for database operations. A plurality of requests for database operations are received. Each of the plurality of requests includes a type, an access unit identifier, and a chronological identifier. Execution dependencies are determined between the plurality of requests based on the type, access unit identifier, and chronological identifier of each of the plurality of requests. The execution dependencies are stored.
-
公开(公告)号:US10346298B2
公开(公告)日:2019-07-09
申请号:US15231553
申请日:2016-08-08
Applicant: SAP SE
Inventor: Juchang Lee , Chang Gyoo Park , Jaeyun Noh , Wolfgang Stephan , Hyungyu Shin , Seongyun Ko
Abstract: Technologies for performing garbage collection in database systems, such as multi-version concurrency control (MVCC) database systems, are described. For example, different garbage collection techniques can be used separately or in various combinations, including interval garbage collection, group garbage collection, table garbage collection, and combinations. For example, a particular type of combination, called hybrid garbage collection, uses technique from interval garbage collection and group garbage collection, or from interval, group, and table garbage collection.
-
公开(公告)号:US20190005105A1
公开(公告)日:2019-01-03
申请号:US16122617
申请日:2018-09-05
Applicant: SAP SE
Inventor: Chang Gyoo Park , Juchang Lee , Kyu Hwan Kim , Hyoung Jun Na , Hyejeong Lee
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.
-
公开(公告)号:US10169439B2
公开(公告)日:2019-01-01
申请号:US14871717
申请日:2015-09-30
Applicant: SAP SE
Inventor: Juchang Lee , Chang Gyoo Park , Hyoung Jun Na
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.
-
-
-
-
-
-
-
-
-