11.5 Multiple-Object Data Rule Remedies

All of the discussion of rule remedies in the previous chapter apply to these as well. The difference is that remedies for these types of rules are more likely to result in programs that check the data on a periodic basis rather than being inserted into transactional processing. Database management system procedures are generally not appropriate for these types of data rules.

As in the previous chapter, rules need to be evaluated as to whether they need to be included in remedies or not, based on their proclivity to find inaccurate data. Because they are expensive to create, maintain, and operate, this becomes more important. If several violations occur, it may be valuable to review the business procedures surrounding these rules and to consider changing them.