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.

Date of Patent:
Apr. 29, 2025

Filed:

May. 24, 2023
Applicant:

Oracle International Corporation, Redwood Shores, CA (US);

Inventors:

Mahendra Maiti, Fremont, CA (US);

Hariharan Lakshmanan, Brisbane, CA (US);

Shasank Kisan Chavan, Menlo Park, CA (US);

Assignee:

Oracle International Corporation, Redwood Shores, CA (US);

Attorney:
Primary Examiner:
Assistant Examiner:
Int. Cl.
CPC ...
G06F 16/27 (2018.12); G06F 11/34 (2005.12); G06F 12/02 (2005.12); G06F 16/22 (2018.12); G06F 16/23 (2018.12); G06F 16/245 (2018.12); G06F 16/2453 (2018.12); G06F 16/2455 (2018.12); G06F 16/25 (2018.12); G06F 16/28 (2018.12);
U.S. Cl.
CPC ...
G06F 16/27 (2018.12); G06F 11/3414 (2012.12); G06F 11/3419 (2012.12); G06F 12/023 (2012.12); G06F 16/221 (2018.12); G06F 16/2219 (2018.12); G06F 16/2365 (2018.12); G06F 16/2379 (2018.12); G06F 16/2453 (2018.12); G06F 16/24552 (2018.12); G06F 16/24561 (2018.12); G06F 16/24569 (2018.12); G06F 16/258 (2018.12); G06F 16/285 (2018.12);
Abstract

Techniques are provided for determining an optimal configuration for an in-memory store based on both benefits and overhead that would result from having database elements populated in the in-memory store. The techniques include determining an overhead-adjusted benefit score for each element based, at least in part, on (a) a scan-benefit value, (b) a scan-overhead value, and (c) a DML-overhead value. Based on the plurality of overhead-adjusted benefit scores, the database determines an optimal configuration of the in-memory store, and then evicts in-memory copies of elements and/or loads in-memory copies of elements based on the optimal configuration.


Find Patent Forward Citations

Loading…