--- "Eric D. Nielsen" <nielsene(at)MIT(dot)EDU> wrote:
> Thanks for the Snodgrass reference, it is rather similar and pre-dates
> the book I was looking at. (Same notion of valid/transaction times,
> but Date's non-SQL approach) From a quick skim it doesn't address the
> distinction Date et al draw between historic and current temporal data;
> however it looks very useful for mapping their concepts to SQL.
>
> Eric
You might want to look at Section 7.5 Temporal Partitioning. One table is used to store current
data and another table is used to store historic data.
George