公开(公告)号：US20250013628A1

公开(公告)日：2025-01-09

申请号：US18217943

申请日：2023-07-03

Applicant: SAP SE

Inventor： Eun Kyung Chi ,  Heeyeon Jo

IPC: G06F16/22

Abstract: Techniques and solutions are provided for executing database triggers. In particular, disclosed techniques allow for the creation of database triggers with multiple insert statements. For a trigger that includes first and second insert statements, first and second tables are created, respectively for the first and second insert statements, that each include a sequence column. At least the first insert statement references a sequence that is incremented during trigger execution. The sequence columns of the first and second tables have a number of elements corresponding to a number of times a given insert operation will execute as a result of a database operation that satisfies the conditions of the trigger. The first and second insert operations are executed using the respective first and second tables.

公开(公告)号：US12229115B2

公开(公告)日：2025-02-18

申请号：US18217943

申请日：2023-07-03

Applicant: SAP SE

Inventor： Eun Kyung Chi ,  Heeyeon Jo

IPC: G06F16/23 ,  G06F16/2455

Abstract: Techniques and solutions are provided for executing database triggers. In particular, disclosed techniques allow for the creation of database triggers with multiple insert statements. For a trigger that includes first and second insert statements, first and second tables are created, respectively for the first and second insert statements, that each include a sequence column. At least the first insert statement references a sequence that is incremented during trigger execution. The sequence columns of the first and second tables have a number of elements corresponding to a number of times a given insert operation will execute as a result of a database operation that satisfies the conditions of the trigger. The first and second insert operations are executed using the respective first and second tables.

公开(公告)号：US11461230B2

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

申请号：US16785443

申请日：2020-02-07

Applicant: SAP SE

Inventor： SungGun Jung ,  Yuchon Yi ,  Eun Kyung Chi ,  Taesik Yoon

IPC: G06F12/06 ,  G06F16/22 ,  G06F16/23

Abstract: In some embodiments, a method receives a query to retrieve data from a source table and insert the data into a target table and allocates a size of memory. A portion of the data from the source table is retrieved based on the size of memory and stored in the memory. Then, the method stores the retrieved portion of the data stored in the memory into the target table and continues to retrieve portions of data from the source table in increments based on the size of memory, store the retrieved portions of data in the memory, and store the retrieved portions of data from the memory in the target table until the data from the source table has been inserted into the target table.

公开(公告)号：US20210248071A1

公开(公告)日：2021-08-12

申请号：US16785443

申请日：2020-02-07

Applicant: SAP SE

Inventor： SungGun Jung ,  Yuchon Yi ,  Eun Kyung Chi ,  Taesik Yoon

IPC: G06F12/06 ,  G06F16/23 ,  G06F16/22

Abstract: In some embodiments, a method receives a query to retrieve data from a source table and insert the data into a target table and allocates a size of memory. A portion of the data from the source table is retrieved based on the size of memory and stored in the memory. Then, the method stores the retrieved portion of the data stored in the memory into the target table and continues to retrieve portions of data from the source table in increments based on the size of memory, store the retrieved portions of data in the memory, and store the retrieved portions of data from the memory in the target table until the data from the source table has been inserted into the target table.

公开(公告)号：US10459889B2

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

申请号：US15615504

申请日：2017-06-06

Applicant: SAP SE

Inventor： Jaeyun Noh ,  Taesik Yoon ,  Eun Kyung Chi

IPC: G06F16/00 ,  G06F16/176 ,  G06F16/242 ,  G06F16/2453 ,  G06F16/2455 ,  G06F16/2452

Abstract: Technologies are provided for using a multi-user execution plan cache to process database queries. A database query processor can be configured to store execution plans in a multi-user execution plan cache. The query processor can determine whether an execution plan is shareable by multiple database users. If the execution plan is shareable, it can be stored in the cache in association with a sharing user identifier. When a database query is received, the query processor can determine that the query can be performed using the cached execution plan. If the cached execution plan is shareable, the database query can determine whether the cached execution plan is valid for a database user associated with the received database query. If the cached execution plan is valid for the database user, the query processor uses the cached execution plan to perform the query for the associated database user.

公开(公告)号：US20180349404A1

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

申请号：US15615504

申请日：2017-06-06

Applicant: SAP SE

Inventor： Jaeyun Noh ,  Taesik Yoon ,  Eun Kyung Chi

IPC: G06F17/30

CPC classification number: G06F16/176 ,  G06F16/244 ,  G06F16/24524 ,  G06F16/24534 ,  G06F16/24539 ,  G06F16/24557

Abstract: Technologies are provided for using a multi-user execution plan cache to process database queries. A database query processor can be configured to store execution plans in a multi-user execution plan cache. The query processor can determine whether an execution plan is shareable by multiple database users. If the execution plan is shareable, it can be stored in the cache in association with a sharing user identifier. When a database query is received, the query processor can determine that the query can be performed using the cached execution plan. If the cached execution plan is shareable, the database query can determine whether the cached execution plan is valid for a database user associated with the received database query. If the cached execution plan is valid for the database user, the query processor uses the cached execution plan to perform the query for the associated database user.