Chapter 13

Advanced Temporal Queries

This chapter describes queries which join temporal tables within a temporal interval that consists of more than a single point in time. It presents a step-by-step account of how these queries do their work. Since each step in these queries can be carried out by standard nontemporal SQL, it illustrates how much of the complexity of managing temporal data is encapsulated within bitemporally capable DBMSs.

Keywords

assertion-time interval; coalesce; decoalesce; state; statement; withdraw

The series of steps involved in a DBMS processing each of the temporal queries described in the previous chapter or in this one, are algorithms for transforming those temporal queries into queries that can be carried out by standard ...

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.