Rachel,
That's what step #3 is for. Everyone will forget how "bad" the first
warehouse was once the true properly designed warehouse is in place and
delivering the goods. It sounds like there is pressure to deliver
"something" right away - as usual, no time to design it properly. A manager
I used to work for had the best philosophy: "Lets hurry up and do it wrong
so that we can fix it later". Sounds strange, but "that's the business we
choose to be in" (ala The Godfather). *Nobody* wants to spend time and
resources doing research to desig n a system. In a way, it's our (the IT
industry's) fault. We have promised for years that we can develop programs
faster and faster. Now, the managers expect it. But most of them realize
that it's a mistake, but easier to fix after the fact.
my little 2 cents.
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
Sent: Thursday, February 28, 2002 9:08 AM
To: Multiple recipients of list ORACLE-L
Just make sure it's documented that the original idea is NOT yours :)
- "Mercadante, Thomas F" <Thomas.Mercadante_at_Labor.State.Ny.Us> wrote:
> Don,
>
> I agree with Yechiel. You do, after all, work for this guy, and by
> extension, the company. You need to learn to pick your fights. In
> the
> larger picture, does it really matter that much? Are your kids at
> home
> going to be disappointed in you if you build this POC? Take the
> advice of
> most of the members of this list. Build this thing as quickly as
> possible,
> and deliver it to the users. It sounds like they :
> 1). will not use it, so you will get to throw it away in a year
> 2). will use it, and will be disappointed with it and stop using it
> - in
> which case you get to throw it away in a year
> 3). once it is built, re-design it the way you want (in a new
> schema) and,
> when the original fails, announce that you have been "studying the
> matter"
> and have a better version waiting to implement. You will become the
> hero
> all the way around. Your boss will be glad that he delivered the
> first
> "warehouse". He will be happy that, when problems arise from the
> first
> version, that you are "on the spot" with version #2 to solve his
> problems
> and make him look good again.
>
> In the meantime, go home, kiss your wife, hug your kids, pet the dog,
> read a
> good book, go for a walk, throw a baseball with your kids, go to the
> movies
> with your wife, and realize that, like food poisoning, this too will
> pass.
>
> Hope this helps.
>
> Tom Mercadante
> Oracle Certified Professional
>
>
> -----Original Message-----
> Sent: Thursday, February 28, 2002 3:23 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Hello Don
>
> In a more serious mood: DO IT.
> I also had some arguments with my boss over the years and except
> for 2-3 cases (in 20 years) that I told my boss that I will not do
> something
> and if he wants it he can do it himself, my motto was if he wants to
> waste
> resources for something that is obviously an error let him waste it.
> He wants you to waste time and disk space on a system that the users
> will not use: waste your time and the resources. He is management and
> he is the one who calls the shots.
> Just document everything to cover yourself later.
>
> Yechiel Adar, Mehish Computer Services
> adary_at_mehish.co.il
>
> > -----Original Message-----
> > From: Don [SMTP:dondealy_at_teleport.com]
> > Sent: Wed, February 27, 2002 8:48 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Manager decrees "his" data warehouse design. Help!
> >
> > I've lost patience, my temper, and I'm about to quit a job because
> the IT
> > manager has decreed that we will have "his" data warehouse running
> within
> > 24 hours, and we will use his design.
> >
> > 1 - We are NOT to use any kind of views, not even materailzed
> views.
> > 2 - we are not to do any computations, summaries or rollups
> > 3 - we are to have everything in one table
> > 4 - "the" table name and column names will be meaningful to any
> clerk
> > 5 - we are not to "start" or "snowflake" designs. "That's just a
> bunch of
> >
> > high power talk."
> > 6 - all users will be trained to use MS Access to get at "their"
> > data. (These are users that were just converted off from "green
> screen"
> > teminals within the last 45-days, to Windows 98 with 64k RAM.)
> > 7 - We are not to just copy the legacy transactions.
> > 8 - We are to load into "an" Oracle table, all legacy transction
> data
> > because "we don't want to limit how or what a user will look at"
> > 9 - It is not necessary to talk with the users to see what data
> they want
> > to look at, or the atomic level. "They are smart enough to fighure
> this
> > out on their own. We just need to provide them the data."
> > 10 - There shall be no long term maintenance required by "the" dw.
> >
> >
> > Any ideas on how to deal with this situation?
> >
> > For tomorrow, I've done a CTAS from a materialized view that we
> created to
> >
> > support one departments known requirements.
> >
> >
> > Don
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Don
> > INET: dondealy_at_teleport.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: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
> INET: adary_at_mehish.co.il
>
> 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: Mercadante, Thomas F
> INET: Thomas.Mercadante_at_Labor.State.Ny.Us
>
> 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).
Do You Yahoo!?
Yahoo! Greetings - Send FREE e-cards for every occasion!
http://greetings.yahoo.com
--
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: Mercadante, Thomas F
INET: Thomas.Mercadante_at_Labor.State.Ny.Us
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 Feb 28 2002 - 10:23:30 CST
