Enforcement of referential constraints in a database system

Boots – shoes – and leggings

Patent

Rate now

  [ 0.00 ] – not rated yet Voters 0   Comments 0

Details

3642721, 3642834, 364DIG1, G06F 1540

Patent

active

053865570

ABSTRACT:
A system and method for enforcing referential integrity within a database system provides for determination of relevant referential constraints at compile time for an access plan. All referential constraints which are relevant to data changes to the database are identified when the access plan is created. Code necessary for performing referential constraint checks is inserted directly into the access plan at compile time, eliminating the necessity for determining the relevant constraints at run time. Constraint checking can be performed using substantially the same low-level procedural statements already used in the access plan for performing database accesses.

REFERENCES:
patent: 4104718 (1978-08-01), Poublan et al.
patent: 4330822 (1982-05-01), Dodson
patent: 4506326 (1985-03-01), Shaw et al.
patent: 4769772 (1988-09-01), Dwyer
patent: 4819160 (1989-04-01), Tanka et al.
patent: 4829427 (1989-05-01), Green
patent: 4918593 (1990-04-01), Huber
patent: 4933848 (1990-06-01), Haderle et al.
patent: 4947320 (1990-08-01), Crus et al.
patent: 4979109 (1990-12-01), Tanaka et al.
patent: 5018067 (1991-05-01), Mohlenbrock et al.
patent: 5133068 (1992-07-01), Crus et al.
patent: 5197005 (1993-03-01), Shwartz et al.
Selinger et al, "Access Path Selection in a Relational Database Management System", 1979, readings in Database Systems, pp. 82-93, editor: M. Stonebraker.
Astrahan et al, "System R: Relational Approach to Database Management", 1976, from readings in Database Systems, pp. 16-36, editor: M. Stonebraker.
Graefe et al., Dynamic Query Evaluation Plans, ACM, 1989, pp. 358-366.
Lee et al., Progressive Access Plan Selection for Relational Database Systems, Computer Science, Sep. 1987, pp. 1-17.

LandOfFree

Say what you really think

Search LandOfFree.com for the USA inventors and patents. Rate them and share your experience with other people.

Rating

Enforcement of referential constraints in a database system does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Enforcement of referential constraints in a database system, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Enforcement of referential constraints in a database system will most certainly appreciate the feedback.

Rate now

     

Profile ID: LFUS-PAI-O-1108468

  Search
All data on this website is collected from public sources. Our data reflects the most accurate information available at the time of publication.