US 12,298,843 B2
Database management method and apparatus
Yunfei Lu, Shenzhen (CN)
Assigned to Huawei Technologies Co., Ltd., Shenzhen (CN)
Filed by HUAWEI TECHNOLOGIES CO., LTD., Shenzhen (CN)
Filed on Jul. 24, 2023, as Appl. No. 18/357,925.
Application 18/357,925 is a continuation of application No. PCT/CN2022/072404, filed on Jan. 17, 2022.
Claims priority of application No. 202110099384.7 (CN), filed on Jan. 25, 2021.
Prior Publication US 2023/0367670 A1, Nov. 16, 2023
Int. Cl. G06F 16/00 (2019.01); G06F 11/07 (2006.01); G06F 11/34 (2006.01); G06F 16/2453 (2019.01)
CPC G06F 11/0793 (2013.01) [G06F 11/0775 (2013.01); G06F 11/3409 (2013.01); G06F 16/24539 (2019.01)] 20 Claims
OG exemplary drawing
 
1. A database management method comprising:
obtaining statistical data by querying a first view associated with first database resources in a database,
wherein the first view is used to collect statistics on usage data of the first database resources,
wherein the first view comprises one or a combination of the following features: a quantity of query times of a first lock in the database, block sleep time of the first lock, a quantity of failures in obtaining the first lock, and a quantity of successes in obtaining the first lock,
wherein the first lock is one type of lock in the database, and
wherein the statistical data is usage data of the first database resources that is obtained through statistical collection;
extracting a first usage feature of the first database resources from the statistical data;
inputting the first usage feature into a competition evaluation model to obtain an evaluation result,
wherein the competition evaluation model is obtained through training based on a second usage feature of the first database resources; and
outputting competition alarm information when the evaluation result indicates that a second database resource is an abnormal resource,
wherein the competition alarm information indicates that a competitive bottleneck occurs in the second database resource, and
wherein the second database resource is some or all of the first database resources.