公开(公告)号：US20230259522A1

公开(公告)日：2023-08-17

申请号：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/23 ,  G06F16/22 ,  G06F16/2455 ,  G06F16/21

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

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.

公开(公告)号：US11669539B2

公开(公告)日：2023-06-06

申请号：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

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.

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

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

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

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

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

公开(公告)号：US20240168954A1

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

申请号：US18426114

申请日：2024-01-29

Applicant: SAP SE

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

IPC: G06F16/2455 ,  G06F16/23

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.

公开(公告)号：US11074141B2

公开(公告)日：2021-07-27

申请号：US16711853

申请日：2019-12-12

Applicant: SAP SE

Inventor： Yong Sik Kwon ,  Changseob Lee ,  Seyeong Bae ,  Beomsoo Kim ,  Youngho Yoo

IPC: G06F11/14 ,  G06F11/10

Abstract: A system includes initiation of recovery from a crash of a database instance and, during the recovery, identification of a subset of pages of a memory image of the database instance which are not reusable and replacement of the identified subset of pages with corresponding pages of the savepoint image.

公开(公告)号：US20210182157A1

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

申请号：US16711853

申请日：2019-12-12

Applicant: SAP SE

Inventor： Yong Sik Kwon ,  Changseob Lee ,  Seyeong Bae ,  Beomsoo Kim ,  Youngho Yoo

IPC: G06F11/14 ,  G06F11/10

Abstract: A system includes initiation of recovery from a crash of a database instance and, during the recovery, identification of a subset of pages of a memory image of the database instance which are not reusable and replacement of the identified subset of pages with corresponding pages of the savepoint image.