Invention Grant
- Patent Title: System versioned table with transactional system time
-
Application No.: US17481644Application Date: 2021-09-22
-
Publication No.: US11886424B2Publication Date: 2024-01-30
- 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
- Agency: Mintz Levin Cohn Ferris Glovsky and Popeo, P.C.
- Main IPC: G06F16/20
- IPC: G06F16/20 ; 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.
Public/Granted literature
- US20230086162A1 SYSTEM VERSIONED TABLE WITH TRANSACTIONAL SYSTEM TIME Public/Granted day:2023-03-23
Information query