公开(公告)号：US20250021531A1

公开(公告)日：2025-01-16

申请号：US18900853

申请日：2024-09-29

Applicant: HUAWEI TECHNOLOGIES CO., LTD.

Inventor： Ji Sun ,  Shifu Li ,  Shujie Zhang ,  Guoliang Li

IPC: G06F16/21 ,  G06N5/022

Abstract: A cardinality estimation method and an apparatus are provided. The method includes: selecting a target model type from a plurality of model types based on a target distribution feature and mapping relationship information, where the mapping relationship information includes a mapping relationship between the plurality of model types and a predicted distribution feature, and the target distribution feature is extracted from sample data collected based on an analysis instruction; and obtaining, based on the target model type, a target model corresponding to the target model type, where the target model is used to perform cardinality estimation on a query instruction of a database.

公开(公告)号：US12164488B2

公开(公告)日：2024-12-10

申请号：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 ,  G06F18/23 ,  G06N3/048

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.

公开(公告)号：US12032572B2

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

申请号：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 ,  G06F11/14 ,  G06F11/34 ,  G06F16/2455 ,  G06F16/25

CPC classification number: G06F16/24542 ,  G06F11/1423 ,  G06F11/3433 ,  G06F16/2455 ,  G06F16/256

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.

公开(公告)号：US11940966B2

公开(公告)日：2024-03-26

申请号：US17897008

申请日：2022-08-26

Applicant: HUAWEI TECHNOLOGIES CO., LTD.

Inventor： Guoliang Li ,  Tianqing Wang ,  Shifu Li ,  Lingtao Li ,  Kun Li

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

CPC classification number: G06F16/217 ,  G06F16/2433 ,  G06F16/24542

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.