>> Personally I tend to just separate our database in two: one set of
tables containing only current data with full and simple RI
implemented. All historical data goes into separate "_hist" tables with
additional valid_from/to columns and without referential integrity. <<
A classic data warehouse. I tend to leave them in the same table for
awhile, with a VIEW that gives the current rows for the application,
then move them at the end of the year or quarter to the warehouse.
Received on Thu Dec 09 2004 - 09:01:59 CST
