O'Reilly logo

Tera-Tom's 1000 Page e-Book on Teradata Architecture and SQL, 2nd Edition by Tom Coffing, William Coffing

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 12 - Temporal Tables Create Functions

“I became a policeman because I wanted to be in a business where the customer is always wrong.”

– Anonymous

Three types of Temporal Tables

images

 

 

 

Temporal Tables use a Valid Time or Transaction Time or combine both Valid Time and Transaction Time to form Bi-Temporal tables.

CREATING a Bi-Temporal Table

 CREATE MULTISET TABLE Property_Owners
 ( Cust_No        INTEGER
 ,Prop_No         INTEGER
 ,Prop_Val_Time   PERIOD (DATE) NOT NULL as VALIDTIME
 ,Prop_Tran_Time  PERIOD (TIMESTAMP(6) with TIME ZONE)
                      NOT NULL as TRANSACTIONTIME
 ) PRIMARY INDEX(Prop_No) ;

 

 

 

This is a Bi-Temporal Table because one column is aliased ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required