US 11,886,424 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 Sep. 22, 2021, as Appl. No. 17/481,644.
Prior Publication US 2023/0086162 A1, Mar. 23, 2023
Int. Cl. G06F 16/20 (2019.01); G06F 16/23 (2019.01)
CPC G06F 16/2379 (2019.01) 18 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:
receiving a first transaction inserting a record into a database and a second transaction deleting the record from the database;
determining, based at least 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 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 updating comprises moving the record from the current table to the history table upon an expiration of the validity period.