US5970503A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Method for online revision control
Assignee: ABB Automation Inc
•
Filing: 1996-06-12
•
Granted: 1999-10-19
•
Expires: 2016-06-12
Abstract
Abstract A method for controlling a database comprises storing field definitions defining a version of the database, storing an effectivity table including descriptors corresponding to the versions and field definitions and an effective date for each and storing records with data for the fields along with a date when the record was created. When the version of the database is changed, only revised field definitions are stored and the stored effectivity table is updated only with changes in a state of field definitions and/or version changes and the effective date thereof.
Inventors
- 👤 Alan J. Eisenberg
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-11-05 01:40
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/23; G06F16/2379; G06F16/21; G06F16/219; G06F16/2308; G06F16/2315; G06F16/2329; Y; Y10; Y10S; Y10S707/00; Y10S707/99951; Y10S707/99952; Y10S707/99954
Claims Analysis
Total Claims: 10
Claim 1
Independent Claim
111 words
A method for revision control of a database, comprising the steps of: a. storing field definitions defining a version of a database; b. storing an effectivity table including descriptors corresponding to the version and the field definitions and an effective date for each; c. storing records with data for the fields along with a date when the record was created; d. changing the version of the database; e. storing only revised field definitions and updating the stored effectivity table only with at least one of field state changes and version changes and the effective date thereof; and f. repeating the step of storing records and optionally repeating steps d and e.
Claim 2
Independent Claim
111 words
A method for revision control of a database, comprising the steps of: a. storing field definitions defining a version of a database; b. storing an effectivity table including descriptors corresponding to the version and the field definitions and an effective date for each; c. storing records with data for the fields along with a date when the record was created; d. changing the version of the database; e. storing only revised field definitions and updating the stored effectivity table only with at least one of field state changes and version changes and the effective date thereof; and f. repeating the step of storing records and optionally repeating steps d and e.
Claim 3
Dependent Claim
48 words
The method according to claim 1, further comprising reconstructing a database version for a given record by obtaining the creation date of the given record; searching the effectivity table for an active version and for active fields at the creation date; and obtaining the stored active field definitions.
Claim 4
Dependent Claim
17 words
The method according to claim 1, wherein the database is a database for a manufacturing execution system.
Claim 5
Dependent Claim
17 words
The method according to claim 3, wherein the records comprise support data for a manufacturing execution process.
Claim 6
Dependent Claim
97 words
The method according to claim 1, wherein at least one of the fields is a list field comprising a list of items each having a definition and further comprising for each list field: g. storing item definitions defining a header version of the list field; h. storing a second effectivity table including descriptors corresponding to the header version and the item definitions and an effective date for each; i. changing the version of the list field; j. storing only revised item definitions and updating the stored second effectivity table; and f. optionally repeating steps i and j.
Claim 7
Dependent Claim
25 words
The method according to claim 5, wherein the step of updating the second effectivity table comprises updating item state changes and the effective date thereof.
Claim 8
Dependent Claim
25 words
The method according to claim 5, wherein the step of updating the second effectivity table comprises updating header version changes and the effective date thereof.
Claim 9
Dependent Claim
50 words
The method according to claim 5, further comprising reconstructing a list field version for a given record by obtaining the creation date of the given record; searching the second effectivity table for an active header version and active items at the creation date; and obtaining the stored active item definitions.
Claim 10
Dependent Claim
40 words
The method according to claim 8, further comprising reconstructing a database version for the given record by searching the first effectivity table for an active version and active fields at the creation date; and obtaining the stored active field definitions.
References Cited (Backward Citations)
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2002-10-18 | 2003-04-19 | 2003-10-19 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2006-10-18 | 2007-04-19 | 2007-10-19 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2010-10-18 | 2011-04-19 | 2011-10-19 | $7700.00 | Window Closed / Lapsed |