Database Integrity

See Also

When application data is manipulated, the Rules Engine evaluates all relevant constraints. It decides which constraints are relevant for a particular manipulation on the basis of the scope of the constraints. The scope is determined by the set of tables referred to in the FROM clause, and by the columns named in the WHERE clause of the constraint's SQL statement.

If any database manipulations are performed as a side effect of constraint evaluation, the Rules Engine investigates whether these side effects violate other constraints. If they do, the original manipulation is rejected.