Re: modelling history in a database

I do. It is one of the strategies you'll find in:

http://www.dbmsmag.com/9604d05.html
http://www.dbmsmag.com/9605d05.html

Author is Ralph Kimball who is rahter authorative in the datawarehousing arena.

Read these, only 10 pages conceptually sound and also specific on the way to implement.

stu wrote:
>
> "Jason" <pmorrison_at_4lpi.com> wrote in message
> news:cf188409.0302131022.3be0e1ad_at_posting.google.com...
> > Jan Marten Visser <jan.marten.visser_at_virgil.nl> wrote in message
> news:<3E4A2B18.C729DD29_at_virgil.nl>...
> > Second, you could create a table Change that has fields for the table,
> > field, old data, new data and date of change.
> >
>
> I like that idea! Have you tried it in practice? Does anybody else have
> any comments on this suggestion?
>
> Cheers
> Stu
Received on Fri Feb 14 2003 - 14:03:02 CET