公开(公告)号：US20220414075A1

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

申请号：US17897008

申请日：2022-08-26

Applicant: HUAWEI TECHNOLOGIES CO., LTD.

Inventor： Guoliang LI ,  Tianqing WANG ,  Shifu LI ,  Lingtao LI ,  Kun LI

IPC: G06F16/21 ,  G06F16/242 ,  G06F16/2453

Abstract: Disclosed is a method for estimating database management system performance, in which a performance change ratio of a DBMS can be determined once a first knob group, a second knob group, and a data volume of active data in data managed by the DBMS are obtained, without actually configuring the second knob group in the DBMS, executing a job by the DBMS, and then observing the execution. In other words, the performance change ratio of the DBMS can be estimated without interacting with the DBMS. DBMS security can be ensured, performance measurement approaches are provided for self-tuning and self-management of the DBMS, and reliable and stable running of the DBMS is ensured.

公开(公告)号：US20220067008A1

公开(公告)日：2022-03-03

申请号：US17525435

申请日：2021-11-12

Applicant: Huawei Technologies Co., Ltd. ,  TSINGHUA UNIVERSITY

Inventor： Guoliang LI ,  Shifu LI ,  Xuanhe ZHOU ,  Bo GAO

IPC: G06F16/21 ,  G06F16/2453 ,  G06N3/04 ,  G06K9/62

Abstract: A method for determining a configuration knob of a database is disclosed, and may be applied to a database management system. In this method, vectorization coding is performed on a query statement, to obtain a target feature vector of the query statement, and then a configuration knob set for determining the database is determined based on two aspects of double-state information: the target feature vector and current status information of the database (101). The configuration knob set is used to execute N query statements. The configuration knob of the database (101) may be dynamically determined based on the query statement and the current status information of the database (101), so that good performance of the database (101) in a case of different workload requirements, for example, performance in aspects of a delay and a throughput, can be ensured.

公开(公告)号：US20240152807A1

公开(公告)日：2024-05-09

申请号：US18398359

申请日：2023-12-28

Applicant: HUAWEI TECHNOLOGIES CO., LTD.

Inventor： Shifu LI ,  Tianqing WANG ,  Wen NIE

IPC: G06N20/00 ,  G06F16/2455

CPC classification number: G06N20/00 ,  G06F16/24564

Abstract: A data processing method applied to a database system is disclosed. The method includes: obtaining a model training request, where the model training request includes a plurality of training samples and a model training policy, and the plurality of training samples is grouped into N training sample groups; generating an execution plan of the model training policy and an estimated execution cost of the execution plan executed by the database system; obtaining, based on the estimated execution cost, M training sample groups in the N training sample groups; training a to-be-trained model in parallel by using the M training sample groups, to obtain M pieces of parameter update data; and updating the to-be-trained model based on the M pieces of parameter update data, to obtain a trained model. This method reduces time overheads of the model training.

公开(公告)号：US20220067044A1

公开(公告)日：2022-03-03

申请号：US17525400

申请日：2021-11-12

Applicant: HUAWEI TECHNOLOGIES CO., LTD.

Inventor： Guoliang LI ,  Sihao LI ,  Jinyu ZHANG ,  Yahui DONG ,  Pinggao ZHOU ,  Shifu LI

IPC: G06F16/2453 ,  G06F16/2455 ,  G06F11/34 ,  G06F11/14 ,  G06F16/25

Abstract: Some embodiments provide a microservice component-based database system, to split a database kernel into microservice components that can be enabled and run independently and whose functions are decoupled, and implement flexible database assembly and management. The microservice component can be deployed based on a system resource and a service form. The components can collaborate with each other by using a lightweight communication mechanism. A component manager provides capabilities such as registration and deregistration of a service component, component resource management, component fault tolerance, and component upgrade, to implement dynamic management of the component in a running environment. A job scheduler selects, based on a job submitted by a user, an optimal execution path including a plurality of components, and performs resource management and scheduling in a job execution process, to implement load balancing and high availability.