What is temporal data?

In a table with temporal support, the header represents a predicate with at least one time parameter that represents when the rest of the predicate is valid; the complete predicate is therefore a timestamped predicate. Rows represent timestamped propositions, and the row's valid time period is expressed with one of two attributes: since (for semi temporal data) or during (for fully temporal data); the latter attribute is usually represented with two values, from and to. The following table shows the original and two additional timestamped versions of an exemplary Suppliers table:

Original Suppliers table and two tables ...

Get SQL Server 2017 Developer's Guide 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.