15.00 - Introduction to Temporal Table Support - Teradata Database

Teradata Database Temporal Table Support

prodname
Teradata Database
vrm_release
15.00
category
Programming Reference
featnum
B035-1182-015K

Introduction to Temporal Table Support

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