Re: Has anyone tried Date/Darwen/Lorentzos's model for temporal data?

--- "Eric D. Nielsen" <nielsene@MIT.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