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_at_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 - 16:10:09 CET

Original text of this message