Re: Keeping old revisions of data?

Dave,

There are two widely used models for the design of a relational database: the OLTP model and the data warehouse model. OLTP systems tend to obliterate their history in the interest of speed and compactness.

Data warehouses tend to accumulated data over time, including, sometimes, historical values of present rows.

Take a look at a good reference on data warehousing to see how they cope with records that change.

Dave Kimmel wrote in message ...
>What is the best way to keep old revisions of data in a relational
>database?
>
 

>My main problem is this: Since these are legal documents that define
>the policies and procedures that the office uses, and since these
>policies and procedures change over time, we need to store all of the
>old revisions of the documents. These also need to be able to be
>retrieved quickly.
>
>Does anyone have experience with something like this? What would be
>the best way to approach this?
>
>Thanks!
>-- Dave Kimmel
> criscokid_at_v-wave.com
> ICQ: 5615049
Received on Fri Jul 14 2000 - 00:00:00 CEST