International Business Machines Corporation

Robert W Guse

Theresa W Broden

Debra A Parmeter

Jeffrey G Willets

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

Growing community of inventors

Endwell, NY, United States of America

Robert W Guse