17.05 - Introduction to Temporal Table Support - Teradata Database

Teradata Vantage™ - Temporal Table Support

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
17.05
created_date
June 2020
category
Programming Reference
featnum
B035-1182-170K

Teradata Database provides the built-in capabilities that are required in a temporal database management system. Temporal data types and temporal statements facilitate creating applications that need to represent time and the information that changes over time.

Feature Description
Temporal data types The period data type represents an anchored duration of time.
Temporal column attributes In addition to user-defined time, which can be represented by using DateTime data types such as DATE and TIMESTAMP, Teradata temporal table support adds the capability to add valid-time and transaction-time dimensions to tables, by means of temporal column attributes.
Temporal statements Temporal variations of existing statements let you create and alter temporal tables, and query and modify data that changes over time.

Queries and modifications can include temporal qualifiers that reference a time dimension and act as criteria or selectors on the data. They affect only the data that meets the time criterion. Temporal DML statements can be generally qualified as:

  • CURRENT, affecting only data that is currently in effect
  • SEQUENCED, affecting only data that is in effect for a specified time period
  • AS OF, affecting only data that is in effect at a specified point in time
  • NONSEQUENCED, where the time dimension is ignored, the table is treated as a nontemporal table, and the DML statement is applied to all data in the table