Ideally, I think the database should be designed according to its own design
standards and the object layer should be designed according to whatever
methodology you wish to use and a facade should be used as a bridging
mechanism between the two. This option of course will probably take the most
time to design and implement but then again will yield a loosely coupled
architecture that is easily adaptable.
As far as implementation of referential integrity in the database is
concerned, I can see your point. Many shrinkwrapped enterprise business
applications implement referential integrity at the application level for
performance reasons although you should be well aware of the cost of doing
this. If you have dedicated access to these tables then it may be ok but if
other processes are accessing them as well you need to be sure they are
implementing the r.i. as well.
>From: Sven van �t Veer <[EMAIL PROTECTED]>
>Reply-To: Sven van �t Veer <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: Foreign Keys, to define or not to define??
>Date: Wed, 25 Jul 2001 12:06:21 -0300
>
>I�m doing the architecture on a (j2ee) project and I have a disagreement
>with one of the analists who is also the DataBase Designer of the project.
>First of all, imho, the database design has to follow the UML model for
>the application and not the application follow the database model since
>my classes might have some other requirements that are not described in
>the use cases and because the database design might contain fields I
>wont need in my application.
>Second, the dba is convinced that the database must contain foreign keys
>and constraints. IMHO, the one of the ideas behind J2EE is using each
>tier for which it has been designed, as such i think a j2ee application
>should not contain any contraints and foreign keys since they might be
>very database dependent and would take away part of the portability of
>the application and most of all, the application i�m designing has a
>shitload of db transactions (20000 inserts 20000 deletes and some 20000
>selects every 300 seconds) so constraints and foreign keys really would
>screw up my db performance.
>
>Any opinions ?
>
>Sven
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST". For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".
