While readin thru dbazine i came thr u with this very interesting post about software engineering tactics by Joe Celko
Its a three part article about basic real life design issues that software developers face.
It sort of answered what i wa slookign for in one of my projects
The article is titled Mop The floor and fix The Leak
its a 3 part article on where should stuff be done ,
In the Application , i the database or both.
Which does pose seom interesting issues.
As Software design Evolves . It is soemtimes hard to give policy decisions in these matters due the the evoloving nature of the rdbms.