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. 29, 2022
Filed:
Dec. 18, 2020
Applicant:
Oracle International Corporation, Redwood Shores, CA (US);
Inventors:
Murali Thiyagarajan, Concord, NH (US);
Praveen T. J. Kumar, Nashua, NH (US);
Assignee:
Oracle International Corporation, Redwood Shores, CA (US);
Attorney:
Primary Examiner:
Int. Cl.
CPC ...
G06F 16/2453 (2019.01); G06F 16/23 (2019.01); G06F 16/248 (2019.01); G06K 9/62 (2022.01); G06N 20/00 (2019.01);
U.S. Cl.
CPC ...
G06F 16/24539 (2019.01); G06F 16/2358 (2019.01); G06F 16/2393 (2019.01); G06F 16/248 (2019.01); G06K 9/626 (2013.01); G06K 9/6257 (2013.01); G06N 20/00 (2019.01);
Abstract
Techniques for a database management system to estimate a time needed to refresh a materialized view. This is a followed by an approach that uses estimated refresh duration to determine an optimized schedule for refreshing the materialized view. The approach combines the refresh duration estimate with a query rewrite pattern prediction for the materialized view and a quiet period prediction for the materialized view to determine the optimized refresh schedule for the materialized view.