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

George,

I'd like to thank you for the link as well. It looks really interesting
after reading the front matter.

On Oct 16, 2004, at 10:07 AM, George Essig wrote:

>
> --- "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.

I am very interested in hearing what you've done in PostgreSQL related
to this. I probably should read through the text (isn't PDF wonderful?)
before you go into detail, but a brief overview would be great.

Thanks again for your time.

Cheers,

Michael Glaesemann
grzm myrealbox com