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

From: Mike Sherrill <MSherrillnonono_at_compuserve.com>
Date: Tue, 20 Jan 2004 11:59:21 -0500
Message-ID: <3hnq00da3nfa95i1tbpm965ma8r7rad1if@4ax.com>

On Tue, 20 Jan 2004 06:17:04 GMT, efriedNOSpam_at_yahoo.com (Eric F) wrote:

>Data belongs in the database. Business logic; i.e. code, belongs in the middle
>tier.

Hmmm.

>Referential integrity belongs in the database. That is data.

Where do "required data" constraints belong, as in "this value must not be null and must not be an empty string"?

Where do range constraints belong, as in "this value must be greater than zero"?

Where do "paired column" constraints belong, as in "end date must be on or after start date"?

>My .02

I think you overcharged me. There's a lot more to data integrity than just referential integrity.

-- 
Mike Sherrill
Information Management Systems

Received on Tue Jan 20 2004 - 10:59:21 CST