公开(公告)号：DE68929132D1

公开(公告)日：2000-02-10

申请号：DE68929132

申请日：1989-07-12

Applicant: IBM

Inventor： HADERLE DONALD JAMES ,  WATTS JULIE ANN

IPC: G06F9/00 ,  G06F17/30 ,  G06F12/00

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.

公开(公告)号：DE68929132T2

公开(公告)日：2000-07-13

申请号：DE68929132

申请日：1989-07-12

Applicant: IBM

Inventor： HADERLE DONALD JAMES ,  WATTS JULIE ANN

IPC: G06F9/00 ,  G06F17/30 ,  G06F12/00

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.