公开(公告)号：US20200320060A1

公开(公告)日：2020-10-08

申请号：US16373052

申请日：2019-04-02

Applicant: SAP SE

Inventor： SungGun Jung ,  Sukhyeun Cho ,  Taesik Yoon ,  Joern Schmidt

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

Abstract: A system includes reception of a query to update a partition key value of a first set of rows of a database table, determination that the updated partition key value is associated with a first partition of the database table stored on a first database server node, fetching of row identifiers of each of the first set of rows from two or more database server nodes in which each of the first set of rows is respectively stored, determination, based on the row identifiers, of a first subset of the first rows which are not stored on the first database server node and a second subset of the first rows which are stored on the first database server node, fetching of the first subset of rows from the database server nodes in which each of the first set of rows is respectively stored, update of the partition key value of each row of the fetched first subset of rows, instructing of the first database server node to store the updated rows of the fetched first subset in the first partition stored on the first database server node, and instructing of the first database server node to update the partition key value of each of the second subset of rows of the partition stored on the first database server node.

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

公开(公告)号：US11048692B2

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

申请号：US16373052

申请日：2019-04-02

Applicant: SAP SE

Inventor： SungGun Jung ,  Sukhyeun Cho ,  Taesik Yoon ,  Joern Schmidt

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

Abstract: A system includes reception of a query to update a partition key value of a first set of rows of a database table, determination, based on fetched row identifiers, of a first subset of the first rows which are not stored on the first database server node and a second subset of the first rows which are stored on the first database server node, fetching of the first subset of rows from the database server nodes, update of the partition key value of each row of the fetched first subset of rows, instructing of the first database server node to: store the updated rows of the fetched first subset in the first partition stored on the first database server node, and update the partition key value of each of the second subset of rows of the partition stored on the first database server node.

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