On Thu, 2007-06-14 at 10:57 -0700, Lza wrote:
> Can anyone help me with this problem?
>
> I have a table in my database that holds information on policies and
> this table is linked to a number of other tables. I need to be able to
> keep a history of all changes to a policy over time. The other tables
> that are linked to policy also need to store historical data. When I
> run a query on the policy table for a certain period, I also need to
> be able to pull the correct related rows (i.e. the information that
> would have been in the table at that time) from the tables linked to
> it.
>
> Does anyone have any suggestions on how to store historical
> information in databases? Any good resources (books, etc..) that cover
> this information?
>
I highly recommend _Temporal Data and the Relational Model_ by C.J.
Date, Hugh Darwen, and Nikos Lorentzos.
C.J. Date is my favorite database author, and he is highly respected.
Regards,
Jeff Davis