Enforcing constraints from a parent table to a child table

Details Enforcing constraints from a parent table to a child table Enforcing constraints from a parent table to a child table

2011-08-30

2011-08-30

Fleurantin, Jean B (Department: 2162)

Data processing: database and file management or data structures

Database design

Data structure types

C707S796000

Reexamination Certificate

active

08010568

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.

REFERENCES:
patent: 5133068 (1992-07-01), Crus
patent: 5499359 (1996-03-01), Vijaykumar
patent: 6339777 (2002-01-01), Attaluri et al.
Tansel, Integrity constraints in temporal relational databases, Apr. 5-7, 2004, IEEE, vol. 2, 5 pages.
Elmasri et al., “Fundamentals of Database Systems,” 1994, Addison-Wesley, Second Edition (146-150, 189, and 213), All pages.
Transact-SQL User's Guide, “Check,” Accessed Jun. 3, 2008, pp. 1-2.
Yang et al., “Mapping Referential Integrity Constraints from Relational Databases to XML,” 2001, Springer-Verlag, pp. 329-340.

Affiliated with

Also associated with

Rating

Enforcing constraints from a parent table to a child table does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Enforcing constraints from a parent table to a child table, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Enforcing constraints from a parent table to a child table will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-2717532