Re: Has anyone tried Date/Darwen/Lorentzos's model for temporal data?
От | Michael Glaesemann |
---|---|
Тема | Re: Has anyone tried Date/Darwen/Lorentzos's model for temporal data? |
Дата | |
Msg-id | AF73B16C-1F29-11D9-93C0-000A95C88220@myrealbox.com обсуждение исходный текст |
Ответ на | Re: Has anyone tried Date/Darwen/Lorentzos's model for temporal data? (George Essig <george_essig@yahoo.com>) |
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: