公开(公告)号：US11727063B2

公开(公告)日：2023-08-15

申请号：US17489167

申请日：2021-09-29

Applicant: SAP SE

Inventor： SungGun Jung ,  Yuchon Yi ,  Holger Bischoff

IPC: G06F16/903 ,  G06F16/9032

CPC classification number: G06F16/90335 ,  G06F16/9032

Abstract: A system includes reception of a database query, the query comprising a first query statement to insert rows of a source table into a target table, generation 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, generation of a first query operator executable to perform the second query statement, generation of a second query operator executable to perform the third query statement, transmission of the first executable query operator to a second database server node storing the first partition of the source table, and transmission of the second executable query operator to a third database server node storing the second partition of the source table.

公开(公告)号：US11157565B2

公开(公告)日：2021-10-26

申请号：US16374898

申请日：2019-04-04

Applicant: SAP SE

Inventor： SungGun Jung ,  Yuchon Yi ,  Holger Bischoff

IPC: G06F16/903 ,  G06F16/9032

Abstract: A system includes reception of a database query, the query comprising a first query statement to insert rows of a source table into a target table, generation 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, generation of a first query operator executable to perform the second query statement, generation of a second query operator executable to perform the third query statement, transmission of the first executable query operator to a second database server node storing the first partition of the source table, and transmission of the second executable query operator to a third database server node storing the second partition of the source table.

公开(公告)号：US20220019626A1

公开(公告)日：2022-01-20

申请号：US17489167

申请日：2021-09-29

Applicant: SAP SE

Inventor： SungGun Jung ,  Yuchon Yi ,  Holger Bischoff

IPC: G06F16/903 ,  G06F16/9032

Abstract: A system includes reception of a database query, the query comprising a first query statement to insert rows of a source table into a target table, generation 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, generation of a first query operator executable to perform the second query statement, generation of a second query operator executable to perform the third query statement, transmission of the first executable query operator to a second database server node storing the first partition of the source table, and transmission of the second executable query operator to a third database server node storing the second partition of the source table.

公开(公告)号：US20200320137A1

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

申请号：US16374898

申请日：2019-04-04

Applicant: SAP SE

Inventor： SungGun Jung ,  Yuchon Yi ,  Holger Bischoff

IPC: G06F16/903 ,  G06F16/9032

Abstract: A system includes reception of a database query, the query comprising a first query statement to insert rows of a source table into a target table, generation 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, generation of a first query operator executable to perform the second query statement, generation of a second query operator executable to perform the third query statement, transmission of the first executable query operator to a second database server node storing the first partition of the source table, and transmission of the second executable query operator to a third database server node storing the second partition of the source table.

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