Just wondering...

Do any of you guys have experience implementing temporal databases?

I'm trying to get the hang of it, and for my next project I want to go ahead and implement Valid Time and Transaction Time for all of my entities.

The big headache I foresee right now is that neither of the DBMS's that I have experience with (MS SQL Server / MySQL) have any native support for the concept, so far as I know.

So I'll have to meticulously impose all the temporal constraints on my own, table by table.

I guess I'm just looking for general advice on common problems that come up when trying to design and implement a temporal schema.

Much obliged for your wisdom.

My method is to design the base schema without temporal dimensions, and then add an archive table for each base table.
This script will create the archive tables for you.