| 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[2]: Manager decrees "his" data warehouse design. Help!
I've had a similar, although not identical situation some couple of years ago
that never fully corrected itself.
The CIO wanted a data warehouse & employed a math specialist with some database experience to handle it. My biggest problem was this toad went and got an OCP certificate just from reading the books & thought he was the king of the hill. Anyway, he came up with this totally denormalized configuration, although indexed, that was totally dumb. Many of the management types were for his design as the web apps he had also created were 'pretty'. OK, so I asked him to estimate how much disk space he would need. His was about 30GB of disk. I took his demo app & calculated average row length, and all of the other stuff + indexes and came up with more like half a terrabyte. When the $$$$ needed were presented to the CIO there were a lot of questions, recalculating, etc... presented all of which supported my call for an extra EMC cabinet full of disks (about $2.5M at the time). The data structures then made some very dramatic changes, initial implementation was done on 30GB of drives but out grew that in 2 months. We then acquired an additional 30GB of disk, blew through that in 2 months. At that point the individual submitted his resignation & we acquired an additional 100GB of disk & limited the data retention to 6 months.
Completely redesigning the warehouse is a Q4 project this year. So hang in there, reality is one beast that does bite the hand that feeds it.
Dick Goulet
____________________Reply Separator____________________ Author: Rachel Carmichael <wisernet100_at_yahoo.com> Date: 2/27/02 7:48 AM
You have this decree in writing?
Okay, once you get that. Do what he wants, making sure everyone knows that this great new database design and application are all his idea (do this with a smile, with enthusiasm if you can manage it)
hang on and wait for it all to fall apart.
Otherwise, do you have any friends or connections in the user base? or to his manager? Write up, without emotion, what you see as the problems to this approach. Be very logical, with explicit reasons (not "this is crap")
pass it around. and be prepared to make an enemy
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: wisernet100_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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: dgoulet_at_vicr.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 Wed Feb 27 2002 - 10:18:30 CST
 |
 |