US6557012B1
Expired / Lapsed
US
⏱️ 0.0 years remaining
System and method of refreshing and posting data between versions of a database table
Assignee: Oracle International Corp
•
Filing: 2000-04-22
•
Granted: 2003-04-29
•
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 database 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
- 👤 Sanjay Agarwal
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-11-09 11:28
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/21; G06F16/219; Y; Y10; Y10S; Y10S707/00; Y10S707/99931; Y10S707/99933; Y10S707/99951; Y10S707/99952; Y10S707/99954
Claims Analysis
Total Claims: 22
Claim 1
Independent Claim
123 words
A method for posting versions of records of a database, the method comprising: receiving a command from a user to post one of the records, wherein a hierarchy of states of the database is established according to the versions of the records, the states including a parent state and a child state, the one record having versions in the parent state and the child state; generating one or more queries, in response to the received command, to copy the version of one of the records in the child state to the version of the one record in the parent state, and to delete the version of the one record in the child state; and causing the one or more queries to be processed.
Claim 2
Independent Claim
123 words
A method for posting versions of records of a database, the method comprising: receiving a command from a user to post one of the records, wherein a hierarchy of states of the database is established according to the versions of the records, the states including a parent state and a child state, the one record having versions in the parent state and the child state; generating one or more queries, in response to the received command, to copy the version of one of the records in the child state to the version of the one record in the parent state, and to delete the version of the one record in the child state; and causing the one or more queries to be processed.
Claim 3
Dependent Claim
30 words
A method of according to claim 1 , wherein the version of the one record in the child state in the generating step has changed since a previous post operation.
Claim 4
Dependent Claim
38 words
A method of according to claim 1 , wherein the version of the one record in the child state is a latest version and the version of the one record in the parent state is a latest version.
Claim 5
Dependent Claim
42 words
A method according to claim 1 , further comprising: generating one or more queries to insert a version identifier associated with the version of the one record in the child state to the version of the one record in the parent state.
Claim 6
Dependent Claim
33 words
A method according to claim 1 , further comprising: determining that the version of the one record in the child state differs from the version of the one record in the parent state.
Claim 7
Dependent Claim
41 words
A method according to claim 1 , further comprising: generating one or more queries to store a value indicating synchronization in each of the one record in the child state and the version of the one record in the parent state.
Claim 8
Dependent Claim
33 words
A computer-readable medium bearing instructions for posting versions of records of a database, said instruction, being arranged, upon execution, to cause one or more processors to perform the method of claim 1 .
Claim 9
Independent Claim
129 words
A system for posting versions of records of a database, the system comprising: means for receiving a command from a user to post one of the records, wherein a hierarchy of states of the database is established according to the versions of the records, the states including a parent state and a child state, the one record having versions in the parent state and the child state; means for generating one or more queries, in response to the received command, to copy the version of one of the records in the child state to the version of the one record in the parent state, and to delete the version of the one record in the child state; and means for causing the one or more queries to be processed.
Claim 10
Independent Claim
129 words
A system for posting versions of records of a database, the system comprising: means for receiving a command from a user to post one of the records, wherein a hierarchy of states of the database is established according to the versions of the records, the states including a parent state and a child state, the one record having versions in the parent state and the child state; means for generating one or more queries, in response to the received command, to copy the version of one of the records in the child state to the version of the one record in the parent state, and to delete the version of the one record in the child state; and means for causing the one or more queries to be processed.
Claim 11
Dependent Claim
26 words
A system of according to claim 8 , wherein the version of the one record in the child state has changed since a previous post operation.
Claim 12
Dependent Claim
38 words
A system of according to claim 8 , wherein the version of the one record in the child state is a latest version and the version of the one record in the parent state is a latest version.
Claim 13
Dependent Claim
42 words
A system according to claim 8 , further comprising: generating one or more queries to insert a version identifier associated with the version of the one record in the child state to the version of the one record in the parent state.
Claim 14
Dependent Claim
35 words
A system according to claim 8 , further comprising: means for determining that the version of the one record in the child state differs from the version of the one record in the parent state.
Claim 15
Dependent Claim
43 words
A system according to claim 8 , further comprising: means for generating one or more queries to store a value indicating synchronization in each of the one record in the child state and the version of the one record in the parent state.
Claim 16
Independent Claim
96 words
A method for refreshing versions of records of a database, the method comprising: receiving a command from a user to refresh one of the records, wherein a hierarchy of states of the database is established according to the versions of the records, the states including a parent state and a child state, the one record having versions in the parent state and the child state; and updating versions of the records in the child state with conflicting versions of the records in the parent state after creation of the child state in response to the command.
Claim 17
Independent Claim
96 words
A method for refreshing versions of records of a database, the method comprising: receiving a command from a user to refresh one of the records, wherein a hierarchy of states of the database is established according to the versions of the records, the states including a parent state and a child state, the one record having versions in the parent state and the child state; and updating versions of the records in the child state with conflicting versions of the records in the parent state after creation of the child state in response to the command.
Claim 18
Dependent Claim
93 words
A method according to claim 14 , wherein each of the records includes a field for storing a version identifier and a field for storing a next version identifier, the method further comprising: generating one or more queries to chain the versions of the records whose user data was posted from the child state to the parent state by storing, for each record associated with the posted user data, the version identifier for the child version in the next version identifier field of the version of the record associated with the parent state.
Claim 19
Dependent Claim
33 words
A computer-readable medium bearing instructions for refreshing versions of records of a database, said instruction, being arranged, upon execution, to cause one or more processors to perform the method of claim 14 .
Claim 20
Independent Claim
100 words
A system for refreshing versions of records of a database, the system comprising: means for receiving a command from a user to refresh one of the records, wherein a hierarchy of states of the database is established according to the versions of the records, the states including a parent state and a child state, the one record having versions in the parent state and the child state; and means for updating versions of the records in the child state with conflicting versions of the records in the parent state after creation of the child state in response to the command.
Claim 21
Independent Claim
100 words
A system for refreshing versions of records of a database, the system comprising: means for receiving a command from a user to refresh one of the records, wherein a hierarchy of states of the database is established according to the versions of the records, the states including a parent state and a child state, the one record having versions in the parent state and the child state; and means for updating versions of the records in the child state with conflicting versions of the records in the parent state after creation of the child state in response to the command.
Claim 22
Dependent Claim
95 words
A system according to claim 17 , wherein each of the records includes a field for storing a version identifier and a field for storing a next version identifier, the system further comprising: means for generating one or more queries to chain the versions of the records whose user data was posted from the child state to the parent state by storing, for each record associated with the posted user data, the version identifier for the child version in the next version identifier field of the version of the record associated with the parent state.
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-04-28 | 2006-10-28 | 2007-04-29 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2010-04-28 | 2010-10-28 | 2011-04-29 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2014-04-28 | 2014-10-28 | 2015-04-29 | $7700.00 | Window Closed / Lapsed |