Changing table records in a database management system
Number of patents in Portfolio can not be more than 2000
United States of America Patent
Stats
-
Dec 16, 2003
Grant Date -
Jan 9, 2003
app pub date -
Jul 3, 2001
filing date -
Jul 3, 2001
priority date (Note) -
Expired
status (Latency Note)
Importance
Abstract
A method and system for updating and deleting records in a tableset T of a family having M tables (M.gtoreq.1). A set S of N source files (N.gtoreq.1) are embodied in fileset S.sub.A at time t.sub.A and in fileset S.sub.B at time t.sub.B. S is logically associated with T. The family has a common family key K.sub.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.sub.F. Each non-redundant family keyvalue is drawn from selected Update or Delete records of S.sub.B relative to S.sub.A. For Updates, a Trigger program generates fileset .DELTA.S from records of S.sub.B having a family key in D, and a Bridge program generates fileset .DELTA.T that includes .DELTA.S data in a form compatible with T. A Load program updates and deletes records in T based on the non-redundant family keyvalues.
First Claim
Family
International Classification(s)
Cited Art Landscape
Patent Citation Ranking
Advertisement
Advertisement
Advertisement
Recipient Email Address
Recipient Email Address
Comment
Recipient Email Address
Add to Portfolio(s)
To add this patent to one, or more, of your portfolios, simply click the add button.
This Patent is in these Portfolios:
Add to additional portfolios:
Last Refreshed On:
Changes done successfully