Dynamical database system resource balance

Patent metadata

Field	Value
Publication number	US-11748352-B2
Application number	US-202117412389-A
Country	US
Kind code	B2
Filing date	Aug 26, 2021
Priority date	Aug 26, 2021
Publication date	Sep 5, 2023
Grant date	Sep 5, 2023

Abstract

An approach is provided in which the approach segments each one of multiple components corresponding to multiple component levels in an SQL database system into multiple functions. The approach combines a first one of the multiple functions with a second one of the multiple functions into an image, and invokes the image to process an SQL query using the first function and the second function.

First claim

The invention claimed is:

1. A computer-implemented method comprising:
segmenting, by a component divider of a database system resource balancer, each one of a plurality of database components in an SQL database system into a plurality of database functions capable of processing an SQL query, wherein each one of the plurality of database components corresponds to one of a plurality of component levels in the SQL database system;
analyzing, by a machine learning module, one or more workload patterns corresponding to one or more historical SQL queries, wherein the analyzing comprises:
identifying a first set of the plurality of database functions segmented from a first one of the plurality of database components corresponding to a first one of the plurality of component levels;
selecting a first database function from the first set of database functions;
identifying a second set of the plurality of database functions segmented from a second one of the plurality of database components corresponding to a second one of the plurality of component levels; and
selecting a second database function from the second set of functions;

in response to the analyzing, combining, into a first image, the first database function and the second database function, wherein the combining is performed by an image construction module of the database system resource balancer; and
invoking the first image to process the SQL query, wherein the invoking comprises asynchronously loading the first database function and the second database function without loading the first database component and the second database component and independently using the first database function and the second database function to process the SQL query.

2. The method of claim 1 further comprising:
creating a different image from a third one of the plurality of database functions;
combining the first image with the different image to generate a bundled image; and
invoking the bundled image to process the SQL query using the first database function, the second database function, and the third database function.

3. The method of claim 2 further comprising:
in further response to analyzing the set of workload patterns corresponding to the one or more historical SQL queries:
creating the bundled image that comprises the first image and the different image; and
creating a different bundled image that comprises a third image and a fourth image, wherein the third image comprises at least one of the plurality of database functions and the fourth image comprises at least one of the plurality of database functions.

4. The method of claim 1 further comprising:
creating a Docker container instance from the first image; and
running the Docker container instance to process the SQL query.

5. The method of claim 1 wherein at least one of the plurality of database components is selected from the group consisting of a parser component, a query transformation component, an access path selection component, a runtime execution component, an index manager component, a data manager component, and a buffer manager component.

6. An information handling system comprising:
one or more processors;
a memory coupled to at least one of the processors;
a database system resource balancer, including a component divider, a machine learning module, and an image construction module;
a set of computer program instructions stored in the memory and executed by at least one of the processors in order to perform actions of:
segmenting, by the component divider, each one of a plurality of database components in an SQL database system into a plurality of database functions capable of processing an SQL query, wherein each one of the plurality of database components corresponds to one of a plurality of component levels in the SQL database system;
analyzing, by a machine learning module, one or more workload patterns corresponding to one or more historical SQL queries, wherein the analyzing comprises:
identifying a first set of the plurality of database functions segmented from a first one of the plurality of database components corresponding to a first one of the plurality of component levels;
selecting a first database function from the first set of database functions:
identifying a second set of the plurality of database functions segmented from a second one of the plurality of database components corresponding to a second one of the plurality of component levels; and
selecting a second database function from the second set of functions:

in response to the analyzing, combining, into a first image, the first database function and the second database function, wherein the combining is performed by the image construction module; and
invoking the first image to process the SQL query, wherein the invoking comprises asynchronously loading the first database function and the second database function without loading the first database component and the second database component and independently using the first database function and the second database function to process the SQL query.

7. The information handling system of claim 6 wherein the processors perform additional actions comprising:
creating a different image from a third one of the plurality of database functions;
combining the first image with the different image to generate a bundled image; and
invoking the bundled image to process the SQL query using the first database function, the second database function, and the third database function.

8. The information handling system of claim 7 wherein the processors perform additional actions comprising:
in further response to analyzing the set of workload patterns corresponding to the one or more historical SQL queries:
creating the bundled image that comprises the first image and the different image; and
creating a different bundled image that comprises a third image and a fourth image, wherein the third image comprises at least one of the plurality of database functions and the fourth image comprises at least one of the plurality of database functions.

9. The information handling system of claim 6 wherein the processors perform additional actions comprising:
creating a Docker container instance from the first image; and
running the Docker container instance to process the SQL query.

10. The information handling system of claim 6 wherein at least one of the plurality of database components is selected from the group consisting of a parser component, a query transformation component, an access path selection component, a runtime execution component, an index manager component, a data manager component, and a buffer manager component.

11. A computer program product stored in a computer readable storage medium, comprising computer program code that, when executed by an information handling system, causes the information handling system to perform actions comprising:
segmenting, by a component divider of a database system resource balancer, each one of a plurality of database components in an SQL database system into a plurality of database functions capable of processing an SQL query, wherein each one of the plurality of database components corresponds to one of a plurality of component levels in the SQL database system;
analyzing, by a machine learning module, one or more workload patterns corresponding to one or more historical SQL queries, wherein the analyzing comprises:
identifying a first set of the plurality of database functions segmented from a first one of the plurality of database components corresponding to a first one of the plurality of component levels;
selecting a first database function from the first set of datab

Assignees

• IBM

Inventors

• Li Shuo
• Wang Xiaobo
• Wan Meng
• Sun sheng yan

Classifications

• G06F16/24549 Primary

  Run-time optimisation · CPC title

• G06F11/3433

  for load management (allocation of a server based on load conditions G06F9/505; load rebalancing G06F9/5083; redistributing the load in a network by a load balancer H04L67/1029) · CPC title

• G06F16/2228

  Indexing structures · CPC title

• G06F16/24

  Querying · CPC title

• G06F16/2423

  Interactive query statement specification based on a database schema · CPC title