Optimal Elimination of Referential Constraint Checks
Original Publication Date: 1989-Dec-01
Included in the Prior Art Database: 2005-Jan-29
The context of this optimization pertains to the OS/2* EE Database Manager Referential Integrity Design for the SQL Compiler component. Definitions: Access Section The compiled form of a single OS/2 EE Database Manager SQL statement. Dependent Row A row of a dependent table that has a foreign key value that matches a primary key value of its parent table. Dependent Table A table in a relationship containing a foreign key that defines the relationship.