Re: Data Warehousing books for Oracle 9i (once again)

Thanks for the reference, Stephane!

Gary Dodge was the primary author of "Oracle8 Data Warehousing" and "Essential Oracle8i Data Warehousing", both from John Wiley and Sons (not Oracle Press). I was his co-author. We started "Essential Oracle9i Data Warehousing" late last year, but for a variety of reasons we will not be completing that. Most of the reasons have to do with objections from family and personal conscience on starting another after-hours book project, coupled with our desire to reorganize the book (into an end-to-end case-study) and our inability to find facilities to make that happen within the period specified by Wiley.

...remember how Margaret Mitchell took 50 years to write "Gone with the Wind"? Well, that type of schedule is certainly gone with the wind, especially for technical computer books...

I can recommend "Essential Oracle8i DW", which would have the obvious lack of mention of external tables, table functions, and other 9i features like OLAP and data mining features, but has a lot of discussion on materialized views, direct-path/append loading, parallel execution, partitioning, and other important still-relevant topics...

...plus, the thing of which I am most proud: the incorporation of relevant quotes from Monty Python, Mel Brooks, Peter Sellers, The Three Stooges, and other masters of data warehousing at the start of each chapter. I am especially proud of the Monty Python quote from "The Meaning of Life" about the "machine that goes *ping*" which begins the chapter on Oracle Parallel Server -- talk about serendipity!...

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Wednesday, November 27, 2002 2:04 PM

> Just to clarify.
>
> The Oracle 8 Data Warehousing I feel that did not
> really cover what it was supposed was the one from
> Oracle Press not the one from Tim Gorman.
>
> Tim Gorman has wrote 2 good books (maybe more ?) on DW
> : Oracle8 Data Warehousing, Essential Oracle8i Data
> Warehousing: Designing, Building, and Managing Oracle
> Data Warehouses .
>
>
>
> --- Stephane Paquette <stephane_paquette_at_yahoo.com> a
> écrit : > Even 1$ is too much for "Oracle8 Data
> Warehousing" !
> >
> > We're not yet on 9i so I've not checked about that
> > kind of book.
> > For DW only, check Ralph Kimball's book and the IBM
> > red book site( http://www.redbooks.ibm.com/). There
> > is
> > an excellent document (PDF) about datawarehousing in
> > general.
> > The data warehouse institute
> > (http://www.dw-institute.com) offers papers and
> > training.
> >
> > On 8i, I can recommend Tim Gorman's book.
> >
> > DW are never reorganised but updated on the
> > frequency
> > needed by the business needs.
> >
> > HTH
> >
> > --- "Jesse, Rich" <Rich.Jesse_at_qtiworld.com> a écrit
> > :
> > > Yes, I know -- old topic, but a search thru the
> > 440
> > > DW posts on the fatcity
> > > archives didn't reveal much.
> > >
> > > Not having much of any knowledge on DW/DM, I
> > picked
> > > up the Oracle Press'
> > > "Oracle8 Data Warehousing" book for $1 on the
> > > clearance rack in hopes that
> > > an overall view of the procedures necessary for
> > > DW/DM building and
> > > maintenance to give me some idea of what I'm up
> > > against.
> > >
> > > I can't help but be completely confused by this
> > book
> > > because it doesn't seem
> > > to cover DW/DM maintenance at all. It has a
> > chapter
> > > dedicated to various
> > > ways to populate the DW/DM, but not how to keep
> > the
> > > data up-to-date. Do DWs
> > > get completely regenerated on a
> > > daily/weekly/periodic basis? This just
> > > doesn't seem feasible to me, especially for large
> > > (1T+) DWs.
> > >
> > > Am I missing something? Are newer revs of this
> > book
> > > better? Are there any
> > > better DW books geared specifically for Oracle9i?
> > > Does Martha know that
> > > John is really her long-lost brother?
> > >
> > > From past posts (Jared's?), I'm thinking that we'd
> > > be at least picking up
> > > Kimball's DW Toolkit, 2nd Ed. and hopefully we'll
> > > get some training in for
> > > this, too, but I would like something specific to
> > > DWs on Oracle 9i.
> > >
> > >
> > > TIA! :)
> > > Rich
> > >
> > >
> > > Rich Jesse
> > System/Database
> > > Administrator
> > > Rich.Jesse_at_qtiworld.com Quad/Tech
> > > International, Sussex, WI USA
> > >
> > >
> > > --
> > > Please see the official ORACLE-L FAQ:
> > > http://www.orafaq.com
> > > --
> > > Author: Jesse, Rich
> > > INET: Rich.Jesse_at_qtiworld.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).
> > >
> >
> > =====
> > Stéphane Paquette
> > DBA Oracle et DB2, consultant entrepôt de données
> > Oracle and DB2 DBA, datawarehouse consultant
> > stephane_paquette_at_yahoo.com
> >
> >
> __________________________________________________________
> > Lèche-vitrine ou lèche-écran ?
> > magasinage.yahoo.ca
> > --
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > --
> > Author: =?iso-8859-1?q?Stephane=20Paquette?=
> > INET: stephane_paquette_at_yahoo.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).
> >
>
> =====
> Stéphane Paquette
> DBA Oracle et DB2, consultant entrepôt de données
> Oracle and DB2 DBA, datawarehouse consultant
> stephane_paquette_at_yahoo.com
>
> __________________________________________________________
> Lèche-vitrine ou lèche-écran ?
> magasinage.yahoo.ca
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: =?iso-8859-1?q?Stephane=20Paquette?=
> INET: stephane_paquette_at_yahoo.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.com
-- 
Author: Tim Gorman
  INET: Tim_at_SageLogix.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).