公开(公告)号：US10915413B2

公开(公告)日：2021-02-09

申请号：US15410701

申请日：2017-01-19

Applicant: SAP SE

Inventor： Martin Heidel ,  Andreas Tonder ,  Shiping Chen

IPC: G06F11/14 ,  G06F16/21

Abstract: Restoring of a database table in the database system (e.g., an in-memory insert-only database system, etc.) is initiated. Thereafter, a transaction log volume storing data log records and multi-version concurrency control (MVCC) log records corresponding to the database table is accessed. Based on such access, data log records corresponding to the database table are replayed while insert and update MVCC log records corresponding to the database table are skipped. Subsequently, restoring of the database table in the database system is finalized. Related apparatus, systems, techniques and articles are also described.

公开(公告)号：US20200301906A1

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

申请号：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.

公开(公告)号：US10706019B2

公开(公告)日：2020-07-07

申请号：US14861438

申请日：2015-09-22

Applicant: SAP SE

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

IPC: G06F17/30 ,  G06F16/176 ,  G06F16/23

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.

公开(公告)号：US10678772B2

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

申请号：US15980974

申请日：2018-05-16

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.

公开(公告)号：US10515059B2

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

申请号：US15665154

申请日：2017-07-31

Applicant: SAP SE

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

IPC: G06F16/00 ,  G06F16/21 ,  G06F16/23 ,  G06F16/2458

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.

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

公开(公告)号：US20180203771A1

公开(公告)日：2018-07-19

申请号：US15410701

申请日：2017-01-19

Applicant: SAP SE

Inventor： Martin Heidel ,  Andreas Tonder ,  Shiping Chen

IPC: G06F11/14 ,  G06F17/30

CPC classification number: G06F11/1471 ,  G06F16/211 ,  G06F2201/80

Abstract: Restoring of a database table in the database system (e.g., an in-memory insert-only database system, etc.) is initiated. Thereafter, a transaction log volume storing data log records and multi-version concurrency control (MVCC) log records corresponding to the database table is accessed. Based on such access, data log records corresponding to the database table are replayed while insert and update MVCC log records corresponding to the database table are skipped. Subsequently, restoring of the database table in the database system is finalized. Related apparatus, systems, techniques and articles are also described.