Ensuring that the archival data deleted in relational source table is already stored in relational target table

A system, comprising:

• a memory unit for storing a computer program for ensuring that archival data deleted in a source table is already stored in a target table;
• and
• a processor coupled to said memory unit, wherein said processor, responsive to said computer program, comprises:
• circuitry for locking one or more rows in a first table, wherein said first table stores one or more primary key values associated with one or more rows in said source table that have been one of modified and created by an external data source, wherein said first table further stores an indication of deleting one or more rows in said source table associated with one or more of said one or more primary key values;
• circuitry for copying distinct values for said one or more primary keys from said first table;
• circuitry for inserting said copied distinct values for said one or more primary keys into one or more rows of a second table;
• circuitry for setting one or more flags in said second table associated with said one or more rows in said source table to be deleted according to said first table;
• and
• circuitry for deleting said one or more rows in said source table indicated by said second table according to said setting of said one or more flags.

A computer program product embodied in a non-transitory computer readable medium for ensuring that archival data deleted in a source table is already stored in a target table, the computer program product comprising the programming steps of:

• locking one or more rows in a first table, wherein said first table stores one or more primary key values associated with one or more rows in said source table that have been one of modified and created by an external data source, wherein said first table further stores an indication of deleting one or more rows in said source table associated with one or more of said one or more primary key values;
• copying distinct values for said one or more primary keys from said first table;
• inserting said copied distinct values for said one or more primary keys into one or more rows of a second table;
• setting one or more flags in said second table associated with said one or more rows in said source table to be deleted according to said first table;
• and
• deleting said one or more rows in said source table indicated by said second table according to said setting of said one or more flags.