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

From: Sudsy (bitbucket44_at_hotmail.com)
Date: 01/23/04 

Date: Fri, 23 Jan 2004 14:26:46 -0500

Joe wrote:
<snip>
> 1. Most people agree that you shouldn't forgo declarative referential
> integrity in favor of rules in the middle tier. In that way lies data
> corruption. (for those of you that disagree - please note I said "most")

Since this was posted to a java newsgroup, I'd like to add that
redundancy is always a good idea. A prime example is form validation.
Even though Struts can create javascript for validating input fields
it doesn't mean that you don't also perform validation on the server
side. Validation again when inserting into a database is a good
practice. The more "checks and balances" you design into a system,
the less the likelihood of data corruption.

Relevant Pages

  • Re: Where to do Data Validation?
    ... putting the validation closer to the source of the error ... ... The data they hold can either have meaning or not have meaning. ... and constrained within the structure of the database. ... An external application can never guarantee the integrity of data ...
    (comp.databases.oracle.misc)
  • Re: New High Scores Database is Open - High Scores Arcade Dot Com
    ... The long answer is that I had to balance the need for score validation ... against the need for ease of use of the web site. ... seemed a bit too easy and had absolutely no validation of the integrity ... the way the site is set up makes submitting scores the easiest and most ...
    (rec.games.video.arcade.collecting)
  • Re: Size matters to some
    ... logical database constraints (such as your average, ... Generates a data validation service for you to use, at any data level, ... database level validation at the time of CRUD would be ... database with native, write-based, integrity checking. ...
    (comp.databases.pick)
  • Re: Sun vs. Microsoft JVMs
    ... > integrity checks? ... You appear to be reading something in his posts ... "The validation does NOT have to be repeated in full. ...
    (comp.lang.java.programmer)
  • Re: Where to do Data Validation?
    ... I have a question about data validation. ... application level (while also having integrity constraints in the ... database) whereas other articles mention that data validation should ...
    (comp.databases.oracle.misc)