US5603024A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Lossless distribution of time series data in a relational data base network
Assignee: International Business Machines Corp
•
Filing: 1996-05-15
•
Granted: 1997-02-11
•
Expires: 2016-05-15
Abstract
Abstract A computer processing system that receives sequences of changes to a data base and records them into an activity log for later retrieval also maintains a consistent change data table that contains sufficient change information for each of the changes to the data base such that the changes can be propagated through multiple copies of the data base by consulting the consistent change data table. The consistent change data includes information sufficient to permit reconstruction of the data base to reflect the condition of the data base at any moment of time in the activity log. Because the consistent change data is complete, it permits producing multi-generational copies of data base tables for replication from one copy level to any other subsequent level, or iteration, of copy.
Inventors
- 👤 Robert D. Goldring
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-10-29 17:44
CPC Classifications
G; G06; G06F; G06F11/00; G06F11/07; G06F11/14; G06F11/1471; G06F16/00; G06F16/20; G06F16/23; G06F16/2358; G06F2201/00; G06F2201/82; Y; Y10; Y10S; Y10S707/00; Y10S707/99951; Y10S707/99952; Y10S707/99954
Claims Analysis
Total Claims: 4
Claim 1
Independent Claim
159 words
A method of operating a computer processing system that receives transactional updates comprising sequences of data change operations to source data tables in a data base and records them into an activity log for later retrieval, the method comprising the steps of: generating a consistent change data table from the retrieved activity log such that the consistent change data table contains a column for storing data change operations of a received transactional update and columns for a commit sequence number, an intent sequence number, and an indicator of the data change operation, such that the consistent change data table contains committed change operations retrieved from the activity log in the order in which they were committed, beginning with a time no earlier than a last prior refresh operation; and performing multiple refresh operations and producing copies of source data tables through multiple generations of copies by applying the consistent change data table entries to the last prior refreshed copy.
Claim 2
Independent Claim
159 words
A method of operating a computer processing system that receives transactional updates comprising sequences of data change operations to source data tables in a data base and records them into an activity log for later retrieval, the method comprising the steps of: generating a consistent change data table from the retrieved activity log such that the consistent change data table contains a column for storing data change operations of a received transactional update and columns for a commit sequence number, an intent sequence number, and an indicator of the data change operation, such that the consistent change data table contains committed change operations retrieved from the activity log in the order in which they were committed, beginning with a time no earlier than a last prior refresh operation; and performing multiple refresh operations and producing copies of source data tables through multiple generations of copies by applying the consistent change data table entries to the last prior refreshed copy.
Claim 3
Dependent Claim
25 words
A method as defined in claim 1, wherein the step of producing copies includes performing a full refresh operation by applying source data table entries.
Claim 4
Dependent Claim
77 words
A method as defined in claim 1, further including the step of: generating a change data table for each source table, each change data table having a column for storing data change operations for each transactional update and a column for storing an intent sequence number, and an indicator of the data change operation; wherein the step of producing copies includes performing a copy by applying the change data table entries to the last prior refreshed copy.
References Cited (Backward Citations)
US5347632A
Cited
US5317731A
Cited
US5369757A
Cited
US5280611A
Cited
US5280612A
Cited
US5530855A
Cited
US5455945A
Cited
US5440735A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2000-02-11 | 2000-08-12 | 2001-02-11 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2004-02-11 | 2004-08-12 | 2005-02-11 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2008-02-11 | 2008-08-12 | 2009-02-11 | $7700.00 | Window Closed / Lapsed |