公开(公告)号：US11886424B2

公开(公告)日：2024-01-30

申请号：US17481644

申请日：2021-09-22

Applicant: SAP SE

Inventor： Bernhard Scheirle ,  Andreas Tonder ,  Carsten Thiel ,  Guenter Radestock ,  Thomas Legler ,  Martin Heidel ,  Robert Schulze ,  Joern Schmidt ,  Rolando Blanco

IPC: G06F16/20 ,  G06F16/23

CPC classification number: G06F16/2379

Abstract: A method may include receiving a first transaction inserting a record into a database and a second transaction deleting the record from the database. A validity period for the record may be determined based on a first commit time at which the first transaction is committed and a second commit time at which the second transaction is committed. A current table and/or a history table of a system versioned table may be updated to include the record based on the validity period of the record. One or more temporal operations may be performed based on the system versioned table. For example, a time travel operation may be performed to retrieve, based on the system versioned table, one or more records that are valid at a given point in time. Related systems and computer program products are also provided.

公开(公告)号：US20230086162A1

公开(公告)日：2023-03-23

申请号：US17481644

申请日：2021-09-22

Applicant: SAP SE

Inventor： Bernhard Scheirle ,  Andreas Tonder ,  Carsten Thiel ,  Guenter Radestock ,  Thomas Legler ,  Martin Heidel ,  Robert Schulze ,  Joern Schmidt ,  Rolando Blanco

IPC: G06F16/23

Abstract: A method may include receiving a first transaction inserting a record into a database and a second transaction deleting the record from the database. A validity period for the record may be determined based on a first commit time at which the first transaction is committed and a second commit time at which the second transaction is committed. A current table and/or a history table of a system versioned table may be updated to include the record based on the validity period of the record. One or more temporal operations may be performed based on the system versioned table. For example, a time travel operation may be performed to retrieve, based on the system versioned table, one or more records that are valid at a given point in time. Related systems and computer program products are also provided.

公开(公告)号：US11151178B2

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

申请号：US16220633

申请日：2018-12-14

Applicant: SAP SE

Inventor： Frederik Transier ,  Joern Schmidt

IPC: G06F16/33 ,  G06F16/31 ,  G06F16/335 ,  G06F16/338 ,  G06F40/242

Abstract: In one aspect, there is provided a method. The method may include adding a tuple phrase to a phrase index as part of a lazy creation of the phrase index. The adding may include adding the tuple phrase to a dictionary mapped to the phrase index, adding to the phrase index a document identifier and a positional information for the tuple phrase, and adapting a first threshold and a second threshold value, the first threshold representing a threshold lower estimate of query processing burden associated with a least burdensome tuple phrase in the dictionary and the second threshold representing a top estimate of query processing burden associated with a most burdensome tuple phrase in the dictionary. The method may further include sending a query response including a generated query result corresponding to the tuple phrase.

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