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: Recommendation on book for database theory

Re: Recommendation on book for database theory

From: David Cressey <david_at_dcressey.com>
Date: Tue, 19 Nov 2002 15:10:09 GMT
Message-ID: <lvsC9.280$0I3.28495@petpeeve.ziplink.net> 





Ralph Kimball is a good author to learn about star schemas.



www.ralphkimball.com



Star schemas are typically NOT fully normalized.  That means that keeping
them up to date can be a little tricky.


But for environments where the update is a fairly tightly controlled process
(ETL) this can be managed.



The benefits are greater flexibility in the use of the data to support both
OLAP and standard reporting.



--
Regards,
    David Cressey
    www.dcressey.com


Received on Tue Nov 19 2002 - 09:10:09 CST












Original text of this message













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