Commit-time timestamping of temporal rows

A database system comprising:

• one or more nodes;
• a plurality of CPUs, each of the one or more nodes providing access to one or more CPUs;
• a plurality of virtual processes, each of the one or more CPUs providing access to one or more virtual processes;
• each virtual process configured to manage data, including rows from the set of database table rows, stored in one of a plurality of data-storage facilities;
• a process configured to timestamp a base table temporal row affected by a transaction, the temporal row having a row ID, by:
• modifying the temporal row in the base table according to the transaction;
• associating the row ID for the modified temporal row with an identifier for the transaction in a temporal work table;
• upon committing the transaction:
• searching the temporal work table to determine the row ID of the temporal row modified by the transaction;
• and
• saving a commit-time into the temporal row identified by the row ID.

A computer program, stored in a non-transitory computer-readable tangible medium, for timestamping a base table temporal row affected by a transaction, the temporal row having a row ID, the program comprising executable instructions that cause a computer to:

• modify the temporal row in the base table according to the transaction;
• associate the row ID for the modified temporal row with an identifier for the transaction in a temporal work table;
• upon committing the transaction:
• search the temporal work table to determine the row ID of the temporal row modified by the transaction;
• and
• save a commit-time into the temporal row identified by the row ID.