Chapter 11

Temporal Transactions

Just as a conventional insert transaction will fail if its target table already contains a matching row, a temporal insert will fail if its target table already contains a matching row anywhere within the transaction’s temporal scope. After analyzing basic temporal transactions – updates and deletes as well as inserts – this chapter introduces and analyzes Whenever transactions, which will behave like basic temporal transactions whenever, within the transaction’s temporal scope, it would be valid to carry them out.

Keywords

bitemporal cell; clock tick; decoalesce; episode; inscription; referent; statement; sub-interval; temporal scope; withdraw

The syntax used in this book for transactions is not that of the 2011 ...

Get Bitemporal Data now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.