US6631386B1
Expired / Lapsed
US
⏱️ 0.0 years remaining
Database version control subsystem and method for use with database management system
Assignee: Oracle International Corp
•
Filing: 2000-04-22
•
Granted: 2003-10-07
•
Expires: 2020-04-22
Abstract
Abstract A version control system is described for use in connection with a database management system to facilitate versioning of a database table, the system including a database table and a version control module. The database table comprises a plurality of records, each record including at least one data field for storing user data and at least some of the records including a version control field including version control information. The version control module is configured to, in response to a user query related to the database table and related to a version, generate an augmented query for processing by the data base management system, the augmented query relating to the user query and the version control information. The version control module facilitates association of versions of the database with respective ones of a hierarchy of states and allows conflicts therebetween to be resolved, data to be posted from child states to respective parent states in the hierarchy, and referential constraints between tables to be preserved.
Inventors
- 👤 Gopalan Arun
- 👤 Ramesh Vasudevan
- 👤 Jayanta Banerjee
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-11-09 12:02
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/21; G06F16/219; Y; Y10; Y10S; Y10S707/00; Y10S707/99931; Y10S707/99933; Y10S707/99935; Y10S707/99951; Y10S707/99952; Y10S707/99954
Claims Analysis
Total Claims: 25
Claim 1
Independent Claim
79 words
A method for providing version control of a database, the method comprising: receiving a query specifying a modification to be performed on one of a plurality of records of the database; generating, based on the received query, an augmented query specifying a version of the one record and the manipulation to be performed on the version of the one record; and causing the augmented query to be processed thereby performing the manipulation on the version of the one record.
Claim 2
Independent Claim
79 words
A method for providing version control of a database, the method comprising: receiving a query specifying a modification to be performed on one of a plurality of records of the database; generating, based on the received query, an augmented query specifying a version of the one record and the manipulation to be performed on the version of the one record; and causing the augmented query to be processed thereby performing the manipulation on the version of the one record.
Claim 3
Dependent Claim
17 words
A method of according to claim 1 , wherein the includes one of modification, addition, and deletion.
Claim 4
Dependent Claim
55 words
A method of according to claim 1 , wherein the records are associated with respective versions, each of the records includes: a version identifier field for storing the version of the respective record; and a next version identifier field for storing at least one of another version of the respective record and a default value.
Claim 5
Dependent Claim
30 words
A method according to claim 3 , wherein the version identifier fields and the next version identifier fields effect a tree structure of nodes representing corresponding versions of the records.
Claim 6
Dependent Claim
42 words
A method according to claim 3 , further comprising: determining whether the version of the one record exists; and instructing establishment of a new record based upon the determining step, the new record including a field for specifying a corresponding version identifier.
Claim 7
Dependent Claim
49 words
A method according to claim 1 , wherein each of the records includes a flag field for designating deletion, the method further comprising: determining whether the version of the one record exists; and if the query specifies a deletion, instructing setting of the flag field of the one record.
Claim 8
Dependent Claim
32 words
A method according to claim 1 , further comprising: storing identification information associated with the version of the one record to define a state among a plurality of states of the database.
Claim 9
Dependent Claim
15 words
A method according to claim 7 , wherein the states are in a hierarchical relationship.
Claim 10
Dependent Claim
32 words
A method according to claim 1 , wherein the one record has multiple versions, the method further comprising: providing access to a pre-designated version of the versions in response to the query.
Claim 11
Dependent Claim
34 words
A method according to claim 1 , wherein the one record has multiple versions, the method further comprising: identifying the version among a plurality of versions of the one record to satisfy the query.
Claim 12
Dependent Claim
36 words
A method according to claim 1 , wherein the database includes a plurality of tables containing the records, the further comprising: specifying on a table-by-table basis whether more than one version of the records can exist.
Claim 13
Dependent Claim
32 words
A computer-readable medium bearing instructions for providing version control of a database, said instruction, being arranged, upon execution, to cause one or more processors to perform the method of claim 1 .
Claim 14
Independent Claim
85 words
A system for providing version control of a database, the system comprising: means for receiving a query specifying a modification to be performed on one of a plurality of records of the database; means for generating, based on the received query, an augmented query specifying a version of the one record and the manipulation to be performed on the version of the one record; and means for causing the augmented query to be processed thereby performing the manipulation on the version of the one record.
Claim 15
Independent Claim
85 words
A system for providing version control of a database, the system comprising: means for receiving a query specifying a modification to be performed on one of a plurality of records of the database; means for generating, based on the received query, an augmented query specifying a version of the one record and the manipulation to be performed on the version of the one record; and means for causing the augmented query to be processed thereby performing the manipulation on the version of the one record.
Claim 16
Dependent Claim
18 words
A system of according to claim 13 , wherein the manipulation includes one of modification, addition, and deletion.
Claim 17
Dependent Claim
55 words
A system of according to claim 13 , wherein the records are associated with respective versions, each of the records includes: a version identifier field for storing the version of the respective record; and a next version identifier field for storing at least one of another version of the respective record and a default value.
Claim 18
Dependent Claim
30 words
A system according to claim 15 , wherein the version identifier fields and the next version identifier fields effect a tree structure of nodes representing corresponding versions of the records.
Claim 19
Dependent Claim
46 words
A system according to claim 15 , further comprising: means for determining whether the version of the one record exists; and means for instructing establishment of a new record based upon the determining step, the new record including a field for specifying a corresponding version identifier.
Claim 20
Dependent Claim
53 words
A system according to claim 13 , wherein each of the records includes a flag field for designating deletion, the system further comprising: means for determining whether the version of the one record exists; and means for instructing setting of the flag field of the one record upon the query specifying a deletion.
Claim 21
Dependent Claim
34 words
A system according to claim 13 , further comprising: means for storing identification information associated with the version of the one record to define a state among a plurality of states of the database.
Claim 22
Dependent Claim
15 words
A system according to claim 19 , wherein the states are in a hierarchical relationship.
Claim 23
Dependent Claim
34 words
A system according to claim 13 , wherein the one record has multiple versions, the system further comprising: means for providing access to a pre-designated version of the versions in response to the query.
Claim 24
Dependent Claim
36 words
A system according to claim 13 , wherein the one record has multiple versions, the system further comprising: means for identifying the version among a plurality of versions of the one record to satisfy the query.
Claim 25
Dependent Claim
38 words
A system according to claim 13 , wherein the database includes a plurality of tables containing the records, the further comprising: means for specifying on a table-by-table basis whether more than one version of the records can exist.
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) | 2006-10-06 | 2007-04-07 | 2007-10-07 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2010-10-06 | 2011-04-07 | 2011-10-07 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2014-10-06 | 2015-04-07 | 2015-10-07 | $7700.00 | Window Closed / Lapsed |