Invention Publication
- Patent Title: SYSTEM VERSIONED TABLE WITH TRANSACTIONAL SYSTEM TIME
-
Application No.: US18530819Application Date: 2023-12-06
-
Publication No.: US20240111757A1Publication Date: 2024-04-04
- Inventor: Bernhard Scheirle , Andreas Tonder , Carsten Thiel , Guenter Radestock , Thomas Legler , Martin Heidel , Robert Schulze , Joern Schmidt , Rolando Blanco
- Applicant: SAP SE
- Applicant Address: DE Walldorf
- Assignee: SAP SE
- Current Assignee: SAP SE
- Current Assignee Address: DE Walldorf
- Main IPC: G06F16/23
- 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.
Information query