US 11,921,717 B2
Predicting future quiet periods for materialized views
Murali Thiyagarajan, Concord, NH (US); and Praveen T. J. Kumar, Nashua, NH (US)
Assigned to Oracle International Corporation, Redwood Shores, CA (US)
Filed by Oracle International Corporation, Redwood Shores, CA (US)
Filed on Dec. 18, 2020, as Appl. No. 17/127,712.
Claims priority of provisional application 63/078,242, filed on Sep. 14, 2020.
Prior Publication US 2022/0083547 A1, Mar. 17, 2022
Int. Cl. G06F 16/2453 (2019.01); G06F 16/23 (2019.01); G06F 16/248 (2019.01); G06F 18/214 (2023.01); G06F 18/24 (2023.01)
CPC G06F 16/24539 (2019.01) [G06F 16/2358 (2019.01); G06F 16/2393 (2019.01); G06F 16/248 (2019.01); G06F 18/2148 (2023.01); G06F 18/24765 (2023.01)] 17 Claims
OG exemplary drawing
 
1. A method for predicting a future quiet period of a materialized view, the method comprising:
tracking change activity on one or more base database objects referenced in the materialized view;
storing object activity tracking data reflecting the change activity;
training, based on the object activity tracking data reflecting the change activity, a classification model for the materialized view;
predicting, by the trained classification model, that there will be no future change activity on the one or more base database objects during a future time interval;
computing a performance benefit of having the materialized view not be stale;
predicting a number of query rewrites that will access the materialized view during the future time interval; and
scheduling the materialized view for a refresh based on the performance benefit of having the materialized view not be stale multiplied by the number of query rewrites that will access the materialized view during the future time interval.