Re: modelling history in a database
Date: Fri, 14 Feb 2003 14:03:02 +0100
I do. It is one of the strategies you'll find in:
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.
> "Jason" <pmorrison_at_4lpi.com> wrote in message
> > Jan Marten Visser <jan.marten.visser_at_virgil.nl> wrote in message
> > 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?
Received on Fri Feb 14 2003 - 14:03:02 CET