Dismiss
The InnovationQ application will be updated on Sunday, May 31st from 10am-noon ET. You may experience brief service interruptions during that time.
Browse Prior Art Database

Optimal Elimination of Referential Constraint Checks

IP.com Disclosure Number: IPCOM000037357D
Original Publication Date: 1989-Dec-01
Included in the Prior Art Database: 2005-Jan-29

Publishing Venue

IBM

Related People

Authors:
Boykin, JR Horn, GR Malkemus, TR [+details]

Abstract

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.