Invention Grant
- Patent Title: Partition move in case of table update
-
Application No.: US16373052Application Date: 2019-04-02
-
Publication No.: US11048692B2Publication Date: 2021-06-29
- Inventor: SungGun Jung , Sukhyeun Cho , Taesik Yoon , Joern Schmidt
- Applicant: SAP SE
- Applicant Address: DE Walldorf
- Assignee: SAP SE
- Current Assignee: SAP SE
- Current Assignee Address: DE Walldorf
- Agency: Buckley, Maschoff & Talwalkar LLC
- Main IPC: G06F16/23
- 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.
Public/Granted literature
- US20200320060A1 PARTITION MOVE IN CASE OF TABLE UPDATE Public/Granted day:2020-10-08
Information query