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

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