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 Warehousing Woes

RE: Data Warehousing Woes

From: Klavers, Richard <R.Klavers_at_arbeidsbureau.nl>
Date: Thu, 22 Jun 2000 13:56:14 +0200
Message-Id: <10536.110128@fatcity.com>


Hi,

I think the website www.dwinfocenter.org is a good place to start, you'll at least get some ideas of what a DW is all about.

Regards, Richard Klavers

Tel.: 00 31 (0)79 371 2543
Fax: 00 31 (0)79 371 2529
E-mail: r.klavers_at_arbeidsbureau.nl
Zoetermeer, the Netherlands

> ----------
> Van: Patrick Mullen[SMTP:Patrick.Mullen_at_wfp.org]
> Antwoord naar: ORACLE-L_at_fatcity.com
> Verzonden: donderdag 22 juni 2000 11:10
> Aan: Multiple recipients of list ORACLE-L
> Onderwerp: Re: Data Warehousing Woes
>
>
> Hi Michael
>
> I've learnt a lot about Data Warehousing in the last three years. You
> should try reading some of the standard books by Inmon and co. In my
> humble
> opinion DW can be a bit difficult to grasp at the beginning because one is
> so clogged up with ideas of best practice, efficiency etc. I read some
> books, browsed the internet and tried to create a reporting database from
> our legacy system. It was only after sometime that the penny began to
> slide
> down the slot, that the questions I had to ask always were "what do I
> want?" and "how can I do it?" not "what should one want?" and "how should
> I
> do it?". The point is the theories only go so far. The project should have
> a strong focus. It needs to know what it wants to produce. Anyway ny
> advice
> would be for DW get one of the standard texts (the names escape me for the
> moment), read it, browse the web, visit another site where they already
> have DW and be prepared for a steep learning curve.
>
> On the other hand it could be that your company is just trying to pool all
> its legacy data in one place and hence Oracle. The main objective being
> just to have the data in oracle. We have done something like this, but
> this
> is not data warehousing, it just a matter of data access really and is not
> very complicated.
>
>
> Hi, well as our previous senior database dude has left
> the company and this has left basically just me to
> fend for the company's present db woes. Here's the
> scoop: We're going to soon be moving all of our logs
> and legacy databases into one massive Oracle database.
> Seems to me like a real classic data warehousing /
> reporting project.
>
> The problem? I'm probably between junior and
> intermediate level. There are (guessing here) 20 Gigs
> of data with many more gigs in the future. Now, I
> really enjoy working with Oracle and I would love to
> learn this but I know this is a bit over my head.
>
> So my questions are:
> 1) Where the heck do I start to learn about data
> warehousing? Books, 3rd party tools, etc.
> 2) (serious question) How hard do I push for the
> company to go out and pay $1 billion for a couple of
> data warehouse consultants to at least help us with
> the design and architectural analysis?
>
> Thanks guys,
>
> MJ.
>
> Author: Michael Johnson
> INET: mjohnson138_at_yahoo.com
>
>
> --
> Author: Patrick Mullen
> INET: Patrick.Mullen_at_wfp.org
>
> 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: 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
Received on Thu Jun 22 2000 - 06:56:14 CDT

Original text of this message

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