US 11,940,966 B2
Method, apparatus, and system for estimating database management system performance
Guoliang Li, Beijing (CN); Tianqing Wang, Beijing (CN); Shifu Li, Beijing (CN); Lingtao Li, Shenzhen (CN); and Kun Li, Beijing (CN)
Assigned to HUAWEI TECHNOLOGIES CO., LTD., Guangdong (CN)
Filed by HUAWEI TECHNOLOGIES CO., LTD., Guangdong (CN)
Filed on Aug. 26, 2022, as Appl. No. 17/897,008.
Application 17/897,008 is a continuation of application No. PCT/CN2020/113204, filed on Sep. 3, 2020.
Claims priority of application No. 202010134058.0 (CN), filed on Feb. 28, 2020.
Prior Publication US 2022/0414075 A1, Dec. 29, 2022
Int. Cl. G06F 16/00 (2019.01); G06F 16/21 (2019.01); G06F 16/242 (2019.01); G06F 16/2453 (2019.01)
CPC G06F 16/217 (2019.01) [G06F 16/2433 (2019.01); G06F 16/24542 (2019.01)] 16 Claims
OG exemplary drawing
 
1. A method for estimating database management system performance, comprising:
obtaining a first knob group configured for a database management system (DBMS), and obtaining a first data volume of active data in data managed by the DBMS, wherein the first knob group comprises at least one first knob;
obtaining a second knob group, wherein the second knob group comprises at least one second knob;
determining a performance change ratio of the DBMS based on the first knob group, the second knob group, and the first data volume of the active data, wherein the performance change ratio indicates a change degree of DBMS performance achieved after the DBMS is configured using the second knob group compared with DBMS performance achieved when the DBMS is configured using the first knob group; and
estimating a performance indicator of the DBMS based on the performance change ratio of the DBMS, a first estimated execution duration for the DBMS to execute a structured query language (SQL) statement, and the first data volume of the active data, wherein the performance indicator comprises at least one of second estimated execution duration of the SQL statement and a throughput of the DBMS, and the second estimated execution duration is a modification value of the first estimated execution duration.