Re: choices regarding where to place code - in the database or middle tier

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Tue, 20 Jan 2004 10:32:39 -0000
Message-ID: <400d03c2$0$2439$cc9e4d1f@news.dial.pipex.com>

"Eric F" <efriedNOSpam_at_yahoo.com> wrote in message news:cI3Pb.12298$%86.4267_at_bignews4.bellsouth.net...
> Hello!
>
> Data belongs in the database. Business logic; i.e. code, belongs in the
middle
> tier.
>
> Referential integrity belongs in the database. That is data.

What is 'business logic' and what is 'Referential integrity'. By which I mean Is a rule like every order must consist of fully formed header information and at least one detail line a business rule or a database rule?

<snip>

> Replication of business logic via clusters/EJB will provide a lot of
> performance improvements with code in the middle tier.

At what cost?

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************

Received on Tue Jan 20 2004 - 04:32:39 CST