US 12,332,874 B2
System versioned table with transactional system time
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); and Rolando Blanco, Waterloo (CA)
Assigned to SAP SE, Walldorf (DE)
Filed by SAP SE, Walldorf (DE)
Filed on Dec. 6, 2023, as Appl. No. 18/530,819.
Application 18/530,819 is a continuation of application No. 17/481,644, filed on Sep. 22, 2021, granted, now 11,886,424.
Prior Publication US 2024/0111757 A1, Apr. 4, 2024
This patent is subject to a terminal disclaimer.
Int. Cl. G06F 16/00 (2019.01); G06F 16/23 (2019.01)
CPC G06F 16/2379 (2019.01) 19 Claims
OG exemplary drawing
 
1. A system, comprising:
at least one data processor; and
at least one memory storing instructions which, when executed by the at least one data processor, cause operations comprising:
committing a first transaction at a first commit time and a second transaction at a second commit time, wherein the first transaction comprises inserting a record into a database and the second transaction comprises deleting the record from the database;
determining, based at least on the first commit time at which the first transaction is committed and the second commit time at which the second transaction is committed, a validity period of the record; and
updating, based at least on the validity period of the record, a current table and/or a history table of a system versioned table to include the record, wherein the record is moved from the current table to the history table upon an expiration of the validity period, wherein the record is moved from the current table to the history table upon an expiration of the validity period.