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" <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > 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 <[EMAIL PROTECTED]> 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 > > [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
