Patent ID: 11921717
Assignee: ORACLE INTERNATIONAL CORPORATION
Field: Computer technology (Electrical engineering)
Classification: CPC G | IPC G

Claim 0:
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.