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

公开(公告)号：US10769034B2

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

申请号：US15452391

申请日：2017-03-07

Applicant: SAP SE

Inventor： Sarika Iyer ,  Vivek Kandiyanallur ,  Martin Heidel ,  Rolando Blanco ,  Stephan Kottler ,  Carsten Thiel ,  Peter Steinemann ,  Jörn Schmidt ,  Colin Florendo ,  Michael Muehle ,  Chaitanya Gottipati

IPC: G06F17/30 ,  G06F11/14 ,  G06F16/23 ,  G06F16/2453

Abstract: Objects across multiple database manipulation language (DML) redo log records are cached, during continuous replay of redo log records on a secondary system, for the same table partition to enable reuse of such cached objects. Later, these cached objects can be reused as they are accessed during the sequential processing of DML redo records for a specific table partition.

公开(公告)号：US20180260287A1

公开(公告)日：2018-09-13

申请号：US15452391

申请日：2017-03-07

Applicant: SAP SE

Inventor： Sarika Iyer ,  Vivek Kandiyanallur ,  Martin Heidel ,  Rolando Blanco ,  Stephan Kottler ,  Carsten Thiel ,  Peter Steinemann ,  Jörn Schmidt ,  Colin Florendo ,  Michael Muehle ,  Chaitanya Gottipati

IPC: G06F11/14 ,  G06F17/30

Abstract: Objects across multiple database manipulation language (DML) redo log records are cached, during continuous replay of redo log records on a secondary system, for the same table partition to enable reuse of such cached objects. Later, these cached objects can be reused as they are accessed during the sequential processing of DML redo records for a specific table partition.