Referential Integrity

Referential integrity are contraints in the database, which ensure the consistency between coupled tables. I.e. it has to be ensured, that for a dataset in one table there is also the corresponding dataset in another table refered by the foreign key in the first table.

If referential integrity is ignored, errors will arise while inserting, deleting or updating a dataset. Hence, it is important to send statements in a special order. For example, the dataset in the refered table has to be deleted before the dataset in the refering table.

Signsoft intelliBO provides a preordering mode to ensure referential integrity. Therefore the user may create a configuration file called fkrelations.xml with the referential integrity information. The file is used by Signsoft intelliBO to preorder statement sequences to avoid database conflicts (see also /samples/advanced/referential_integrity ).