US 11,874,830 B2
Efficient job writing for database member
Sheng Yan Sun, Beijing (CN); Hong Mei Zhang, Haidian District (CN); Meng Wan, Beijing (CN); and Peng Hui Jiang, Beijing (CN)
Assigned to International Business Machines Corporation, Armonk, NY (US)
Filed by International Business Machines Corporation, Armonk, NY (US)
Filed on Mar. 9, 2022, as Appl. No. 17/654,110.
Prior Publication US 2023/0289342 A1, Sep. 14, 2023
Int. Cl. G06F 16/2453 (2019.01); G06F 16/242 (2019.01); G06F 11/34 (2006.01); G06F 16/23 (2019.01)
CPC G06F 16/24542 (2019.01) [G06F 11/3409 (2013.01); G06F 16/2386 (2019.01); G06F 16/2433 (2019.01)] 20 Claims
OG exemplary drawing
 
1. A computer-implemented method for improving performance of a database, comprising:
receiving a batch job for a relational database comprising (i) a first member comprising a first buffer pool and (ii) a second member comprising a second buffer pool;
identifying a first actual object and an isolation level for the batch jobs;
generating related queries, each related query comprising a word related to but distinct from words in the batch job, wherein each related query is based on the first actual object and the isolation level;
calculating a resource cost for each of the first member and the second member to run the batch jobs based on the related queries; and
assigning the batch jobs to the first member based on a lower calculated resource cost.