公开(公告)号：US11537615B2

公开(公告)日：2022-12-27

申请号：US15959442

申请日：2018-04-23

Applicant: Futurewei Technologies, Inc.

Inventor： Lei Liu ,  Mingyi Zhang ,  Yu Dong ,  Huaizhi Li ,  Yantao Qiao

IPC: G06F16/00 ,  G06F7/00 ,  G06F16/2453 ,  G06F17/16 ,  G06N5/04 ,  G06N20/00 ,  G06F16/28 ,  G06N20/10

Abstract: Methods and apparatus are provided for using machine learning to estimate query resource consumption in a massively parallel processing database (MPPDB). In various embodiments, the machine learning may jointly perform query resource consumption estimation for a query and resource extreme events detection together, utilize an adaptive kernel that is configured to learn most optimal similarity relation metric for data from each system settings, and utilize multi-level stacking technology configured to leverage outputs of diverse base classifier models. Advantages and benefits of the disclosed embodiments include providing faster and more reliable system performance and avoiding resource issues such as out of memory (OOM) occurrences.

公开(公告)号：US20180314735A1

公开(公告)日：2018-11-01

申请号：US15959442

申请日：2018-04-23

Applicant: Futurewei Technologies, Inc.

Inventor： Lei Liu ,  Mingyi Zhang ,  Yu Dong ,  Huaizhi Li ,  Yantao Qiao

IPC: G06F17/30 ,  G06F17/16 ,  G06N99/00 ,  G06N5/04

Abstract: Methods and apparatus are provided for using machine learning to estimate query resource consumption in a massively parallel processing database (MPPDB). In various embodiments, the machine learning may jointly perform query resource consumption estimation for a query and resource extreme events detection together, utilize an adaptive kernel that is configured to learn most optimal similarity relation metric for data from each system settings, and utilize multi-level stacking technology configured to leverage outputs of diverse base classifier models. Advantages and benefits of the disclosed embodiments include providing faster and more reliable system performance and avoiding resource issues such as out of memory (OOM) occurrences.