Changing table records in a database management system

摘要

A method and system for updating and deleting records in a tableset T of a family having M tables (M>=1). A set S of N source files (N>=1) are embodied in fileset SA at time tA and in fileset SB at time tB. S is logically associated with T. The family has a common family key KF across the M tables and across the N source files. A Delta program generates a dataset D having non-redundant family keyvalues embodying KF. Each non-redundant family keyvalue is drawn from selected Update or Delete records of SB relative to SA. For Updates, a Trigger program generates fileset DeltaS from records of SB having a family key in D, and a Bridge program generates fileset DeltaT that includes DeltaS data in a form compatible with T. A Load program updates and deletes records in T based on the non-redundant family keyvalues.