RE: Where can I find real-life-examples about ORACLE installation

Hello all,

Funny you mention Remedy. I've been recently introduced to Remedy here at my new job. I was about to refresh our QA database with production data when I discovered the schema's were different! I took a look at the two schemas and WOW, was that a shock (uglyyyyyyyyyy). Seems the DEV schema is different from QA schema too. Next week I will meet with one the consultants that implemented the app here. I hope there is some method to the apparent madness (at least mapping between schemas).

Mike Lanteigne

The views expressed here are mine and do not reflect the official position of my employer or the organization through which the internet was accessed.  

> -----Original Message-----
> From: Seley, Linda [SMTP:LSeley_at_IQNavigator.com]
> Sent: Friday, April 20, 2001 12:30 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Where can I find real-life-examples about ORACLE
> installation
>
> With your 'free time' now would be a good time to work on putting Remedy
> out
> of business. ;-) It wouldn't be too hard and you'd be the hero of
> countless DBAs!
>
> Linda
> (who is very grateful never to have had to deal with AR but sure heard
> some
> ugly stories!)
>
> -----Original Message-----
> Sent: Thursday, April 19, 2001 7:50 PM
> To: Multiple recipients of list ORACLE-L
> installations?
>
>
>
> Comments embedded
>
> On Thursday 19 April 2001 15:31, Eric D. Pierce wrote:
> ...
> > As far as I know, structured denormalization is considered to be a
> > method for modification of a normalized design. There should be
> > disipline/method/rules that try to get the best performance increase
> > in a trade-off for the least collateral damage (extra coding).
> >
> > I get the impression that this is standard operating procedure,
> > documented in industry journals, and so forth.
> >
> > In your experience, what percentage of "real world" dbs are using
> > pure normalized designs?
>
> In my experience, DBA's are scum and developers lobby the managers
> with tales of how terrible life will be if they're forced to write code
> for
> a normalized database.
>
> I guess I'm saying that I can't recall starting with a completely
> normalized
>
> database ( just 3rd normal form here ) and then denormalize if we found
> it necessary for some reason.
>
> We've usually have had some denormalization in as soon as we started
> doing physical modeling. Sigh.
>
> If you're familiar with the Help Desk software 'Remedy', you will know
> that
> it has one of the worst schemas ever designed by man or beast. If you
> haven't seen it, you would have a hard time imagining it. Yes, worse than
> Finanacials, Lawson, SAP, etc.
>
> ( 'where is he going with this?' you ask )
>
> One of my fantasies is to build a help desk system that runs on a
> normalized
> schema, open source it, and put Remedy out of business. The schema
> is that bad.
>
> >
> > Has this changed as hardware becomes more powerful and cheaper?
> >
>
> Hardware, and Oracle has improved in it's ability to join. I assume other
> databases are faster than in years past as well.
>
> > pss, aren't you *ever* going to tell us what happened at your last
> > job?
>
> Sorry, thought I had.
>
> My previous employer laid off several folks. I wasn't among them however.
> Damagement decided to take this opportunity to redeploy several positions
> to HQ in Houston TX.
>
> If you've spent any time in the Pacific NorthWest, you may understand why
> I chose to stay here. Likewise if you've been to Houston :)
>
> ( hope I didn't offend any Texicans :)
>
> I'm taking this opportunity to attempt a slight career change and get
> into
> the contracting side of things.
>
> Jared
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jared Still
> INET: jkstill_at_cybcon.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: Seley, Linda
> INET: LSeley_at_IQNavigator.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: Lanteigne, Mike
  INET: MLanteigne_at_edc-see.ca

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).