公开(公告)号：EP3889793A1

公开(公告)日：2021-10-06

申请号：EP20198031.5

申请日：2020-09-24

Applicant: SAP SE

Inventor： LEE, Juchang ,  PARK, Myunggon ,  LIM, Jihwan ,  HWANG, YoungSeok

IPC: G06F16/21

Abstract: Methods, systems, and computer-readable storage media for receiving a capture file, the capture file including data representative of a workload executed in a source database system, and processing the capture file to provide a replay file, the replay file being in a format that is executable by a replayer to replay the workload in a target database system, processing the capture file including: processing the capture file to provide a set of intermediate files, and processing the set of intermediate files using in-memory merge sort operations to generate a set of replay files.

公开(公告)号：EP3026581B1

公开(公告)日：2018-12-05

申请号：EP15003116.9

申请日：2015-10-30

Applicant: SAP SE

Inventor： SCHRETER, Ivan ,  LEE, Juchang ,  ANDREI, Mihnea

IPC: G06F17/30

CPC classification number: G06F17/30592 ,  G06F17/30353

Abstract: A plurality of transactions is handled in a database. Each transaction includes a plurality of operations on at least one record in the database with at least two of the transactions being handled concurrently. Thereafter, a temporary timestamp is assigned to each record. The temporary timestamp are based, at least in part, on the corresponding transaction. Further, a final timestamp is assigned to each record with a commit operation. It can later be determined, using a visibility function and based on the assigned temporary timestamps and final timestamps, which of the records are visible in a consistent view for a first transaction. Based on such determination, access can be provided to those records determined to be visible to be accessed to the first transaction.

公开(公告)号：EP3185143A1

公开(公告)日：2017-06-28

申请号：EP16002574.8

申请日：2016-12-02

Applicant: SAP SE

Inventor： LEE, Juchang ,  PARK, Chang Gyoo ,  KIM, Kyu Hwan

IPC: G06F17/30

Abstract: Technologies are described for facilitating transaction processing within a database environment having first, second, and third database system nodes. In the database system, the first database system node receives from the second database system node a request to precommit a first database transaction. The first database system node stores information for the first database transaction that includes an indication that the second database system node coordinates the committing of the first database transaction. The first database system node receives from the third database system node a request to precommit a second database transaction. The first database system node stores information for the second database transaction that includes an indication that the third database system node coordinates the committing of the second database transaction.

Abstract translation: 描述了用于促进具有第一，第二和第三数据库系统节点的数据库环境内的事务处理的技术。 在数据库系统中，第一数据库系统节点从第二数据库系统节点接收预先提交第一数据库事务的请求。 第一数据库系统节点存储第一数据库事务的信息，该信息包括第二数据库系统节点协调第一数据库事务的提交的指示。 第一数据库系统节点从第三数据库系统节点接收预先提交第二数据库事务的请求。 第一数据库系统节点存储用于第二数据库事务的信息，该信息包括第三数据库系统节点协调第二数据库事务的提交的指示。

公开(公告)号：EP3796185A1

公开(公告)日：2021-03-24

申请号：EP20195250.4

申请日：2020-09-09

Applicant: SAP SE

Inventor： KARL, Ruediger ,  ANDREI, Mihnea ,  LEE, Juchang ,  BAEUERLE, Stefan ,  BAE, Seyeong ,  LEE, Joo Yeon

IPC: G06F16/22

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.

公开(公告)号：EP3413215A1

公开(公告)日：2018-12-12

申请号：EP18175767.5

申请日：2018-06-04

Applicant: SAP SE

Inventor： LEE, Juchang ,  PARK, Chang Gyoo

IPC: G06F17/30

CPC classification number: G06F17/30309 ,  G06F11/1446 ,  G06F11/2094 ,  G06F17/30221 ,  G06F17/30283 ,  G06F17/30575

Abstract: Technologies are described for facilitating the processing of requests for database operations in a distributed database environment. Criteria are defined for processing a request for a database operation according to first or second snapshot isolation protocols. A request for a database operation is received and it is determined if the snapshot isolation protocol criteria are met. If the criteria are met, the request can be processed using a local snapshot identifier value of a worker node. If the criteria are not met, the local snapshot identifier value is synchronized with another node, and the request processed using the updated snapshot identifier value.

公开(公告)号：EP3026580A1

公开(公告)日：2016-06-01

申请号：EP15003095.5

申请日：2015-10-29

Applicant: SAP SE

Inventor： LEE, Juchang ,  Andrei, Mihnea ,  Florendo, Colin ,  Schreter, Ivan ,  Goel, Anil Kumar

IPC: G06F17/30

CPC classification number: G06F17/30463 ,  G06F17/30339 ,  G06F17/30345 ,  G06F17/30353 ,  G06F17/30548

Abstract: Disclosed herein are system, method, and computer program product embodiments for determining row visibility states. An embodiment operates by initializing a result bitmap for rows based on visible row state values of row state bitmaps corresponding to the rows, wherein values of the result bitmap indicate whether the row are visible or not visible; determining one or more rows whose corresponding visible row state values indicate that the one or more rows are not visible; and determining whether to update the result bitmap to indicate that the one or more rows are visible based on one or more versioned row state values, wherein the one or more versioned row state values indicate whether the corresponding rows are not visible or possibly visible.

Abstract translation: 这里公开了用于确定行可见性状态的系统，方法和计算机程序产品实施例。 实施例通过基于与行对应的行状态位图的可见行状态值来初始化行的结果位图来进行操作，其中结果位图的值指示该行是可见还是不可见; 确定其对应的可见行状态值指示所述一行或多行不可见的一行或多行; 以及基于一个或多个版本化的行状态值来确定是否更新所述结果位图以指示所述一个或多个行是可见的，其中所述一个或多个版本化行状态值指示所述相应行是否不可见或可见。

公开(公告)号：EP3822811A1

公开(公告)日：2021-05-19

申请号：EP20195056.5

申请日：2020-09-08

Applicant: SAP SE

Inventor： LEE, Juchang ,  CHOI, Seoyoon ,  KIM, Eunsang ,  KIM, Kyu Hwan ,  LEE, Joo Yeon ,  NA, Hyoung Jun

IPC: G06F16/27

Abstract: RTR of a database transaction to a replica table may include receiving replication and transaction commit log entries (representing a database transaction). The replication log entry has a row-ID value, and the row at the replica table has a row-ID value. The replication log entry may be dispatched to a parallel log replayer and the associated transaction commit log entry to a transaction commit log replayer. The row-ID values may be compared, and the replication log entry is replayed at the parallel log replayer based on the comparison. The database transaction may then be committed to the replica table by replaying the associated transaction commit log entry at the transaction log replayer, wherein the database transaction is associated with row-level parallel replay having transactional consistency and DDL replication and reconstruction of a DDL statement at the replica system is associated with one or multiple metadata update log entries.

公开(公告)号：EP3796184A1

公开(公告)日：2021-03-24

申请号：EP20195241.3

申请日：2020-09-09

Applicant: SAP SE

Inventor： KARL, Ruediger ,  ANDREI, Mihnea ,  LEE, Juchang ,  BAEUERLE, Stefan ,  BAE, Seyeong ,  LEE, Joo Yeon

IPC: G06F16/22

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 tables located in a remote database system, replica tables containing data replicated from a table in a remote database system, or cached table data. Replica tables targeted by a logical pointer of a virtual table schema can have various locations, such as being located in main memory of a database system, being located in a dynamic storage system, or being located in a data lake. Replica tables can be transferred between locations based on various criteria.

公开(公告)号：EP3550443A1

公开(公告)日：2019-10-09

申请号：EP19166476.2

申请日：2019-04-01

Applicant: SAP SE

Inventor： LEE, Juchang ,  PARK, Chang Gyoo ,  NA, Hyoung Jun

IPC: G06F16/23 ,  G06F16/27 ,  G06F16/28 ,  G06F16/22

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.

公开(公告)号：EP4293533A1

公开(公告)日：2023-12-20

申请号：EP22204505.6

申请日：2022-10-28

Applicant: SAP SE

Inventor： ANDREI, Mihnea ,  BOEHM, Alexander ,  MAY, Norman ,  KLINGSPORN, Urs ,  BLOCK, Meinolf ,  VOELKER, Patrick ,  KIM, Hyunjun ,  GLEBE, Thorsten ,  BREGLER, Jonathan ,  CHOI, Jaeyoung ,  KITTEL, Martin ,  KWON, Yong Sik ,  HAHN, Uwe ,  ZAHN, Henning ,  HANDRECK, Melanie ,  MACK, Holger ,  KIM, Eunsang ,  RENKES, Frank ,  LEE, Juchang ,  SCHINDEWOLF, Martin ,  BOWMAN, Ivan ,  DANNECKER, Lars

IPC: G06F16/27 ,  G06F21/62

Abstract: Systems and methods include creation of a first instance of a tenant object in a database instance, association of the first instance of the tenant object with a first plurality of database artifacts including first data associated with the first instance of the tenant object, creation of a second instance of the tenant object in the database instance, association of the second instance of the tenant object with a second plurality of database artifacts including second data associated with the second instance of the tenant object, and reception and response to queries on the first data associated with the first instance of the tenant object and to queries on the second data associated with the second instance of the tenant object.