Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: primary and foregin keys

Re: primary and foregin keys

From: <ak_tiredofspam_at_yahoo.com>
Date: 27 Dec 2004 06:57:52 -0800
Message-ID: <1104159472.359709.42020@f14g2000cwb.googlegroups.com> 





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 - 08:57:52 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US