Oracle-L: RE: Data warehouse book- need recommendation please

From: Stephane Paquette <stephane.paquette_at_standardlife.ca>
Date: Tue, 13 May 2003 13:47:20 -0800
Message-ID: <F001.00598218.20030513134720@fatcity.com>

The architecture team here has done the draft for the BI infrastucture. It's clearly going the Inmon way as the datawarehouses will be normalized and the datamarts will be develop in an OLAP fashion (we do have try Essbase in the past) or in relational databases using star schemas.

I've put on my todo list to talk to the corporate architect so I can see about pros/cons of it.
It's always time to learn...

Stephane

-----Original Message-----

WILLIAMS
Sent: Tuesday, May 13, 2003 5:02 PM
To: Multiple recipients of list ORACLE-L

Jared

Well, it depends on whether you are a follower of the Inmon philosophy or the Kimball philosophy. The two men have actually had public debates at some conventions. For me the answer was easy. I could never understand anything Inmon wrote and I clearly understood everything Kimball wrote.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----

Sent: Tuesday, May 13, 2003 1:39 PM
To: ORACLE-L_at_fatcity.com
Cc: DENNIS WILLIAMS
Importance: High

Actually, according to Inmon, a data warehouse *is* normalized.

Data marts are not.

Jared

DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM> Sent by: root_at_fatcity.com
05/13/2003 08:40 AM
Please respond to ORACLE-L

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc:
        Subject:        RE: Data warehouse book- need recommendation please

Sami

The most important thing to understand is that the rules you've worked hard to learn as a DBA are different for data warehousing. You have stuff to
unlearn. Like letting go of "fully normalized". Start by accessing Ralph Kimball's site http://www.ralphkimball.com <http://www.ralphkimball.com> He posts a lot of the basics of Data Warehousing on his site in form of magazine articles he's written over the years. In my opinion, Ralph is better at explaining the "big picture" of DW than anyone else. Once you get
a good grasp of what DW is all about, actually creating a data warehouse mostly involves applying the DBA knowledge you already have. But fail to get
the big picture and you will probably have a disaster on your hands.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----

Sent: Tuesday, May 13, 2003 5:14 AM
To: Multiple recipients of list ORACLE-L

Hi All,

Could someone recommend a Data warehouse book for the person who has DBA background?

Also if possible please give me some resource link(docs/URL/etc) to start with.

Thanks in advance
Sami

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: DENNIS WILLIAMS
INET: DWILLIAMS_at_LIFETOUCH.COM

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services


---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: DENNIS WILLIAMS
INET: DWILLIAMS_at_LIFETOUCH.COM

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services


---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Stephane Paquette
INET: stephane.paquette_at_standardlife.ca

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services


---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message