Chapter 12

Basic Temporal Queries

This chapter introduces an alternative syntax for temporal queries, and also includes suggestions for semantically more robust temporal queries than standard insert, update and delete temporal queries. It includes step-by-step descriptions of single-table and multi-table queries, and of point-in-time and temporal range queries.

Keywords

assert; assertion time; view; coalesce; decoalesce; inscription; life history; query canonical form; referent; state time; state; statement; temporal upward compatibility

The queries discussed in this and the following chapter, like the transactions discussed in the previous chapter, are not based on either the ISO or the TSQL2 standards. These queries, like those transactions, use ...

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.