Patent ID: 11940966
Assignee: HUAWEI TECHNOLOGIES CO., LTD.
Field: Computer technology (Electrical engineering)
Classification: CPC G | IPC G

Claim 0:
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.