US 11,748,352 B2
Dynamical database system resource balance
Shuo Li, Beijing (CN); Xiaobo Wang, Beijing (CN); Meng Wan, Beijing (CN); and Sheng Yan Sun, Beijing (CN)
Assigned to International Business Machines Corporation, Armonk, NY (US)
Filed by International Business Machines Corporation, Armonk, NY (US)
Filed on Aug. 26, 2021, as Appl. No. 17/412,389.
Prior Publication US 2023/0065855 A1, Mar. 2, 2023
Int. Cl. G06F 16/00 (2019.01); G06F 16/2453 (2019.01); G06F 11/34 (2006.01); G06F 16/22 (2019.01); G06N 20/00 (2019.01); G06F 18/214 (2023.01); G06F 16/242 (2019.01); G06F 16/24 (2019.01)
CPC G06F 16/24549 (2019.01) [G06F 11/3433 (2013.01); G06F 16/2228 (2019.01); G06F 16/24 (2019.01); G06F 16/2423 (2019.01); G06F 16/2445 (2019.01); G06F 18/214 (2023.01); G06N 20/00 (2019.01)] 14 Claims
OG exemplary drawing
 
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.