-
公开(公告)号:US10853351B2
公开(公告)日:2020-12-01
申请号:US15457945
申请日:2017-03-13
Applicant: SAP SE
Inventor: Franz Faerber , Juchang Lee , Ivan Schreter
IPC: G06F7/00 , G06F17/00 , G06F16/23 , G06F16/27 , G06F16/28 , G06F16/16 , G06F16/22 , G06F16/174 , G06F3/06
Abstract: A system and method of logless atomic data movement. An internal transaction is started within a multi-level storage architecture, the internal transaction to merge data from the first level storage structure to the second level storage structure. Committed data is read from a first level storage structure of the multi-level storage architecture as specified by the internal transaction. The committed data from the first level storage structure is inserted into a second level storage structure in a bulk insertion process, and the committed data is marked as being deleted from the first level storage. The internal transaction is then committed to the multi-level storage architecture when the committed data has been inserted into the second level storage structure.
-
公开(公告)号:US20200183929A1
公开(公告)日:2020-06-11
申请号:US16715882
申请日:2019-12-16
Applicant: SAP SE
Inventor: Chul Won Lee , Juchang Lee , Myunggon Park , Wonyoung Kwak , Jeong Hee Won , Ki Hong Kim , Kyu Hwan Kim , Beomsoo Kim
IPC: G06F16/2453 , G06F16/21 , G06F16/17 , G06F16/13 , G06F16/11
Abstract: Technologies are described for facilitating data workload capture, workload replay, and comparing the performance of a plurality of database systems. A plurality of requests for database operations are received from one or more database clients. The requests for database operations are executed. For the plurality of requests for database operations, execution context information is generated for a plurality of execution contexts. For the plurality of requests for database operations, a plurality of performance measures are generated. The execution context information and the performance measures are stored in a workload capture store, such as a file. The workload capture file is useable to replay the captured workload at a second database system using at least a portion of the execution context information and at least a portion of the performance measures.
-
公开(公告)号:US10664465B2
公开(公告)日:2020-05-26
申请号:US15944429
申请日:2018-04-03
Applicant: SAP SE
Inventor: Juchang Lee , Chang Gyoo Park , Hyoung Jun Na
Abstract: Techniques are described for use in database and data management systems to efficiently capture and replicate changes that occur in database tables. The changes are captured in a transaction-consistent order, and in a format that may easily be searched and accessed using common relational queries.
-
公开(公告)号:US10592528B2
公开(公告)日:2020-03-17
申请号:US15442838
申请日:2017-02-27
Applicant: SAP SE
Inventor: Chul Won Lee , Juchang Lee , Hyogi Jung
Abstract: A computer implemented method is provided for capturing and replaying a database workload by obtaining a workload capture file comprising execution context information generated in a database system and replayable to replicate the workload, generating a modified workload capture file by generating modified execution context information, replaying the modified workload capture file by generating at least one read statement based on the modified workload execution information and issuing at least one read statement to a primary database system having an associated secondary database system, determining that the at least one read statement may be routed to the secondary database system for execution, and routing the read statement to the secondary database system for execution. Related apparatus, systems, techniques and articles are also described.
-
公开(公告)号:US10452636B2
公开(公告)日:2019-10-22
申请号:US15361760
申请日:2016-11-28
Applicant: SAP SE
Inventor: Kyu Hwan Kim , Juchang Lee , Beomsoo Kim , Chang Gyoo Park , Reiner Singer , Christoph Rottering , Werner Thesing , Michael Muehle
IPC: G06F16/00 , G06F16/23 , G06F16/245 , G06F16/27
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.
-
公开(公告)号:US10402285B2
公开(公告)日:2019-09-03
申请号:US15260943
申请日:2016-09-09
Applicant: SAP SE
Inventor: Juchang Lee , Chang Gyoo Park
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.
-
公开(公告)号:US20190243823A1
公开(公告)日:2019-08-08
申请号:US16386776
申请日:2019-04-17
Applicant: SAP SE
Inventor: Juchang Lee , Chang Gyoo Park , Hyejeong Lee
IPC: G06F16/23 , G06F16/2455 , G06F16/27 , G06F11/14 , G06F11/00
CPC classification number: G06F16/2379 , G06F11/00 , G06F11/14 , G06F11/1474 , G06F16/2455 , G06F16/273 , G06F2201/80
Abstract: 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.
-
公开(公告)号:US20190213203A1
公开(公告)日:2019-07-11
申请号:US16351001
申请日:2019-03-12
Applicant: SAP SE
Inventor: Juchang Lee , Chang Gyoo Park , Kyu Hwan Kim , Deok Koo Kim
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.
-
公开(公告)号:US10303679B2
公开(公告)日:2019-05-28
申请号:US14945296
申请日:2015-11-18
Applicant: SAP SE
Inventor: Juchang Lee , Chang Gyoo Park , Hyejeong Lee
Abstract: 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.
-
公开(公告)号:US20180349430A1
公开(公告)日:2018-12-06
申请号:US15611156
申请日:2017-06-01
Applicant: SAP SE
Inventor: Juchang Lee , Deok Koo Kim , Chang Gyoo Park , Nosub Sung
IPC: G06F17/30
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.
-
-
-
-
-
-
-
-
-