Invention Grant
- Patent Title: Efficient job writing for database member
-
Application No.: US17654110Application Date: 2022-03-09
-
Publication No.: US11874830B2Publication Date: 2024-01-16
- Inventor: Sheng Yan Sun , Hong Mei Zhang , Meng Wan , Peng Hui Jiang
- Applicant: International Business Machines Corporation
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agent Gavin Giraud
- Main IPC: G06F16/2453
- IPC: G06F16/2453 ; G06F16/242 ; G06F11/34 ; G06F16/23

Abstract:
In a computer-implemented method for improving performance of a database, a processor receives batch jobs for a relational database. The batch jobs may include a first member with a first buffer pool, and a second member with a second buffer pool. The processor may also identify a first actual object and an isolation level for the batch jobs, generate related queries based on the first actual object and the isolation level, calculate a cost for the first member and the second member to run the batch jobs based on the related queries, and assign the batch jobs to the first member based on a lower calculated cost.
Public/Granted literature
- US20230289342A1 EFFICIENT JOB WRITING FOR DATABASE MEMBER Public/Granted day:2023-09-14
Information query