Introduction to Temporal Table Support - Advanced SQL Engine - Teradata Database

Temporal Table Support

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
cjo1556732840654.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1182
lifecycle
previous
Product Category
Teradata Vantage™

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