Method and apparatus for determining configuration knob of database
US12164488B2 · kind B2 · utility
Assignees
Inventors
Key dates
| Filing date | Nov 12, 2021 |
| Grant date | Dec 10, 2024 |
| Priority date | — |
| Expiry date | Apr 25, 2042 |
Classification
- Technology area (CPC Y)Emerging Cross-Sectional Technologies
- CPC primaryY02D10/00
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
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.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.