Re: modelling history in a database

From: Paul Vernon <paul.vernon_at_ukk.ibmm.comm>
Date: Wed, 12 Feb 2003 11:26:00 -0000
Message-ID: <b2db3a$10cq$1@sp15at20.hursley.ibm.com>

"Jan Marten Visser" <jan.marten.visser_at_virgil.nl> wrote in message news:3E4A2B18.C729DD29_at_virgil.nl...
> 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.

Try http://www.hughdarwen.freeola.com/TheThirdManifesto.web/TemporalData.pdf from the site http://www.thethirdmanifesto.com

Regards
Paul Vernon
Business Intelligence, IBM Global Services Received on Wed Feb 12 2003 - 05:26:00 CST