公开(公告)号：US11573947B2

公开(公告)日：2023-02-07

申请号：US15589160

申请日：2017-05-08

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 ,  G06F11/16

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.

公开(公告)号：US20220292099A1

公开(公告)日：2022-09-15

申请号：US17830935

申请日：2022-06-02

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.

公开(公告)号：US11327958B2

公开(公告)日：2022-05-10

申请号：US17005085

申请日：2020-08-27

Applicant: SAP SE

Inventor： Juchang Lee ,  Chang Gyoo Park ,  Kyu Hwan Kim ,  Hyoung Jun Na ,  Deok Koo Kim ,  Joo Yeon Lee

IPC: G06F16/00 ,  G06F16/23 ,  G06F16/27 ,  G06F11/14

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.

公开(公告)号：US11314716B2

公开(公告)日：2022-04-26

申请号：US16730528

申请日：2019-12-30

Applicant: SAP SE

Inventor： Juchang Lee ,  Joo Yeon Lee ,  Michael Muehle ,  Myung Sun Park ,  Hyoung Jun Na

IPC: G06F16/23 ,  G06F9/46 ,  G06F15/167 ,  G06F16/21

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.

公开(公告)号：US20220100715A1

公开(公告)日：2022-03-31

申请号：US17210393

申请日：2021-03-23

Applicant: SAP SE

Inventor： Juchang Lee ,  Ivan Veselinov Andreev ,  Eunsang Kim ,  Jaehwa Kim ,  Yong Sik Kwon ,  Joo Yeon Lee ,  Jian Luo ,  Myunggon Park ,  Edward-Robert Tyercha ,  Zheng-Wei Wang ,  Paul Willems

IPC: G06F16/21 ,  G06F16/25 ,  G06F21/62 ,  G06F21/60

Abstract: A physio-logical migration of a database from a source system to a target system may include exporting a catalog of the database in a data interchange format that preserves the hierarchical dependencies present amongst the entities included in the catalog. The physio-logical migration of the database may further include exporting the contents of a table in the database in a binary format compatible at the target system. The binary format may be a data buffer having a metadata portion, a fixed-size portion, and a page chain portion. Where the target system is a cloud-based system, the physio-logical migration of the database may include exporting the catalog and the contents of the table to a cloud-based object store before importing the catalog and the contents of the table to the target system. Related systems and articles of manufacture, including computer program products, are also provided.

公开(公告)号：US10997146B2

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

申请号：US16107917

申请日：2018-08-21

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

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.

公开(公告)号：US20210089550A1

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

申请号：US16713850

申请日：2019-12-13

Applicant: SAP SE

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

IPC: G06F16/25 ,  G06F16/22 ,  G06F16/2455 ,  G06F16/21 ,  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 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.

公开(公告)号：US10102237B2

公开(公告)日：2018-10-16

申请号：US15256323

申请日：2016-09-02

Applicant: SAP SE

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

IPC: G06F17/30

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.

公开(公告)号：US20160371315A1

公开(公告)日：2016-12-22

申请号：US15256323

申请日：2016-09-02

Applicant: SAP SE

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

IPC: G06F17/30

CPC classification number: G06F17/30339 ,  G06F17/30292 ,  G06F17/30315 ,  G06F17/30554 ,  G06F17/30575 ,  G06F17/30864

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.

Abstract translation: 托管多承租人软件架构租户的内存数据库服务器可以接收对具有对租户的独立访问权限的组织独有的自定义数据字段的定义。 定制数据字段可以扩展由存储在多承租人软件体系结构的系统租户处的中央元数据定义的标准表。 包含定义的租户私有元数据可以存储在只能由租户访问的存储器中。 可以形成包括自定义数据字段的租户相关表，例如通过从系统租户检索定义标准表的中心元数据，并使用定义添加自定义数据字段。 可以通过组织中的数据库客户端呈现租户相关表。 公开了相关系统，制品和计算机实现的方法。