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:
May. 23, 2023
Filed:
Aug. 31, 2016
Oracle International Corporation, Redwood Shores, CA (US);
Vasudha Krishnaswamy, Fremont, CA (US);
Yunrui Li, Fremont, CA (US);
Vivekanandhan Raja, Foster City, CA (US);
Tirthankar Lahiri, Palo Alto, CA (US);
Mahesh B. Girkar, Cupertino, CA (US);
Sukhada Pendse, Foster City, CA (US);
Kartik Kulkarni, Foster City, CA (US);
Jing Zheng, Foster City, CA (US);
Shruti Gautam, San Mateo, CA (US);
Henry Chau, Sunnyvale, CA (US);
Oracle International Corporation, Redwood Shores, CA (US);
Abstract
Techniques related to query execution against an in-memory standby database are disclosed. A first database includes PF data stored on persistent storage in a persistent format. The first database is accessible to a first database server that converts the PF data to a mirror format to produce MF data that is stored within volatile memory. The first database server receives, from a second database server, one or more change records indicating one or more transactions performed against a second database. The one or more change records are applied to the PF data, and a reference timestamp is advanced from a first to a second timestamp. The first database server invalidates any MF data that is changed by a subset of the one or more transactions that committed between the first and second timestamps.