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
