Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

BiTemporal Tables, anyone?

I'm doing some interesting research on using BiTemporal tables and I was wondering if anyone out there has any real-world experience using these. Basically these are tables where you have effective dates and audit dates in the same table. You may know these by other names, such as 'Valid Time States" (Effective Dates) and "Transaction Time States" (Audit dates). These are complicated but quite promising...does anyone have any real-world feedback on using these?

Comments

No comments.

Leave a Comment

Please register or log in to leave a comment.