| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Data Warehousing Woes
Hi Michael,
We have two DW's here. One is a very expensive failure because the design experienced scope creep. The (bonehead) consultants who designed our failed DW decided that they'd make their own design that encompassed everything, and that writing reports was the easy part - they had no idea what the reports would need to do or how the optimizer would react to such a convoluted design. I kind of wish I was staying at my current job because I would love to be part of the redesign now that we know exactly what the reports should return.
One thing I'd push for is a full-blown test environment. At least that way when you go production you know what kind of performance to expect. That may not be possible, but it bit us in the ass, big time. No one could understand why a report would fly through a 15GB database and not through a 150GB database.
Good luck! I think DW is fascinating and I envy you. Lisa
Michael Johnson <mjohnson138_at_yahoo.com> on 06/22/2000 01:15:31 AM
Please respond to ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: (bcc: Lisa Koivu/GELCO)
Subject: Data Warehousing Woes
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 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 also send the HELP command for other information (like subscribing).Received on Thu Jun 22 2000 - 08:34:50 CDT
 |
 |