of app is it? OLAP? Data Warehouse?
>
>What kind of performance requirements have been set?
>
>Cherie Machler
>Oracle DBA
>Gelco Information Network
>
>
>
>
> DENNIS WILLIAMS
>
>list ORACLE-L <[EMAIL PROTECTE
;What kind of performance requirements have been set?
>
>Cherie Machler
>Oracle DBA
>Gelco Information Network
>
>
>
>
> DENNIS WILLIAMS
>
>list ORACLE-L <[EMAIL PROTECTED]>
>TOUCH.COM>
Craig - Thanks for mentioning this J2EE fact. Currently the developers are
using JDBC, but we are trying to decide if we should move up to J2EE. I
spent this weekend reading "Java Programming with Oracle JDBC" by Don Bales
which has just been published, ink still wet. Seems to be a good book, but
Hi Dennis,
Agreed this was not the developers fault, it was the DBA's! I don't blame
this on RI being handled by constraints, but on a DBA that doesn't understand
the consequences, the resulting table level lock could have also been a problem
:-).
BTW, if RI had been handled via the appli
DENNIS WILLIAMS <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
01/21/02 02:35 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: RE: Limits on referential integrity
Jared - I wasn't cl
performance requirements have been set?
Cherie Machler
Oracle DBA
Gelco Information Network
DENNIS WILLIAMS
TOUCH.COM>cc:
Sent by: Subject: RE: Lim
Hi Dennis,
Just my opinion but I tried to follow these rules as a DBA.
1. If the business rule can be implemented with pk, fk, unique or check
constraints I do it as such
2. If the business rule can be implemented as a trigger I code it as a
trigger
3. If none of the above, I implement as
John - Thanks for your insights. I appreciate you final comment that you
haven't seen RI as the real performance problem.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, January 22, 2002 7:40 AM
To: Multiple recipients of list ORACLE-L
Hi Dennis,
cc:
Sent by: Subject: RE: Limits on referential
integrity
[EMAIL PROTECTED]
L PROTECTED]>
cc:
Subject: RE: Limits on referential integrity
Jared - I wasn't clear, but then again it is Monday. I have a team of
inexperienced developers starting a big, new Java application. They have a
good, experienced data model consultant helping them create the data
Title: RE: Limits on referential integrity
Jared and Dennis,
In the J2EE world I've found that developers can have a little trouble with RI because in some cases it is not the developer that is performing the DML operations - the J2EE container does this for them when using Cont
Jared - I wasn't clear, but then again it is Monday. I have a team of
inexperienced developers starting a big, new Java application. They have a
good, experienced data model consultant helping them create the data model.
They are eager to include referential integrity. So eager it has me a little
I would be you lunch that what they are implementing in their
code is not actually RI. They may be implementing code to
ensure things get inserted in the right order, and that child rows
have a parent.
This is a very weak form of RI. Oracle is very good at implementing
RI, and it is not depend
13 matches
Mail list logo
