Boots – shoes – and leggings
Patent
1988-07-15
1990-06-12
Zache, Raulfe B.
Boots, shoes, and leggings
364200, 3642821, 3642834, G06F 900
Patent
active
049338480
ABSTRACT:
A method is disclosed for deferring enforcement of referential constraints in large-scale data base operations such as the population or loading of relational tables 10, 12. First, the new rows are loaded in a Data Load phase 24 into the tables, and information on the new rows and their constraints is extracted and sorted 26 into a sorted key data set 68. Any primary indexes 22 required for constraint checking are then updated 28 using the sorted key data set. The new rows are then checked 70 for constraint violations, such violations are rectified 72 to restore the table's referential integrity, and a deletion data set 80 is produced. The deletion data set is merged and sorted 86 with row information 53 stored during loading, and the result is used to copy 88 the new rows violating referential constraints to a separate discard data set 48 where they can be corrected and reloaded into the table. Finally, an error summary report 36 is generated for use in correcting the discard data set.
REFERENCES:
patent: 4627019 (1986-12-01), Ng
patent: 4631664 (1986-12-01), Bachman
patent: 4769772 (1988-09-01), Dwyer
patent: 4811207 (1989-03-01), Hikita 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).
Haderle Donald J.
Watts Julie A.
Garnett Pryor A.
International Business Machines - Corporation
Zache Raulfe B.
LandOfFree
Method for enforcing referential constraints in a database manag 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 enforcing referential constraints in a database manag, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method for enforcing referential constraints in a database manag will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-622089