|
When a record is committed, the Rules Engine performs the following actions and checks. In the Insert, Update, and Delete column it is listed whether the check is performed for the respective manipulation.
Seq
|
Check
|
BenchMark Reason
|
Ins
|
Upd
|
Del
|
1
|
Mandatory foreign keys
|
|
Y
|
Y
|
|
2
|
Deferred constraints
(corrective, non-transitional)
|
SELECT_FOR_UPDATE
NEWVALUES
|
Y
|
Y
|
Y
|
3
|
Lock parent records,
and subtype records of parent records.
|
LOCK_RECORD
|
Y
|
Y
|
Y
|
4
|
Foreign key checks
|
FOREIGN_KEY
|
Y
|
Y
|
|
5
|
Deferred subtype definitions
(totality and exclusivity)
|
|
Y
|
Y
|
|
6
|
Relationship checks:
Child Must Exist, Min/Max No of Children.
|
CARDINALITY
|
Y
|
|
|
7
|
Restrictive, non-transitional, multi-record constraints
|
CONSTRAINT_TEST
|
Y
|
Y
|
Y
|
8
|
Cardinality checks for relationships in which the current record is a child.
|
CARDINALITY
|
Y
|
Y
|
Y
|
|
