By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,777 Members | 1,755 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,777 IT Pros & Developers. It's quick & easy.

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

P: n/a
I'm in the process of adding more historic information to one of my
databases. I've liked the theoretical treatment of the concept in
"Temporal Data and the Relational Model", by Date, Darwen, & Lorentzos.
A lot of it is not realizable without a lot of user defined
types/functions/etc. I was wondering if anyone else has tried to use
their approach as a base for their historical databases in PostGreSQL
and has any "lessons learned" to share.

Thank you.

Eric Nielsen
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Nov 23 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a

On Oct 14, 2004, at 5:33 AM, Eric D. Nielsen wrote:
I'm in the process of adding more historic information to one of my
databases. I've liked the theoretical treatment of the concept in
"Temporal Data and the Relational Model", by Date, Darwen, &
Lorentzos. A lot of it is not realizable without a lot of user
defined types/functions/etc. I was wondering if anyone else has tried
to use their approach as a base for their historical databases in
PostGreSQL and has any "lessons learned" to share.


I'm working on this as well at the moment. No insights or lessons
learned yet though. :) I'd also like to see an updated tinterval type
(there's a deprecated one lurking about in the code) that used the
current timestamptz implementation rather than abstime. I'd like to
work on making this datatype and corresponding functions. Need to learn
some c :)
Michael Glaesemann
grzm myrealbox com
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Nov 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.