Invention Grant
- Patent Title: Enforcing constraints from a parent table to a child table
- Patent Title (中): 从父表到子表执行约束
-
Application No.: US12220164Application Date: 2008-07-21
-
Publication No.: US08010568B2Publication Date: 2011-08-30
- Inventor: Mark Gregory Megerian
- Applicant: Mark Gregory Megerian
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agent Owen J. Gamon
- Main IPC: G06F7/00
- IPC: G06F7/00 ; G06F17/30

Abstract:
An apparatus, system, and storage medium that, in an embodiment, receive a constraint command that specifies a parent table, a primary key in the parent table, a child table, and a foreign key in the child table, and enforce that all values for the primary key in the parent table are present in the foreign key in the child table. In an embodiment, the enforcing may include receiving an insert command that specifies a target key, a target value for the target key, and a target table; determining whether the target table matches the parent table and whether, within a transaction that includes the insert command, the child table includes at least one row with a foreign key value that equals the target value of the primary key; inserting the target value in the target table if the determining is true; and returning an error otherwise.
Public/Granted literature
- US20080288555A1 Enforcing constraints from a parent table to a child table Public/Granted day:2008-11-20
Information query