Re: primary and foregin keys

From: <>
Date: 27 Dec 2004 06:57:52 -0800
Message-ID: <>

I'm a little bit surprised:

>>In an RDBMS, all the current data would be in one table, VIEWs would
provide quarterly summaries and the old data would be moved to the data warehouse, never purged

in many shops data gets loaded into the DW frequently (such as monthly), but is still kept in the OLTP for a year or two. Then the data is just purged from OLTP... Received on Mon Dec 27 2004 - 15:57:52 CET

Original text of this message