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

公开(公告)号：US10474697B2

公开(公告)日：2019-11-12

申请号：US14973596

申请日：2015-12-17

Applicant: SAP SE

Inventor： Christian Bensberg ,  Lars Fricke ,  Martin Heidel ,  Holger Bischoff ,  Joern Schmidt ,  Edward-Robert Tyercha ,  Andreas Tonder

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

Abstract: An update to a partitioning column for a partitioned table in a database can be performed by handling rows for which the update will not require moving to a different partition separately (e.g. “locally”) for each partition followed by re-inserting those rows that will require moving to a different partition and deleting them from the original partition. The re-inserted rows are directed to a correct partition by application of the partitioning criteria for the table. Methods, articles, and systems are described.

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

公开(公告)号：US10534797B2

公开(公告)日：2020-01-14

申请号：US15365693

申请日：2016-11-30

Applicant: SAP SE

Inventor： Christian Bensberg ,  Martin Heidel ,  Lars Fricke ,  Holger Bischoff ,  Joern Schmidt ,  Edward-Robert Tyercha

IPC: G06F16/27 ,  G06F16/23

Abstract: A first store and a second store can be configured to store a first partition of a table of a database and a second partition of the table of the database, respectively. A database management system can be configured to at least update at least a first portion of the first partition where the update includes an update to a first primary key column in the first partition and verify that the first primary key column is unique across the first partition and the second partition. A first row having a first primary key value of the first primary key column from the first partition can be deleted, when the first primary key value in the first partition conflicts with a second primary key value of a second primary key column in the second partition.

公开(公告)号：US20180150544A1

公开(公告)日：2018-05-31

申请号：US15365693

申请日：2016-11-30

Applicant: SAP SE

Inventor： Christian Bensberg ,  Martin Heidel ,  Lars Fricke ,  Holger Bischoff ,  Joern Schmidt ,  Edward-Robert Tyercha

IPC: G06F17/30

CPC classification number: G06F16/278 ,  G06F16/2365 ,  G06F16/2379

Abstract: A first store and a second store can be configured to store a first partition of a table of a database and a second partition of the table of the database, respectively. A database management system can be configured to at least update at least a first portion of the first partition where the update includes an update to a first primary key column in the first partition and verify that the first primary key column is unique across the first partition and the second partition. A first row having a first primary key value of the first primary key column from the first partition can be deleted, when the first primary key value in the first partition conflicts with a second primary key value of a second primary key column in the second partition.

公开(公告)号：US11341120B2

公开(公告)日：2022-05-24

申请号：US15931179

申请日：2020-05-13

Applicant: SAP SE

Inventor： Robert Schulze ,  Holger Bischoff ,  Neeraj Kulkarni

IPC: G06F16/23 ,  G06F12/02 ,  G06F3/06 ,  G06F16/22 ,  G06F12/0882 ,  G06F16/2455 ,  G06F12/0875 ,  G06F9/48

Abstract: Disclosed herein are system, method, and computer program product embodiments for creating a dictionary-free index. An embodiment operates by a database maintaining database table comprises a column and a row. The database creates a concatenated string index comprising a concatenated string value based on the database column's row. The database also creates a hash value list having a hash value based on the concatenation string index's concatenated string value. Thereafter, the database creates a directory having a pointer to (i) a row position of the hash value list or (ii) a row position of a collision list having the row position of the hash value in the hash value list. The database also creates a collision list containing the row positions of the hash values occurring multiple times in the hash value list. The index for the database table includes the hash value list, the directory, and the collision list.

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

公开(公告)号：US20170177700A1

公开(公告)日：2017-06-22

申请号：US14973596

申请日：2015-12-17

Applicant: SAP SE

Inventor： Christian Bensberg ,  Lars Fricke ,  Martin Heidel ,  Holger Bischoff ,  Joern Schmidt ,  Edward-Robert Tyercha ,  Andreas Tonder

IPC: G06F17/30

CPC classification number: G06F16/278 ,  G06F16/2282 ,  G06F16/2386

Abstract: An update to a partitioning column for a partitioned table in a database can be performed by handling rows for which the update will not require moving to a different partition separately (e.g. “locally”) for each partition followed by re-inserting those rows that will require moving to a different partition and deleting them from the original partition. The re-inserted rows are directed to a correct partition by application of the partitioning criteria for the table. Methods, articles, and systems are described.