公开(公告)号：US20210149915A1

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

申请号：US16686827

申请日：2019-11-18

Applicant: SAP SE

Inventor： Juchang Lee ,  Seoyoon Choi ,  Eunsang Kim ,  Kyu Hwan Kim ,  Joo Yeon Lee ,  Hyoung Jun Na

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

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.

公开(公告)号：US20210089540A1

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

申请号：US16713929

申请日：2019-12-13

Applicant: SAP SE

Inventor： Ruediger Karl ,  Mihnea Andrei ,  Juchang Lee ,  Stefan Baeuerle ,  Seyeong Bae ,  Joo Yeon Lee

IPC: G06F16/2455 ,  G06F16/23

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.

公开(公告)号：US20200042533A1

公开(公告)日：2020-02-06

申请号：US16599722

申请日：2019-10-11

Applicant: SAP SE

Inventor： Joo Yeon Lee ,  Jaehwa Kim ,  Joongkoo Lee

IPC: G06F16/27 ,  G06F16/22

Abstract: Methods and systems are disclosed for managing replication of metadata in a master-slave database environment. While metadata is managed on a master node using database tables with transaction guarantees, metadata copies on the slave node are managed using a lightweight key-value store. In exemplary embodiments, master metadata database tables are mapped to respective key-value structures at one or more slave nodes. The key-value structures have entries pointing to respective metadata objects, which include copies of metadata items stored in the master metadata database tables. The key-value structures can be hierarchically organized under a parent key-value structure. Metadata object versions can be organized as a linked list to facilitate multi-version concurrency control. Methods are disclosed for building the key-value store, for retrieving metadata from the store, for updating the store, for providing multi-version concurrency control, and for pruning obsolete metadata versions. Variants are disclosed.

公开(公告)号：US20180322157A1

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

申请号：US15589160

申请日：2017-05-08

Applicant: SAP SE

Inventor： Juchang Lee ,  Kyu Hwan Kim ,  Joo Yeon Lee ,  Kyungyul Park ,  Deok Hoe Kim

IPC: G06F17/30

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.

公开(公告)号：US12079237B2

公开(公告)日：2024-09-03

申请号：US18137693

申请日：2023-04-21

Applicant: SAP SE

Inventor： Ruediger Karl ,  Mihnea Andrei ,  Juchang Lee ,  Stefan Baeuerle ,  Seyeong Bae ,  Joo Yeon Lee

IPC: G06F16/25 ,  G06F16/21 ,  G06F16/22 ,  G06F16/23 ,  G06F16/2455

CPC classification number: G06F16/256 ,  G06F16/214 ,  G06F16/2282 ,  G06F16/23 ,  G06F16/24552

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.

公开(公告)号：US20240232165A9

公开(公告)日：2024-07-11

申请号：US17973440

申请日：2022-10-25

Applicant: SAP SE

Inventor： Jaehwa Kim ,  Kyungyul Park ,  Eunsang Kim ,  Joo Yeon Lee ,  Taehyung Lee

IPC: G06F16/23 ,  G06F11/34 ,  G06F16/21

CPC classification number: G06F16/2365 ,  G06F11/3409 ,  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.

公开(公告)号：US20240134838A1

公开(公告)日：2024-04-25

申请号：US17971506

申请日：2022-10-20

Applicant: SAP SE

Inventor： Won Wook Hong ,  Joo Yeon Lee ,  Hyeong Seog Kim ,  Jane Jung Lee ,  Younkyoung Lee

IPC: G06F16/23

CPC classification number: G06F16/23

Abstract: The present disclosure provides techniques and solutions for executing requests for database operations involving a remote data source in a system that includes an anchor node and one or more non-anchor nodes. A first request for one or more database operations is received, where at least a first database operation includes a data request for a remote data object. It is determined that the first database operation is not an insert, delete, or update operation, and therefore is assignable to the anchor node or one of the non-anchor nodes. The first database operation is assigned to a non-anchor node for execution. In a particular implementation, for a particular set of requests for a database operation, once an insert, delete, or update operation is received for the remote data object, subsequent operations for the remote data object in the set of requests are assigned to the anchor node for execution.

公开(公告)号：US11934407B2

公开(公告)日：2024-03-19

申请号：US17830935

申请日：2022-06-02

Applicant: SAP SE

Inventor： Ruediger Karl ,  Mihnea Andrei ,  Juchang Lee ,  Stefan Baeuerle ,  Seyeong Bae ,  Joo Yeon Lee

IPC: G06F7/00 ,  G06F16/23 ,  G06F16/2455 ,  G06F17/00

CPC classification number: G06F16/24562 ,  G06F16/2379 ,  G06F16/24552

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.

公开(公告)号：US11847109B2

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

申请号：US18064924

申请日：2022-12-12

Applicant: SAP SE

Inventor： Yong Sik Kwon ,  Yongsik Yoon ,  Joo Yeon Lee ,  Oliver M. Steinau ,  Markus Hartmann

IPC: G06F16/22 ,  G06F16/27 ,  G06F16/21 ,  G06F16/248 ,  G06F16/951

CPC classification number: G06F16/2282 ,  G06F16/211 ,  G06F16/221 ,  G06F16/248 ,  G06F16/27 ,  G06F16/951

Abstract: An in-memory database server hosting a tenant of a multi-tenant software architecture can receive a definition of a custom data field that is unique to an organization having isolated access to the tenant. The custom data field can extend a standard table defined by central metadata stored at a system tenant of the multi-tenant software architecture. Tenant private metadata that includes the definition can be stored in memory accessible only to the tenant. A tenant-dependent table that includes the custom data field can be formed, for example by retrieving central metadata defining the standard table from the system tenant and adding the custom data field using the definition. The tenant-dependent table can be presented for access via a database client at the organization. Related systems, articles of manufacture, and computer-implemented methods are disclosed.

公开(公告)号：US20230129099A1

公开(公告)日：2023-04-27

申请号：US18087712

申请日：2022-12-22

Applicant: SAP SE

Inventor： Juchang Lee ,  Kyu Hwan Kim ,  Joo Yeon Lee ,  Kyungyul Park ,  Deok Hoe Kim

IPC: G06F16/23 ,  G06F16/248 ,  G06F16/27 ,  G06F16/2458 ,  G06F11/20 ,  H04L67/1095

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.