Huawei Technologies Co., Limited

Tsinghua University

Shifu Li

Guoliang Li

Bo Gao

Kun Li

Jinyu Zhang

Pinggao Zhou

Sihao Li

YaHui Dong

Tianqing Wang

Lingtao Li

Xuanhe Zhou

Yahui Dong

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 (). The configuration knob set is used to execute N query statements. The configuration knob of the database () may be dynamically determined based on the query statement and the current status information of the database (), so that good performance of the database () in a case of different workload requirements, for example, performance in aspects of a delay and a throughput, can be ensured.

Method and apparatus for determining configuration knob of database

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.

Microservice component-based database system and related method

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.

Method, apparatus, and system for estimating database management system performance

Growing community of inventors

Beijing, China

Shifu Li