Craig,
This is a huge subject. I wish I knew more about it, but such as it is,
the bit I do know is too much deal with properly in an email
First the books:
Data Warehouse Toolkit by Kimball
Data Warehouse Life Cycle Toolkit by Kimball
Developing Time Oriented Database Applications in SQL by
Title: Temporal or Time-Oriented Databases (was auditing tables)
The thread on auditing tables and the mention of temporal or time-oriented databases prompted me to ask about a design problem that has recurred on different projects for me. Seeing as this problem has occurred multiple times I