Re: modelling history in a database

From: Anton Versteeg <>
Date: Fri, 14 Feb 2003 11:30:09 +0100
Message-ID: <>

Depending on the usage of the history table, one could leave away the 'new data' part, since the 'new data' can be found somewhere else: either in a following history entry or in the original table.

stu wrote:

> "Jason" <> wrote in message
> > Jan Marten Visser <> wrote in message
> news:<>...
> > 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

Anton Versteeg
DB2 Specialist
IBM Netherlands
Received on Fri Feb 14 2003 - 11:30:09 CET

Original text of this message