Boots – shoes – and leggings
Patent
1988-07-15
1990-08-07
Zache, Raulfe B.
Boots, shoes, and leggings
3642821, 3642834, G06F 944
Patent
active
049473204
ABSTRACT:
A method is disclosed for enforcing referential constraints on a record-by-record basis, immediately before or after each record is manipulated and while the record is still accessed, significantly improving the system's performance. Each record is visited only once to do both the constraint checking and the manipulation (insert/update/delete). If the constraint checking fails, then the entire relational operation of which the record manipulation is a part is backed out. For insertions, each record is first inserted 30, and then constraints respective the record are enforced 32,34. For updates, the record is updated 48 after constraints respecting the record's primary key are enforced 40,42, and before constraints respecting its foreign key(s) are enforced 44,46. Deletions are performed 52 before the constraints on the deleted record are enforced 54,56. Cascade deleted 58 are handled recursively 60. The method correctly processes cyclic constraints and self-referencing rows without special handling.
REFERENCES:
patent: 4468728 (1984-08-01), Wang
patent: 4631664 (1986-12-01), Bachman
patent: 4833597 (1989-05-01), Wakayama et al.
E. Simon et al., "Design and Implementation of an Extendable Integrity Subsystem", Proceedings ACM Sigmod Record, vol. 14, No. 2, pp. 9-17 (1984).
E. Simon et al., "Efficient Algorithms for Integrity Control in a Database Machine", IEEE Proceedings-Trends and Applications, 1984, pp. 53-59.
A. Dogac et al., "The Design and Implementation of an Integrity Subsystem for the Relational DBMS RAP", Proceedings 4th International Conference on Entity-Relationship Approach, IEEE, pp. 295-302 (1985).
Crus Richard A.
Engles Robert W.
Haderle Donald J.
Herron Howard W.
Garnett Pryor A.
International Business Machines - Corporation
Zache Raulfe B.
LandOfFree
Method for referential constraint enforcement in a database mana 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 for referential constraint enforcement in a database mana, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method for referential constraint enforcement in a database mana will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-964743