公开(公告)号：US11256698B2

公开(公告)日：2022-02-22

申请号：US16382085

申请日：2019-04-11

Applicant: Oracle International Corporation

Inventor： Sam Idicula ,  Tomas Karnagel ,  Jian Wen ,  Seema Sundara ,  Nipun Agarwal ,  Mayur Bency

IPC: G06F16/2453 ,  G06F16/21 ,  G06N20/00 ,  G06N20/20

Abstract: Embodiments utilize trained query performance machine learning (QP-ML) models to predict an optimal compute node cluster size for a given in-memory workload. The QP-ML models include models that predict query task runtimes at various compute node cardinalities, and models that predict network communication time between nodes of the cluster. Embodiments also utilize an analytical model to predict overlap between predicted task runtimes and predicted network communication times. Based on this data, an optimal cluster size is selected for the workload. Embodiments further utilize trained data capacity machine learning (DC-ML) models to predict a minimum number of compute nodes needed to run a workload. The DC-ML models include models that predict the size of the workload dataset in a target data encoding, models that predict the amount of memory needed to run the queries in the workload, and models that predict the memory needed to accommodate changes to the dataset.

公开(公告)号：US20210406717A1

公开(公告)日：2021-12-30

申请号：US16914816

申请日：2020-06-29

Applicant: Oracle International Corporation

Inventor： Farhan Tauheed ,  Onur Kocberber ,  Tomas Karnagel ,  Nipun Agarwal

IPC: G06N5/04 ,  G06N20/00 ,  G06F16/22

Abstract: Herein are approaches for self-optimization of a database management system (DBMS) such as in real time. Adaptive just-in-time sampling techniques herein estimate database content statistics that a machine learning (ML) model may use to predict configuration settings that conserve computer resources such as execution time and storage space. In an embodiment, a computer repeatedly samples database content until a dynamic convergence criterion is satisfied. In each iteration of a series of sampling iterations, a subset of rows of a database table are sampled, and estimates of content statistics of the database table are adjusted based on the sampled subset of rows. Immediately or eventually after detecting dynamic convergence, a machine learning (ML) model predicts, based on the content statistic estimates, an optimal value for a configuration setting of the DBMS.

公开(公告)号：US20210263934A1

公开(公告)日：2021-08-26

申请号：US17318972

申请日：2021-05-12

Applicant: Oracle International Corporation

Inventor： Sam Idicula ,  Tomas Karnagel ,  Jian Wen ,  Seema Sundara ,  Nipun Agarwal ,  Mayur Bency

IPC: G06F16/2453 ,  G06N20/00 ,  G06F16/21 ,  G06N20/20

Abstract: Embodiments implement a prediction-driven, rather than a trial-driven, approach to automate database configuration parameter tuning for a database workload. This approach uses machine learning (ML) models to test performance metrics resulting from application of particular database parameters to a database workload, and does not require live trials on the DBMS managing the workload. Specifically, automatic configuration (AC) ML models are trained, using a training corpus that includes information from workloads being run by DBMSs, to predict performance metrics based on workload features and configuration parameter values. The trained AC-ML models predict performance metrics resulting from applying particular configuration parameter values to a given database workload being automatically tuned. Based on correlating changes to configuration parameter values with changes in predicted performance metrics, an optimization algorithm is used to converge to an optimal set of configuration parameters. The optimal set of configuration parameter values is automatically applied for the given workload.