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 S A at time t A and in fileset S B at time t B . S is logically associated with T. The family has a common family key K F across the M tabl...
Gespeichert in:
Hauptverfasser: | , , , |
---|---|
Format: | Patent |
Sprache: | eng |
Online-Zugang: | Volltext bestellen |
Tags: |
Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
|
Zusammenfassung: | 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 S
A
at time t
A
and in fileset S
B
at time t
B
. S is logically associated with T. The family has a common family key K
F
across the M tables and across the N source files. A Delta program generates a dataset D having non-redundant family keyvalues embodying K
F
. Each non-redundant family keyvalue is drawn from selected Update or Delete records of S
B
relative to S
A
. For Updates, a Trigger program generates fileset S from records of S
B
having 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. |
---|