公开(公告)号：US20170083538A1

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

申请号：US14861438

申请日：2015-09-22

Applicant: SAP SE

Inventor： Andreas Tonder ,  Martin Heidel ,  Edward-Robert Tyercha ,  Juchang Lee

IPC: G06F17/30

Abstract: Disclosed herein are system, method, and computer program product embodiments for performing database processing after a lock condition. An embodiment operates by receiving a release of a lock on data of a database. It is determined whether the data was modified by a processing of a first transaction associated with the first request. The lock is provided to a second transaction associated with a second request to access the data. If the first transaction did not modify the data, a second transaction associated with the second request is retried without refreshing a snapshot of the data. If the first transaction modified the data, the snapshot of the data is refreshed before the second transaction is retried.

公开(公告)号：US20190354620A1

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

申请号：US15980974

申请日：2018-05-16

Applicant: SAP SE

Inventor： Amarnadh Sai Eluri ,  Anupam Mukherjee ,  Andreas Tonder ,  Vimal Chandran Satheesh

IPC: G06F17/30 ,  G06F12/02 ,  G06F12/06

Abstract: Disclosed herein are system, method, and computer program product embodiments for managing timestamp information in memory systems. In an embodiment, an infrastructure may utilize a controller to manage sparse timestamp blocks. These sparse timestamp blocks may manage timestamp information in a persistent memory structure. Controller 110 may utilize a transient timestamp accessor to map the timestamp information for faster hash lookups. Controller 110 may also utilize a garbage collection map as a bitmap to further save processing steps. Controller 110 may utilize the sparse timestamp blocks, transient timestamp accessor, and garbage collection map to efficiently store timestamp data and to quickly retrieve the stored timestamp data.

公开(公告)号：US20190311051A1

公开(公告)日：2019-10-10

申请号：US15945723

申请日：2018-04-04

Applicant: SAP SE

Inventor： Thomas Legler ,  Andreas Tonder

IPC: G06F17/30

Abstract: A system for implementing virtual columns in a column store database is provided. In some implementations, the system performs operations including accessing a database table in a column store database system, the database table comprising at least one virtual column, the column store database system storing data in a column-oriented structure. The operations further include calculating a value for the at least one virtual column based on at least one existing column of the database table, the calculated value mapped to a row identifier associated with a row of the database table. The operations further include providing, in response to a query, the calculated value to a user interface, the query associated with the row identifier.

公开(公告)号：US20170329807A1

公开(公告)日：2017-11-16

申请号：US15665154

申请日：2017-07-31

Applicant: SAP SE

Inventor： Martin Kaufmann ,  Norman May ,  Andreas Tonder ,  Donald Kossmann

IPC: G06F17/30

CPC classification number: G06F16/219 ,  G06F16/2322 ,  G06F16/2365 ,  G06F16/2477

Abstract: Calculation of aggregated values in a history database table can be optimized using an approach in which an ordered history table is accessed. The ordered history table can include a sequential listing of commit identifiers associated with updates, insertions, and/or deletions to values in the database table. The ordered history table can be traversed in a single pass to calculate an aggregation function using an optimized algorithm. The optimized algorithm can enable calculation of an aggregated metric of the values based on a selected method for tracking invalidated values to their corresponding commit identifiers. The calculated metric is generated for a current version of the database table; and promoted.

公开(公告)号：US20240111757A1

公开(公告)日：2024-04-04

申请号：US18530819

申请日：2023-12-06

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

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.

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

公开(公告)号：US10762068B2

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

申请号：US15945723

申请日：2018-04-04

Applicant: SAP SE

Inventor： Thomas Legler ,  Andreas Tonder

IPC: G06F16/00 ,  G06F16/22 ,  G06F16/25 ,  G06F16/2453

Abstract: A system for implementing virtual columns in a column store database is provided. In some implementations, the system performs operations including accessing a database table in a column store database system, the database table comprising at least one virtual column, the column store database system storing data in a column-oriented structure. The operations further include calculating a value for the at least one virtual column based on at least one existing column of the database table, the calculated value mapped to a row identifier associated with a row of the database table. The operations further include providing, in response to a query, the calculated value to a user interface, the query associated with the row identifier.

公开(公告)号：US11347711B2

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

申请号：US16893567

申请日：2020-06-05

Applicant: SAP SE

Inventor： Amarnadh Sai Eluri ,  Anupam Mukherjee ,  Andreas Tonder ,  Vimal Chandran Satheesh

IPC: G06F16/23 ,  G06F12/02 ,  G06F12/06

Abstract: Disclosed herein are system, method, and computer program product embodiments for managing timestamp information in memory systems. In an embodiment, an infrastructure may utilize a controller to manage sparse timestamp blocks. These sparse timestamp blocks may manage timestamp information in a persistent memory structure. Controller 110 may utilize a transient timestamp accessor to map the timestamp information for faster hash lookups. Controller 110 may also utilize a garbage collection map as a bitmap to further save processing steps. Controller 110 may utilize the sparse timestamp blocks, transient timestamp accessor, and garbage collection map to efficiently store timestamp data and to quickly retrieve the stored timestamp data.

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