Re: modelling history in a database

From: Jason W. Paul <nobody_at_nowhere.com>
Date: Wed, 12 Feb 2003 16:29:00 -0500
Message-ID: <3e4abc95$0$99027$a0465688_at_nnrp.fuse.net>


This is, hands-down, the best reference for us "everyday practioner" types (non-academics that don't understand relational algebra/calculus) on temporal data and it's issues that I have ever read! Bought it about 2 years ago. Well worth it.

"Alan Gutierrez" <ajglist_at_izzy.net> wrote in message news:Pine.WNT.4.53.0302120847400.1332_at_CX1198465-B...
> On Wed, 12 Feb 2003, Jan Marten Visser wrote:
>
> > In the database I am designing right now, are a few entities of which
> > every change has to be recorded. In other words: i have to be able to
> > reset to any moment in the past. Think of it as a kind of version
> > control.
> >
> > I am wondering if any of you now any literature/papers about how to
> > model history in an rdbms.
>
> Yesterday, the postman brought me Developing Time-Oriented Database
> Applications in SQL, by Richard T. Snodgrass. I've not read it yet. It
> was recommended by the group.
>
> I'd be interested to hear about any other materials you find, since I am
> pursuing a similar course of study.
>
> Alan Gutierrez - ajglist_at_izzy.net
>
Received on Wed Feb 12 2003 - 22:29:00 CET

Original text of this message