-
公开(公告)号:US20230401182A1
公开(公告)日:2023-12-14
申请号:US17838955
申请日:2022-06-13
Applicant: SAP SE
Inventor: Jian Luo , Qian Li , Ivan Veselinov Andreev , Joo Yeon Lee , Jonathan Bregler , Simon Lueders , Alexander Bunte , Eunsang Kim , Juchang Lee
CPC classification number: G06F16/214 , G06F16/2379 , G06F16/212
Abstract: Technologies are described for migrating deployment infrastructure containers. Deployment infrastructure containers are used for isolating and deploying related database objects together. Deployment infrastructure containers can store design-time artifacts and run-time artifacts. Deployment infrastructure containers can be migrated using a first migration technique in which catalog objects are migrated from a source database system to a target database system and updated to work in the target database system (e.g., by updating metadata). Deployment infrastructure containers can also be migrated using a second migration technique that migrates design-time artifacts and builds the design-time artifacts at the target database system to re-create the run-time artifacts. Migrated deployment infrastructure containers can be integrated into the target environment, which can include creating new service instances and associating them with the migrated deployment infrastructure containers.
-
公开(公告)号:US11734253B2
公开(公告)日:2023-08-22
申请号:US17701185
申请日:2022-03-22
Applicant: SAP SE
Inventor: Juchang Lee , Chang Gyoo Park , Hyoung Jun Na
CPC classification number: G06F16/2358 , G06F16/2282 , G06F16/27 , G06F16/284
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.
-
公开(公告)号:US11681684B2
公开(公告)日:2023-06-20
申请号:US17150868
申请日:2021-01-15
Applicant: SAP SE
Inventor: Juchang Lee , Deok Koo Kim , Chang Gyoo Park , Nosub Sung
CPC classification number: G06F16/2365 , G06F16/28
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.
-
公开(公告)号:US20220215011A1
公开(公告)日:2022-07-07
申请号:US17701185
申请日:2022-03-22
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.
-
公开(公告)号:US20220197922A1
公开(公告)日:2022-06-23
申请号:US17646982
申请日:2022-01-04
Applicant: SAP SE
Inventor: Ruediger Karl , Mihnea Andrei , Juchang Lee , Stefan Baeuerle , Seyeong Bae , Joo Yeon Lee
IPC: G06F16/25 , G06F16/23 , G06F16/22 , G06F16/2455 , G06F16/21
Abstract: Techniques and solutions are described for implementing virtual table schemas. A virtual table schema includes a logical pointer that is used to target a table that includes data and is defined according to the virtual table schema. Values assigned to the logical pointer can be used to target tables at different locations, such as in a federated database system or in a cache of a database management system of a central computing system. When data associated with the virtual table is requested, or prior to receiving the request, the data can be stored in a table in the cache. The logical pointer can be updated to reference the cache. If the cache is full, the table can be removed from the cache, and the logical pointer can be updated to reference a table at the federated database system.
-
公开(公告)号:US11294897B2
公开(公告)日:2022-04-05
申请号: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/11 , G06F16/13 , G06F16/17 , G06F16/21
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.
-
公开(公告)号:US11200221B2
公开(公告)日:2021-12-14
申请号:US16576498
申请日:2019-09-19
Applicant: SAP SE
Inventor: Kyu Hwan Kim , Juchang Lee , Beomsoo Kim , Chang Gyoo Park , Reiner Singer , Christoph Roterring , 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.
-
公开(公告)号:US11003689B2
公开(公告)日:2021-05-11
申请号:US16351001
申请日:2019-03-12
Applicant: SAP SE
Inventor: Juchang Lee , Chang Gyoo Park , Kyu Hwan Kim , Deok Koo Kim
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.
-
公开(公告)号:US10997161B2
公开(公告)日:2021-05-04
申请号:US16386776
申请日:2019-04-17
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.
-
公开(公告)号:US10706019B2
公开(公告)日:2020-07-07
申请号:US14861438
申请日:2015-09-22
Applicant: SAP SE
Inventor: Andreas Tonder , Martin Heidel , Edward-Robert Tyercha , Juchang Lee
IPC: G06F17/30 , G06F16/176 , G06F16/23
Abstract: Disclosed herein are system, method, and computer program product embodiments for performing database processing after a lock condition. An embodiment operates by receiving a release of a lock on data of a database. It is determined whether the data was modified by a processing of a first transaction associated with the first request. The lock is provided to a second transaction associated with a second request to access the data. If the first transaction did not modify the data, a second transaction associated with the second request is retried without refreshing a snapshot of the data. If the first transaction modified the data, the snapshot of the data is refreshed before the second transaction is retried.
-
-
-
-
-
-
-
-
-