Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: RI - pros and cons

Re: RI - pros and cons

From: Ed Stevens <spamdump_at_nospam.noway.nohow>
Date: Fri, 22 Mar 2002 15:53:03 GMT
Message-ID: <3c9b535a.356351496@ausnews.austin.ibm.com>


On Wed, 20 Mar 2002 20:52:28 GMT, spamdump_at_nospam.noway.nohow (Ed Stevens) wrote:

>I feel stupid even posting this question but there's trouble brewing in River
>City. I'm getting caught between my "partner" DBA (with whom I have many
>philosophical differences) and the developers.
>
>New application being developed. Four rather simple tables - header data,
>detail data, and a couple of reference/look-up tables. Developers want RI and I
>agree. DBA says "RI is more trouble than its' worth. You should take care of
>it in your application." I'm caught in the middle, stongly disagreeing (that's
>putting it diplomaticly) with the other DBA but having to maintain a working
>relationship. He makes the claim "all the other DBA's I read on MetaLink say RI
>is too much trouble" but won't produce evidence.
>
>Anyone want to comment on the technical merits of RI vs. not. I've always felt
>that the benefits of RI (and normalized tables) was so obvious as to not even
>require any further justification. Do I need to be re-educated, or . . . .
>
>

I'd like to thank everyone for their responses, which were about what I expected. If nothing else, I needed some moral support and reinforcement that I wasn't going crazy. Received on Fri Mar 22 2002 - 09:53:03 CST

Original text of this message

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