Chapter 8

Temporal Tables Create Functions

“One thing you can't recycle is wasted time.”

– Anonymous

Table of Contents Chapter 8 – Temporal Tables Create Functions

Three types of Temporal Tables

CREATING a Bi-Temporal Table

PERIOD Data Types

Bi-Temporal Data Type Standards

Bi-Temporal Example – Tera-Tom buys!

A Look at the Temporal Results

Bi-Temporal Example – Tera-Tom Sells!

Bi-Temporal Example – How the data looks!

Normal SQL for Bi-Temporal Tables

NONSEQUENCED SQL for Temporal Tables

AS OF SQL for Temporal Tables

NONSEQUENCED for Both

Bi-Temporal Example – Socrates is DELETED!

Property_Owners Before DELETE on April 1st

Three types of Temporal Tables

The Three types of Temporal Tables are:

Valid Time Temporal ...

Get Tera-Tom's 1000 page e-Book on Teradata now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.