System, structure, interface, and semantics for implementing row versions: accessing past versions of a data item
First Claim
1. A computer implemented method for displaying past versions of a data item in a database table, comprising:
- using a computing system that comprises at least one processor and is configured or programmed for performing a process comprising;
receiving a request on the database table of a database system for one or more past versions of a data item over an interval, whereinthe request comprises a specification of the interval,the database system comprises the database table and a log record which comprises an undo log record for the database system that is stored separately from the database table and is used to reverse one or more changes made to the database table, andthe database table comprises the data item;
applying a portion of the log record to the database table to create one or more prior-version database tables for the database table that comprise the one or more past versions, whereineach of the database table and the one or more prior-version database tables comprises a single version of the data itemretrieving the one or more past versions of the data item over the interval by querying against the one or more prior-version database tables that were created by applying the portion of the log record to the database table to identify the one or more past versions over the interval from the one or more prior-version database tables; and
presenting information about the one or more past versions over the interval.
1 Assignment
0 Petitions
Accused Products
Abstract
Disclosed is a mechanism, system, interface, and process to allow specification of a new table decoration clause to obtain one or more past version of one or more data items. The version query provides for a direct interface to get multiple versions of the row(s). In addition, information about the past versions can be retrieved and displayed along with the past versions. Also disclosed are algorithms, mechanisms, and processes that are employed to implement a query upon past versions. In one approach, the version query can be defined as either “rowid”-based access or non-rowid based access. With rowid based access, a given rowid is used to identify the data for which past versions are desired. Also disclosed is a process for determining one or more life intervals when given a key.
36 Citations
29 Claims
-
1. A computer implemented method for displaying past versions of a data item in a database table, comprising:
-
using a computing system that comprises at least one processor and is configured or programmed for performing a process comprising; receiving a request on the database table of a database system for one or more past versions of a data item over an interval, wherein the request comprises a specification of the interval, the database system comprises the database table and a log record which comprises an undo log record for the database system that is stored separately from the database table and is used to reverse one or more changes made to the database table, and the database table comprises the data item; applying a portion of the log record to the database table to create one or more prior-version database tables for the database table that comprise the one or more past versions, wherein each of the database table and the one or more prior-version database tables comprises a single version of the data item retrieving the one or more past versions of the data item over the interval by querying against the one or more prior-version database tables that were created by applying the portion of the log record to the database table to identify the one or more past versions over the interval from the one or more prior-version database tables; and presenting information about the one or more past versions over the interval. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23)
-
-
24. A computer program product comprising a tangible computer usable medium having executable code to execute a process for displaying past versions of a data item in a database table, the process comprising the steps of:
-
receiving a request on the database table of a database system for one or more past versions of a data item over an interval, wherein the request comprises a specification of the interval, the database system comprises the database table and a log record which comprises an undo log record for the database system that is stored separately from the database table and is used to reverse one or more changes made to the database table, and the database table comprises the data item; applying a portion of the log record to the database table to create one or more prior-version database tables for the database table that comprise the one or more past versions, wherein each of the database table and the one or more the prior-version database tables comprises a single version of the data item; retrieving the one or more past versions of the data item over the interval by querying against the one or more prior-version database tables that were created by applying the portion of the log record to the database table to identify the one or more past versions over the interval from the one or more prior-version database tables; and presenting information about the one or more past versions over the interval. - View Dependent Claims (25, 26)
-
-
27. A system for displaying past versions of a data item in a database table, comprising:
-
a computing system that comprises at least one processor and is configured or programmed for performing a process comprising; receiving a request on the database table of a database system for one or more past versions of a data item over an interval, wherein the request comprises a specification of the interval, the database system comprises the database table and a log record which comprises an undo log record for the database system that is stored separately from the database table and is used to reverse one or more changes made to the database table, and the database table comprises the data item; applying a portion of the log record to the database table to create one or more prior-version database tables for the database table that comprise the one or more past versions, wherein each of the database table and the one or more prior-version database tables comprises a single version of the data item; retrieving the one or more past versions of the data item over the interval by querying against the one or more prior-version database tables that were created by applying the portion of the log record to the database table to identify the one or more past versions over the interval from the one or more prior-version database tables; and presenting information about the one or more past versions over the interval. - View Dependent Claims (28, 29)
-
Specification