Monitoring Database Processes to Generate Machine Learning Predictions
AssigneeOracle International Corporation
InventorsSudhir ARTHANAT, Prashant PRAKASH
Life of this patent
Estimating the term…
Abstract
Methods and system are presented for monitoring database processes to generate machine learning predictions. A plurality of database processes executed on database implementations can be monitored, wherein the monitoring includes determining a start time, an end time, and a number of rows impacted by portions of the database processes, and the monitored database processes generate instances of machine learning data including at least the number of rows impacted and an associated duration of time. Using a machine learning component and the machine learning data, a duration of time can be predicted for a candidate database process for execution on a database implementation.
Claims20
A method for monitoring database processes to generate machine learning predictions, the method comprising:
- monitoring a plurality of database processes executed on database implementations, wherein the monitoring comprises determining a start time, an end time, and a number of rows impacted by portions of the database processes, and the monitored database processes generate instances of machine learning data comprising at least the number of rows impacted and an associated duration of time;
- and
- predicting, using a machine learning component and the machine learning data, a duration of time for a candidate database process for execution on a database implementation.
A system for monitoring database processes to generate machine learning predictions, the system comprising:
- a processor in communication with a storage device, wherein the processor is configured to:
- monitor a plurality of database processes executed on database implementations, wherein the monitoring comprises determining a start time, an end time, and a number of rows impacted by portions of the database processes, and the monitored database processes generate instances of machine learning data comprising at least the number of rows impacted and an associated duration of time;
- and
- predict, using a machine learning component and the machine learning data, a duration of time for a candidate database process for execution on a database implementation.
A non-transitory computer readable medium having instructions stored thereon that, when executed by a processor, cause the processor to monitor database processes to generate machine learning predictions, wherein, when executed, the instructions cause the processor to:
- monitor a plurality of database processes executed on database implementations, wherein the monitoring comprises determining a start time, an end time, and a number of rows impacted by portions of the database processes, and the monitored database processes generate instances of machine learning data comprising at least the number of rows impacted and an associated duration of time;
- and
- predict, using a machine learning component and the machine learning data, a duration of time for a candidate database process for execution on a database implementation.
Dependencies are inferred from the claim text.