Referential Integrity (RI) is a feature of relational databases that helps ensure the consistency of data related between two tables. For the most part, it is concerned with the effects of an Insert or a Delete of a row of data into one table, and how that action should influence (or be influenced by) its relationship to data in another table.
Referential Integrity is generally best left to the DBMS to support, simply because the DBMS can usually perform the RI more efficiently. However, every DBMS does not necessarily support every form of Referential Integrity. With CA Gen, you can supplement the inherent RI capabilities of your targeted DBMS with additional RI Constraints (not normally supported by that database) through the use of CA Gen-generated RI Triggers.
For example, suppose that you wanted to automatically delete all Dependents for an Employee when the Employee is deleted. This is commonly known as a Cascade Delete. While most DBMSs support Cascade Deletes, CA Gen can generate some additional code for you to automatically take care of this constraint if your targeted DBMS does not support it.
Another example is the cyclical Cascade Delete: deleting one Employee who manages another Employee who manages still another. Many DBMSs would not support deleting all three. CA Gen RI Triggers can extend the capabilities of your targeted DBMS to support this constraint as well. The CA Gen RI Triggers are essentially subroutines that are generated to enhance or extend the DBMS' native RI capabilities.
CA Gen provides RI coverage that is both fast and complete. It does this through a combination of generated RI Constraints, Triggers, Stored Procedures and embedded SQL, depending on the particular DBMS selected.
|
Copyright © 2013 CA.
All rights reserved.
|
|