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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Data warehouse book- need recommendation please

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
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: 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
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). Received on Tue May 13 2003 - 16:47:20 CDT

Original text of this message

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