Time and Time Again: Scenario 1

Note: Beginning with this column, it will be increasingly important for readers to refer to our glossary, which can be found on the author’s Web sites (MindfulData.com and InbaseInc.com) with a listing of previous columns and articles. Our glossary-defined terms form a closely-knit conceptual network, and none of these terms can be fully understood apart from their semantic connections with other terms in the Glossary. And a note on the use of italics: we use italics for emphasis, but we also italicize the initial occurrence, from this column forward, of glossary-defined terms.

An original transaction is an insert, update or delete, whose target is an asserted version bi-temporal table. It is the transaction as written by its author and as submitted by the database administrator (DBA) to the database management system (DBMS). A temporal transaction is a physical transaction against an asserted version table. These physical transactions are either physical updates (updates in place) or physical inserts; there are no temporal transactions that are physical deletes.

Time and Time Again: Scenario 1.