Database resource management using predictive models

Patent metadata

Field	Value
Publication number	US-12468981-B2
Application number	US-202117557303-A
Country	US
Kind code	B2
Filing date	Dec 21, 2021
Priority date	Dec 21, 2021
Publication date	Nov 11, 2025
Grant date	Nov 11, 2025

Abstract

Systems and methods are provided to predict connection configurations in a distributed database environment. In embodiments, a method includes: building, by a computing device, a dynamic machine learning predictive model for a first new node connection in a distributed database environment based on configuration data of the first new node connection; determining, by the computing device, a group of nodes in the distributed database environment of a same type of node as the new node connection; federating, by the computing device, the dynamic machine learning predictive model of the first new node connection with other dynamic machine learning predictive models of other nodes in the group of nodes, thereby generating a federated predictive model for the same type of node; and generating, by the computing device, a predicted connection configuration for a second new node connection of the same type of node using the federated predictive model.

First claim

What is claimed is:

1 . A method, comprising:
building, by a computing device, a dynamic machine learning predictive model for a first new node connection in a distributed database environment based on configuration data of the first new node connection; determining, by the computing device, a group of nodes in the distributed database environment of a same type of node as the first new node connection; federating, by the computing device, the dynamic machine learning predictive model of the first new node connection with other dynamic machine learning predictive models of other nodes in the group of nodes, thereby generating a federated predictive model for the type of node; and generating, by the computing device, a predicted connection configuration for a second new node connection of the same type of node using the federated predictive model, the predicted connection configuration including information on connection status and thread usage.

2 . The method of claim 1 , further comprising identifying, by the computing device, the first new node connection within the distributed database environment.

3 . The method of claim 1 , further comprising identifying, by the computing device, a connection request has been issued for the second new node connection.

4 . The method of claim 1 , further comprising calculating and scheduling, by the computing device, resource usage for the second new node connection based on the predicted connection configuration for the second new node connection.

5 . The method of claim 4 , wherein the scheduling the resource usage for the second new node connection comprises scheduling thread usage.

6 . The method of claim 1 , wherein the building the dynamic machine learning predictive model comprises:
determining a connection type based on the connection configuration data; determining connection parameters based on the connection configuration data; obtaining real-time statistic data regarding the first new node connection; determine performance indicators that affect the first new node connection based on the statistics data and rules; performing machine learning classification of the performance indicators with real-time performance indicator labels; and generating the dynamic machine learning predictive model by mapping active usage and inactive usage of connection parameters to the real-time performance indicator labels.

7 . The method of claim 1 , wherein the performance indicators are selected from one or more of the group consisting of: table cardinality; page number; access frequency; index level; leaf page; Input/Output speed; and system cache.

8 . The method of claim 1 , wherein the computing device includes software provided as a service in a cloud environment.

9 . A computer program product comprising one or more computer readable storage media having program instructions collectively stored on the one or more computer readable storage media, the program instructions executable to:
build a self-organized centerless network of nodes in a distributed database environment, the self-organized centerless networks of nodes including a group of nodes of a same type of node; build a dynamic machine learning predictive model for a first new node connection of a first new node in the distributed database environment based on configuration data of the first new node connection, wherein the first new node is of the same type of node as the group of nodes; federate the dynamic machine learning predictive model of the first new node connection with other dynamic machine learning predictive models of other nodes in the group of nodes, thereby generating a federated predictive model for the same type of node; and generate a predicted connection configuration for a second new node connection of a second new node of the same type of node using the federated predictive model, the predicted connection configuration including information on connection status and thread usage.

10 . The computer program product of claim 9 , wherein the program instructions are further executable to identify the first new node connection within the distributed database environment.

11 . The computer program product of claim 9 , wherein the program instructions are further executable to identify a connection request has been issued for the second new node connection.

12 . The computer program product of claim 9 , wherein the program instructions are further executable to calculate and schedule resource usage for the second new node connection based on the predicted connection configuration for the second new node connection.

13 . The computer program product of claim 12 , wherein the scheduling the resource usage for the second new node connection comprises scheduling thread usage.

14 . The computer program product of claim 9 , wherein the building the dynamic machine learning predictive model comprises:
determining a connection type based on the connection configuration data; determining connection parameters based on the connection configuration data; obtaining real-time statistic data regarding the first new node connection; determine performance indicators that affect the first new node connection based on the statistics data and rules; performing machine learning classification of the performance indicators with real-time performance indicator labels; and generating the dynamic machine learning predictive model by mapping active usage and inactive usage of connection parameters to the real-time performance indicator labels.

15 . The computer program product of claim 9 , wherein the performance indicators are selected from one or more of the group consisting of: table cardinality; page number; access frequency; index level; leaf page; Input/Output speed; and system cache.

16 . A system comprising:
a processor, one or more computer readable storage media, and program instructions collectively stored on the one or more computer readable storage media, the program instructions executable to: build a dynamic machine learning predictive model for a first new node connection in a distributed database environment based on configuration data of the first new node connection; determine a group of nodes in the distributed database environment of a same type of node as the new node connection; federate the dynamic machine learning predictive model of the first new node connection with other dynamic machine learning predictive models of other nodes in the group of nodes, thereby generating a federated predictive model for the same type of node; generate a predicted connection configuration for a second new node connection of the same type of node using the federated predictive model, the predicted connection configuration including information on connection status and thread usage; and schedule resource usage for the second new node connection based on the predicted connection configuration for the second new node connection.

17 . The system of claim 16 , wherein the program instructions are further executable to: identify the first new node connection within the distributed database environment; and identify a connection request has been issued for the second new node connection.

18 . The system of claim 16 , wherein the scheduling the resource usage for the second new node connection comprises scheduling thread usage.

19 . The system of claim 16 , wherein the building the dynamic machine learning predictive model comprises:
determining a connection type based on the connection configurati

Assignees

• IBM

Inventors

• Zhang Hong Mei
• Li Shuo
• Wang Xiaobo
• Sun sheng yan

Classifications

• G06F16/27

  Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor · CPC title

• G06F16/256 Primary

  in federated or virtual databases · CPC title

• G06F9/4881

  Scheduling strategies for dispatcher, e.g. round robin, multi-level priority queues · CPC title

• G06N20/00 Primary

  Machine learning · CPC title

• H04L67/60

  Scheduling or organising the servicing of application requests, e.g. requests for application data transmissions using the analysis and optimisation of the required network resources (admission control or resource allocation H04L47/70) · CPC title