Bill,
The classic example of rules that I've seen is something like POSTALCODERULE --- but the reality is that just how many different tables should there be in the databas that have postal code columns? I would suggest just one, and if that's the case, then using a constraint would likely be better an rule.
We've also adopted the goal of trying to put all business rules in the middle tier, no stored procs or business triggers. So far so good.
The classic example of rules that I've seen is something like POSTALCODERULE --- but the reality is that just how many different tables should there be in the databas that have postal code columns? I would suggest just one, and if that's the case, then using a constraint would likely be better an rule.
We've also adopted the goal of trying to put all business rules in the middle tier, no stored procs or business triggers. So far so good.
Leave a comment