Method and apparatus for maintaining referential integrity withi

Details Method and apparatus for maintaining referential integrity withi Method and apparatus for maintaining referential integrity withi

1989-05-24

1993-07-06

Kulik, Paul V.

Boots, shoes, and leggings

364DIG1, 36422281, 36422282, 3642821, 3642834, G06F 1540

Patent

active

052261581

ABSTRACT:
A method and apparatus are disclosed for maintaining the referential integrity of a relational database by determining the validity of each new referential constraint which is brought about by the proposed creation or alteration of a data table within the database. All relationships of a newly created or altered data table are first examined for known non-error conditions in which the new referential constraint will not affect other data tables. Next, self-referencing relationships are examined to detect known error situations. Thereafter, a model is created of a selected portion of the database which includes the newly created or altered data table; all data tables dependent from the newly created or altered data table; all data tables descendant from those dependent tables which are delete-connected to the newly created or altered data table; all data tables which are the parent tables for any data table previously included; and, any ancestor data table having a Cascade delete rule relationship with a parent table previously included. The validity of the new referential constraint is then verified by examining only that portion of the database represented by the model to determine if the proposed relationship allows referential integrity to be maintained.

REFERENCES:
patent: 4833597 (1989-05-01), Wakayama et al.
patent: 4918593 (1990-04-01), Huber
patent: 4933848 (1990-06-01), Haderle et al.
patent: 4947320 (1990-08-01), Crus et al.
C. J. Date, "An Introduction to Database Systems," vol. I, 1986, pp. 249-255.
C. J. Date, "An Introduction to Database Systems," vol. II, 1983.

Affiliated with

Also associated with

Rating

Method and apparatus for maintaining referential integrity withi does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Method and apparatus for maintaining referential integrity withi, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and apparatus for maintaining referential integrity withi will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-1696691