Changing table records in a database management system

1. Technical Field 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 Sat time tand in fileset Sat time t. S is logically associated with T. The family has a common family key Kacross the M...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Hauptverfasser: Broden, Theresa W, Guse, Robert W, Parmeter, Debra A, Willets, Jeffrey G
Format: Patent
Sprache:eng
Online-Zugang:Volltext bestellen
Tags: Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
Beschreibung
Zusammenfassung:1. Technical Field 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 Sat time tand in fileset Sat time t. S is logically associated with T. The family has a common family key Kacross 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 Srelative to S. For Updates, a Trigger program generates fileset S from records of Shaving a family key in D, and a Bridge program generates fileset T that includes S data in a form compatible with T. A Load program updates and deletes records in T based on the non-redundant family keyvalues.