How can I maintain referential integrity between TEMPORAL tables?

Database
Enthusiast

How can I maintain referential integrity between TEMPORAL tables?

I've read the most relevant references from the TD 13.10 documents, but as I see, only soft RI-s are available with temporality - so you must do it yourself...

Which is the most acceptable (and also the simplest) solution maintaining RI's between temporal tables? TRIGGERs?

3 REPLIES
Enthusiast

Re: How can I maintain referential integrity between TEMPORAL tables?

The TD 13.10's "Temporal Table Support" reference contains the appendix D, which is helping to validating temporal referential integrity manually...

It offers a set of solution (in SQL code, containing various cases) and says that the most acceptable way is to embed these codes into triggers. Only the "how" is missing...

The main problem's description is found here:

Problem with enforcing TEMPORAL RI with triggers in TD 13.10...

and the latest is here:

How can I embed a WITH clause into a SELECT statement in Teradata 13.10?

Enthusiast

Re: How can I maintain referential integrity between TEMPORAL tables?

Anyone who is familiar with TD's temporal support? It would be important in my thesis...

Enthusiast

Re: How can I maintain referential integrity between TEMPORAL tables?

I'm current looking for answers too.

I'm was suprised to find that only soft RI is available and it seems like a bit of a 'cop out' to sling a load of SQL into the end of the Temporal support documentation.

Oh well, perhaps it's coming in a release soon.