The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Nov. 19, 2013
Filed:
Sep. 28, 2007
Venkatesh Radhakrishnan, Cupertino, CA (US);
Vasudha Krishnaswamy, Fremont, CA (US);
Liang Guo, San Jose, CA (US);
Bipul Sinha, Foster City, CA (US);
Amit Ganesh, San Jose, CA (US);
Venkatesh Radhakrishnan, Cupertino, CA (US);
Vasudha Krishnaswamy, Fremont, CA (US);
Liang Guo, San Jose, CA (US);
Bipul Sinha, Foster City, CA (US);
Amit Ganesh, San Jose, CA (US);
Oracle International Corporation, Redwood Shores, CA (US);
Abstract
A technique for making versions of rows of a user-defined tracked table temporally queryable. The database management system of the technique permits temporal queries of user-defined tables. The queries return versions of rows in the user-defined table that are currently in an undo log maintained by the database system. Associated with the tracked table are a system history table which contains versions of the rows and temporal metadata indicating when the versions were in the tracked table and a system form history table which contains versions of the form of the tracked table and metadata indicating when the tracked table had the form. These tables are created and maintained by a background process in the database management system. A temporal query on the tracked table combines results from the undo log with results from the system history table. The results' form is determined by the system form history table.