US5950210A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Database row version differentiation process
Assignee: Hanger Solutions LLC
•
Filing: 1997-01-29
•
Granted: 1999-09-07
•
Expires: 2017-01-29
Abstract
Abstract A method for row version differentiation in a database management system employs steps of identifying a versioned table to said database; creating a logical primary key, comprising a prescribed number of columns in the versioned table, the logical primary key being created in a physical primary key of the versioned table; defining at least one column of the physical primary key as a version effective reference value; deriving version differentiation criteria information from a version differentiation predicate included in a request submitted by a database user, the version differentiation predicate including a name of the versioned table defined to a database, a target effective status, and a target value for version differentiation processing; retrieving rows of the versioned table that satisfy the version differentiation criteria derived from the version differentiation predicate by comparing the effective reference values of the versioned table with the version differentiation criteria.
Inventors
- 👤 Paul M. Nelson
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-10-30 12:10
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/21; G06F16/219; Y; Y10; Y10S; Y10S707/00; Y10S707/99931; Y10S707/99951; Y10S707/99952; Y10S707/99954
Claims Analysis
Total Claims: 11
Claim 1
Independent Claim
171 words
A method for row version differentiation in a database management system comprising: identifying a versioned table to said database management system; creating a physical primary key of the versioned table; defining to said database management system at least a first portion of said physical primary key as a logical primary key; defining to said database management system at least a second portion of the physical primary key as a version effective reference value; deriving version differentiation criteria information from a version differentiation predicate included in a request submitted by a database user, the version differentiation predicate identifying the versioned table and a target effective status; and retrieving rows of the versioned table that satisfy the version differentiation criteria as a function of the version differentiation predicate submitted by the database user and the version effective reference value defined to said database management system, including comparing the version effective reference value of the versioned table as defined to the database management system with the version differentiation criteria submitted by the database user.
Claim 2
Independent Claim
171 words
A method for row version differentiation in a database management system comprising: identifying a versioned table to said database management system; creating a physical primary key of the versioned table; defining to said database management system at least a first portion of said physical primary key as a logical primary key; defining to said database management system at least a second portion of the physical primary key as a version effective reference value; deriving version differentiation criteria information from a version differentiation predicate included in a request submitted by a database user, the version differentiation predicate identifying the versioned table and a target effective status; and retrieving rows of the versioned table that satisfy the version differentiation criteria as a function of the version differentiation predicate submitted by the database user and the version effective reference value defined to said database management system, including comparing the version effective reference value of the versioned table as defined to the database management system with the version differentiation criteria submitted by the database user.
Claim 3
Dependent Claim
70 words
The method for row version differentiation of claim 1 wherein said version effective reference value is a version effective start value, the method for version differentiation further comprising: identifying a version effective end value that does not participate in said physical primary key of said versioned table; said retrieving of rows from the versioned table including comparing the effective end values of the versioned table with the version differentiation criteria.
Claim 4
Dependent Claim
99 words
The method for row version differentiation of claim 2 further comprising: defining an effective window for each row of the versioned table as a function of the effective start value and the version effective end value for each row in the versioned table; and validating the effective window for one row of the versioned table to ensure that the effective window for the one row of the versioned table does not overlap with effective windows for other rows of the versioned table having logical primary keys matching the logical primary key for the one row of the versioned table.
Claim 5
Dependent Claim
69 words
The method for row version differentiation of claim 1 further comprising: identifying to said database management system a referential constraint specifying as a parent said versioned table; and ensuring that rows exist in the versioned table such that the values of their logical primary keys correspond to the values of the columns of a dependent table identified in the referential constraint for an existing row of the dependent table.
Claim 6
Dependent Claim
65 words
The method for row version differentiation of claim 4 wherein said version effective reference value is a version effective start value, the method for version differentiation further including: identifying a column of the dependent table during the definition of said referential constraint for use as a referential constraint effective start value; and comparing said referential constraint effective start value and said versioned effective start value.
Claim 7
Dependent Claim
53 words
The method for row version differentiation of claim 5 further including: identifying a column of the dependent table, during the definition of said referential constraint, for use as a referential constraint effective end value; and comparing said referential constraint effective start value to said versioned effective start value and said effective end value.
Claim 8
Dependent Claim
111 words
The method for row version differentiation of claim 6 further comprising: defining a referential constraint effective window for each row of the dependent table as a function of the referential constraint effective start value and the referential constraint effective end value for each row of the dependent table; and validating the referential constraint effective window for one row of the dependent table to ensure that the referential constraint effective window for the one row of the dependent table does not overlap with the referential constraint effective windows for other rows of the dependent table having logical primary keys matching the logical primary key for the one row of the dependent table.
Claim 9
Independent Claim
195 words
A method for row version differentiation in a database management system comprising: identifying a versioned table to said database management system; creating a physical primary key of the versioned table; defining to said database management system at least a first portion of said physical primary key as a logical primary key; defining to said database management system at least a second portion of the physical primary key as a version effective reference value; deriving version differentiation criteria information from a version differentiation predicate included in a request submitted by a database user, the version differentiation predicate identifying the versioned table and a target effective status, and a target value range as defined by a target start value and a target end value that are included in said version differentiation predicate; and retrieving rows of the versioned table that satisfy the version differentiation criteria as a function of the version differentiation predicate submitted by the user and the version effective reference value defined to said database management system, including comparing the version effective reference value of the versioned table as defined to the database management system with the version differentiation criteria submitted by the database user.
Claim 10
Independent Claim
195 words
A method for row version differentiation in a database management system comprising: identifying a versioned table to said database management system; creating a physical primary key of the versioned table; defining to said database management system at least a first portion of said physical primary key as a logical primary key; defining to said database management system at least a second portion of the physical primary key as a version effective reference value; deriving version differentiation criteria information from a version differentiation predicate included in a request submitted by a database user, the version differentiation predicate identifying the versioned table and a target effective status, and a target value range as defined by a target start value and a target end value that are included in said version differentiation predicate; and retrieving rows of the versioned table that satisfy the version differentiation criteria as a function of the version differentiation predicate submitted by the user and the version effective reference value defined to said database management system, including comparing the version effective reference value of the versioned table as defined to the database management system with the version differentiation criteria submitted by the database user.
Claim 11
Dependent Claim
70 words
The method for row version differentiation of claim 8 further comprising: validating said target value range for one row of the versioned table to ensure that the target value range for the one row of the versioned table does not overlap with the target value ranges for other rows of the versioned table having logical primary keys matching the logical primary key for the one row of the versioned table.
References Cited (Backward Citations)
US4912637A
Cited
US5333310A
Cited
US5594899A
Cited
US5440730A
Cited
US5278979A
Cited
US5347653A
Cited
US5280612A
Cited
US5357631A
Cited
US5386559A
Cited
US5561793A
Cited
US5546576A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2002-09-06 | 2003-03-08 | 2003-09-07 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2006-09-06 | 2007-03-08 | 2007-09-07 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2010-09-06 | 2011-03-08 | 2011-09-07 | $7700.00 | Window Closed / Lapsed |