Patent · US Active

System versioned table with transactional system time

US11886424B2 · kind B2 · utility

0Cited by

2References

18Claims

0Family size

Assignee

SAP SE · DE

Inventors

Bernhard Scheirle · Leimen, DE
Andreas Tonder · Weinheim, DE
Carsten Thiel · Heidelberg, DE
Guenter Radestock · Karlsruhe, DE
Thomas Legler · Walldorf, DE
Martin Heidel · Walldorf, DE
Robert Schulze · Walldorf, DE
Joern Schmidt · Walldorf, DE
Rolando Blanco · Schreiber, CA

Key dates

Filing date	Sep 22, 2021
Grant date	Jan 30, 2024
Priority date	—
Expiry date	Mar 11, 2042

Classification

Technology area (CPC G)Physics
CPC primaryG06F16/2365
WIPO fieldComputer technology
WIPO sectorElectrical engineering

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.

Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.