“I became a policeman because I wanted to be in a business where the customer is always wrong.”
Three types of Temporal Tables
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 ...