here's my standard answer to developers who try to tell me how the
database should be designed:
which part of the word "No" don't you understand?
The DBA should know best how to use the abilities of the database. I
can understand that with 3rd party applications, which have been coded
to be database "neutral", you might have to bend some of the rules. For
home-grown apps, you can and should enforce the database specific
options.
Rachel
- "Karniotis, Stephen" <Stephen_Karniotis_at_compuware.com> wrote:
> Oops, for got Ladies on my last email. Rachel definitely has some
> good
> opinions on this.
>
> Thank You
>
> Stephen P. Karniotis
> Product Architect
> Compuware Corporation
> Direct: (248) 865-4350
> Mobile: (248) 408-2918
> Email: Stephen.Karniotis_at_Compuware.com
> Web: www.compuware.com
>
> -----Original Message-----
> Sent: Wednesday, October 23, 2002 2:39 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Theory v Practice
>
> it's not common and you should insist on primary and foreign key
> constraints.
>
> all you need is ONE user to hack into the database outside the app
> and
> insert/delete/update rows that violate the integrity constraints and
> your app stops working.
>
>
> --- Craig Healey <C.Healey_at_hhsuk.com> wrote:
> > The developers working on our new VB app are also responsible for
> > setting up the Oracle DB behind it. The app is for an order
> > entry/despatch/warehouse system with >5 million customers and >1000
> > orders per day. We have nearly 400 tables. They are not planning on
> > using primary keys/secondary keys, as they say they will handle all
> > the
> > constraints via VB.
> > I only have a theoretical knowledge of database design, which says
> > this
> > is very wrong. Is the Oracle system being used as anything more
> than
> > an
> > expensive file system? In real world scenarios, is this a common
> > practice?
> >
> > Regards
> >
> > Craig Healey
> >
> >
> >
>
> ******
> >
> > This email and any files transmitted with it are confidential and
> > intended solely
> > for the use of the individual or entity to whom they are addressed
> > and may contain
> > confidential and/or privileged material. Any review,
> retransmission,
> > dissemination
> > or other use of, or taking of any action in reliance upon, this
> > information by
> > persons or entities other than the intended recipient is
> prohibited.
> > Statements
> > and opinions expressed in this e-mail may not represent those of
> the
> > company.
> >
> > If you have received this email in error please notify
> > system.administrator_at_hhsuk.com
> >
> > This footnote also confirms that this email message has been swept
> by
> > MIMEsweeper
> > for the presence of computer viruses (www.mimesweeper.com)
> >
> >
>
> *******
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Craig Healey
> > INET: C.Healey_at_hhsuk.com
> >
> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > San Diego, California -- Mailing list and web hosting
> services
> >
> ---------------------------------------------------------------------
> > 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!?
> Y! Web Hosting - Let the expert host your web site
> http://webhosting.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 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> 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).
>
>
>
> The contents of this e-mail are intended for the named addressee
> only. It
> contains information that may be confidential. Unless you are the
> named
> addressee or an authorized designee, you may not copy or use it, or
> disclose
> it to anyone else. If you received it in error please notify us
> immediately
> and then destroy it.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Karniotis, Stephen
> INET: Stephen_Karniotis_at_compuware.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> 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!?
Y! Web Hosting - Let the expert host your web site
http://webhosting.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 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
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 Oct 23 2002 - 14:44:42 CDT
