That's not panicking, just common sense.
Too many data warehouse projects went down the drain
so you need to learn all you can before starting such project.

Yechiel Adar
Mehish
----- Original Message ----- 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Thursday, May 23, 2002 3:13 PM


> Dennis,
> 
> I have on my desk, all in varying stages of being read: 
> Inmon's book Building the Data Warehouse (very understandable)
> 
> Kimball's articles from his site and from the Intelligententerprise.com
> site (somewhat understandable, I think you need a base from which to
> read his articles). His books are on order and should arrive today
> 
> Tim Gorman's book Essential Oracle8i Data Warehousing (this I haven't
> started, as Tim tells me to read it AFTER I have a basic understanding
> of data warehousing)
> 
> The Oracle8i Data Warehousing documentation (actually pretty readable
> and understandable)
> 
> Ya think I might be over-researching this stuff and panicking a bit?
> 
> Rachel
> 
> --- DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote:
> > Ian, 
> > 
> >   - In the beginning was the data warehouse and yeah it was good. It
> > would
> > solve all corporate problems and would encompass all corporate data
> > so all
> > corporate minions would see the same data.
> >   - But yeah it took so long to create the corporate data warehouse
> > that
> > management despaired and canceled the project. Or by the time the
> > monster
> > data warehouse came blinking and straining into the daylight all the
> > users
> > said that the company had evolved in the meanwhile and the warehouse
> > was
> > obsolete.
> >   - So data warehouses gained a bad rep from corporate managers and
> > yeah
> > none would fain to propose the conception of a data warehouse for
> > fear of
> > castigation.
> >   - Then some marketing interns bribed a DBA to send them data
> > weekly. And
> > they stored this data in a database and lo, their superiors were
> > impressed.
> >   - Everyone was in awe of the marketing database, but none dared
> > tarnish it
> > by speaking the name which shall not be mentioned, so it was
> > christened a
> > "data mart".
> >   - And lo, the data marts multiplied and were fruitful. And the DBA
> > cursed
> > the day she was weak and did give data to the marketing interns.
> >   - Then another prophet did arise and did challenge the prophet
> > Kimball.
> > His name was Inmon. And he did claim to be the progenitor of data
> > warehouses. And therefore all should do data warehousing his way and
> > use his
> > terms.
> >   - And great confusion arose over the land. And many debates ensued,
> > including some face to face between Inmon and Kimball. And terms such
> > as
> > Operational Data Store (ODS) were bandied about.
> >   - And some said that queries against the ODS were acceptable and
> > others
> > deemed them forbidden. And some said that if it looks like a data
> > warehouse
> > and smells like a data warehouse it verily indeed is a data
> > warehouse.
> >   - And consultants warred against consultants and did call the other
> > consultants ignoramuses in front of management such that nobody knew
> > what
> > anybody was talking about.
> >   - And the DBAs said that creating a data warehouse or data mart was
> > not
> > nearly as hard as figuring out what to call it.
> > 
> > The moral of the story is to figure out what you need to do and be
> > aware
> > that different authors use the same terms for different purposes and
> > coin
> > their own terms. Personally, I have understood everything that
> > Kimball has
> > written and have never been able to read one of Inmon's articles to
> > the end.
> > But maybe that is just me.
> > Dennis Williams
> > DBA
> > Lifetouch, Inc.
> > [EMAIL PROTECTED]
> > 
> > 
> > -----Original Message-----
> > Sent: Wednesday, May 22, 2002 2:38 PM
> > To: Multiple recipients of list ORACLE-L
> > Outdated?
> > 
> > 
> > Ian,
> > 
> > Good question.  I think that I've seen more recenct references in
> > articles
> > that state the current thinking of DW/DM.  I'm sure that I've seen
> > Inmon
> > refer to them that way, or maybe it was Richard Winter?
> > 
> > Anyway, I guess that part is a bit dated.  There is so much good 
> > information
> > in that book though, that it's still worth its weight in gold.  You
> > won't 
> > find too many
> > publications for $60 that will take you step by step through building
> > an 
> > entire
> > data warehouse, including the infrastructure.
> > 
> > Jared
> > 
> > 
> > 
> > 
> > 
> > 
> > "MacGregor, Ian A." <[EMAIL PROTECTED]>
> > Sent by: [EMAIL PROTECTED]
> > 05/21/2002 05:48 PM
> > Please respond to ORACLE-L
> > 
> >  
> >         To:     Multiple recipients of list ORACLE-L
> > <[EMAIL PROTECTED]>
> >         cc: 
> >         Subject:        RE: Data Warehouse experts, a simple question
> > for
> > you| Outdated?
> > 
> > 
> > I am new to his books, three chapters in.  The first release of the
> > "Data 
> > Warehouse Toolkit"  defines a data warehouse much as a data mart is
> > today. 
> >  Today we think of a data warehouse as having a highly normalized 
> > structure which stores information from various sources.  We build
> > data 
> > marts with structures optimized for querying; e.g., star schemas,
> > from the 
> >  warehouse.  Kimball writes of the warehouse itself being based on a
> > star 
> > schema.
> > 
> > The term data warehouse has not been immutable over the years.  It
> > was 
> > probably defined exactly as he has done when the book was first
> > written. 
> > Do his new books redefine "data warehouse"? 
> > 
> > Ian MacGregor
> > Stanford Linear Accelerator Center
> > [EMAIL PROTECTED]
> > 
> > -----Original Message-----
> > Sent: Tuesday, May 21, 2002 2:16 PM
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > I second Jared's opinion. Ralph's books are clear and easy to read.
> > This 
> > is
> > the fundamentals of data warehousing. 
> > Dennis Williams
> > DBA
> > Lifetouch, Inc.
> > [EMAIL PROTECTED]
> > 
> > 
> > -----Original Message-----
> > Sent: Tuesday, May 21, 2002 2:30 PM
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > Yup, $60, and worth every penny.
> > 
> > It may be 4 years old, but the information is still pertinent.
> > 
> > Jared
> > 
> > 
> > 
> > 
> > 
> > Joe Testa <[EMAIL PROTECTED]>
> > Sent by: [EMAIL PROTECTED]
> > 05/20/2002 05:53 PM
> > Please respond to ORACLE-L
> > 
> >  
> >         To:     Multiple recipients of list ORACLE-L 
> > <[EMAIL PROTECTED]>
> >         cc: 
> >         Subject:        Re: Data Warehouse experts, a simple question
> > for
> > you
> > 
> > 
> > looks like published aug of 98 for that book?, like $60?
> > 
> > joe
> > 
> > 
> > [EMAIL PROTECTED] wrote:
> > 
> > >Joe,
> > >
> > >Add a generated PK to the time dimension.  The PK is stored
> > >as an FK in the fact table.
> > >
> > >That way you can select from the time dimension by year, day, qtr, 
> > >whatever,
> > >and easily pick out the correct fact table rows.
> > >
> > >"The Data Warehouse Lifecycle Toolkit" includes a spreadsheet to
> > generate
> > 
> === message truncated ===
> 
> 
> __________________________________________________
> Do You Yahoo!?
> LAUNCH - Your Yahoo! Music Experience
> http://launch.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Rachel Carmichael
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California        -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (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: Yechiel Adar
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).

Reply via email to