System versioned table with transactional system time

A computer-implemented method, 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.

A non-transitory computer readable medium storing instructions, which when executed by at least one data processor, result in 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.