US 11,727,063 B2
Parallel partition-wise insert sub-select
SungGun Jung, Anyang (KR); Yuchon Yi, Yongin (KR); and Holger Bischoff, Dielheim (DE)
Assigned to SAP SE, Walldorf (DE)
Filed by SAP SE, Walldorf (DE)
Filed on Sep. 29, 2021, as Appl. No. 17/489,167.
Application 17/489,167 is a continuation of application No. 16/374,898, filed on Apr. 4, 2019, granted, now 11,157,565.
Prior Publication US 2022/0019626 A1, Jan. 20, 2022
This patent is subject to a terminal disclaimer.
Int. Cl. G06F 16/903 (2019.01); G06F 16/9032 (2019.01)
CPC G06F 16/90335 (2019.01) [G06F 16/9032 (2019.01)] 10 Claims
OG exemplary drawing
 
1. A system comprising:
a first database server node to:
receive a database query, the query comprising a first query statement to insert rows of a source table into a target table, wherein a partitioning scheme of the source table is different from a partitioning scheme of the target table;
generate a second query statement and a third query statement based on the first query statement, the second query statement to insert rows of a first partition of the source table into the target table and the third query statement to insert rows of a second partition of the source table into the target table;
generate a first executable query operator based on the second query statement;
generate a second executable query operator based on the third query statement;
transmit the first executable query operator to a second database server node storing the first partition of the source table, the second database server node to execute the first executable query operator to retrieve the rows of the first partition of the source table, to insert a subset of the rows of the first partition of the source table into a first partition of the target table and to insert another subset of the rows of the first partition of the source table into an other partition of the target table; and
transmit the second executable query operator to a third database server node storing the second partition of the source table, the third database server node storing the second partition of the source table and a second partition of the target table, the third database server node to execute the second executable query operator to retrieve the rows of the second partition of the source table, to insert a subset of the rows of the second partition of the source table into the second partition of the target table and to insert another subset of the rows of the second partition of the source table into the other partition of the target table.