公开(公告)号：EP4361834A1

公开(公告)日：2024-05-01

申请号：EP23204059.2

申请日：2023-10-17

Applicant: SAP SE

Inventor： KIM, Jaehwa ,  PARK, Kyungyul ,  KIM, Eunsang ,  LEE, Joo Yeon ,  LEE, Taehyung

IPC: G06F16/21

CPC classification number: G06F16/213

Abstract: Various systems and methods for selective revalidation of data objects are provided. In one example, a computer-implemented method includes updating a target data object of a database system according to a definition statement, and determining whether the definition statement changes one or more object properties of the target data object. In response to determining that the definition statement changes the one or more object properties of the target data object, the method includes revalidating data objects depending on the target data object. In response to determining that the definition statement does not change the one or more object properties of the target data object, the method includes not revalidating the data objects depending on the target data object. In this way, database management performance and speed may be improved while maintaining validity of data objects in a database.

公开(公告)号：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.

公开(公告)号：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.

公开(公告)号：EP3796183A1

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

申请号：EP20194962.5

申请日：2020-09-08

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-memory storage or in dynamic storage of a database management system. The dynamic storage includes an in-memory buffer cache and persistent storage. The logical pointer can be updated to point to the in-memory storage or the dynamic storage, including based on use statistics. Similarly, a table having data for the virtual table can be transitioned between the in-memory buffer cache and the persistent storage, including based on use statistics for the virtual table. A value for the logical pointer can be updated when the table is transferred between the in-memory buffer cache and the dynamic storage.

公开(公告)号：EP3401806A1

公开(公告)日：2018-11-14

申请号：EP18170733.2

申请日：2018-05-04

Applicant: SAP SE

Inventor： LEE, Juchang ,  LEE, Joo Yeon ,  MUEHLE, Michael ,  PARK, Myung Sun ,  NA, Hyoung Jun

IPC: G06F17/30

CPC classification number: G06F17/30353 ,  G06F9/466 ,  G06F15/167 ,  G06F17/30002 ,  G06F17/30309 ,  G06F17/30348 ,  G06F17/30362

Abstract: Technologies are described for facilitating transaction processing within a database environment. A commit protocol provides for the atomic commit or rollback of a transaction that includes an operation that modifies a metadata entity of the database system and one or more other operations that modify metadata entities or data records of the database system. Innovations are provided for detecting and resolving deadlocks that may arise during transaction processing. Innovations are also provided for providing versioning of metadata entities, including invalidating metadata entities cached at a slave node during the commit at a master node of a transaction that creates a new version of the metadata entity.

公开(公告)号：EP3401804A1

公开(公告)日：2018-11-14

申请号：EP18170530.2

申请日：2018-05-03

Applicant: SAP SE

Inventor： LEE, Juchang ,  KIM, Kyu Hwan ,  LEE, Joo Yeon ,  PARK, Kyungyul ,  KIM, Deok Hoe

IPC: G06F17/30 ,  G06F11/14 ,  H04L29/08

CPC classification number: G06F17/30356 ,  G06F11/14 ,  G06F17/30353 ,  G06F17/30377 ,  G06F17/30545 ,  G06F17/30554 ,  G06F17/30575 ,  H04L67/1034

Abstract: Technologies are described providing adaptive query routing in a replicated database environment. The technologies can be used with a variety of replication protocols. Prepared statements, such as for queries, from a database client can be routed to a source node, or a source node and available replica nodes, when a replica node becomes unavailable. When a replica node becomes available again, a prepared statement can be updated to indicate that the updated prepared statement can be executed at nodes including the replica node that is available again. Prepared statement routing can also be used when a portion of replicated data becomes unavailable at a replica node, but a portion of replicated data remains available.

公开(公告)号：EP3182300B1

公开(公告)日：2018-08-15

申请号：EP16002568.0

申请日：2016-12-01

Applicant: SAP SE

Inventor： LEE, Juchang ,  PARK, Chang Gyoo ,  KIM, Kyu Hwan ,  NA, Hyoung Jun ,  KIM, Deok Koo ,  LEE, Joo Yeon

IPC: G06F17/30 ,  G06F11/14

CPC classification number: G06F17/30377 ,  G06F11/1451 ,  G06F17/30578 ,  G06F17/30581 ,  G06F2201/80

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.

公开(公告)号：EP3182300A1

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

申请号：EP16002568.0

申请日：2016-12-01

Applicant: SAP SE

Inventor： LEE, Juchang ,  Park, Chang Gyoo ,  KIM, Kyu Hwan ,  NA, Hyoung Jun ,  KIM, Deok Koo ,  LEE, Joo Yeon

IPC: G06F17/30

CPC classification number: G06F17/30377 ,  G06F11/1451 ,  G06F17/30578 ,  G06F17/30581 ,  G06F2201/80

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.

Abstract translation: 描述了用于在具有源节点和复制节点的数据库环境内执行数据复制的技术。 源节点对源节点存储的至少一个数据库表执行数据库操作。 源节点将数据库操作异步发送到副本节点。 准备提交请求从源节点同步发送到副本节点。 源节点从副本节点接收同步预提交确认。 预提交确认指示数据库操作已在副本节点上执行。 源节点提交与数据库操作关联的事务。