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:
Sep. 23, 2025
Filed:
Apr. 25, 2022
Oracle International Corporation, Redwood Shores, CA (US);
Yunrui Li, Los Altos, CA (US);
Wei-Ming Hu, Palo Alto, CA (US);
Juan R. Loaiza, Woodside, CA (US);
J. William Lee, Saratoga, CA (US);
Adam Y. Lee, Palo Alto, CA (US);
Carlos Ruiz, Madrid, ES;
Amrish Srivastava, San Ramon, CA (US);
Garret F. Swart, Palo Alto, CA (US);
Mahesh Baburao Girkar, Los Altos, CA (US);
Oracle International Corporation, Redwood Shores, CA (US);
Abstract
Techniques are described herein for an integrated in-front database cache ('IIDC') providing an in-memory, consistent, and automatically managed cache for primary database data. An IIDC comprises a database server instance that (a) caches data blocks from a source database managed by a second database server instance, and (b) performs recovery on the cached data using redo records for the database data. The IIDC instance implements relational algebra and is configured to run any complexity of query over the cached database data. Any cache miss results in the IIDC instance fetching the needed block(s) from a second database server instance managing the source database that provides the IIDC instance with the latest version of the requested data block(s) that is available to the second instance. Because redo records are used to continuously update the data blocks in an IIDC cache, the IIDC guarantees consistency of query results.