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