US 12,353,927 B2
Buffer pool resource allocation
Shuo Li, Beijing (CN); Xiaobo Wang, Beijing (CN); Sheng Yan Sun, Beijing (CN); and Rui Wang, Xian (CN)
Assigned to International Business Machines Corporation, Armonk, NY (US)
Filed by International Business Machines Corporation, Armonk, NY (US)
Filed on Nov. 30, 2021, as Appl. No. 17/537,669.
Prior Publication US 2023/0168952 A1, Jun. 1, 2023
Int. Cl. G06F 16/2455 (2019.01); G06F 9/50 (2006.01); G06F 9/54 (2006.01)
CPC G06F 9/544 (2013.01) [G06F 9/5016 (2013.01); G06F 9/546 (2013.01); G06F 16/24552 (2019.01)] 20 Claims
OG exemplary drawing
 
1. A computer implemented method comprising:
identifying, by one or more processors, a database comprising one or more buffer pools and a set of database objects;
adding, by one or more processors, a virtual layer between the set of database objects and the one or more buffer pools, wherein the virtual layer is configured to manage buffer pool resource utilization;
managing, by one or more processors, using the added virtual layer, buffer pool resource utilization with respect to the set of database objects, wherein the managing comprises:
defining, by one or more processors, buffer pool usage corresponding to the set of database objects;
dynamically mapping, by one or more processors, database objects to the buffer pools based, at least in part, on the defined buffer pool usage;
analyzing, by one or more processors, queues to identify updated buffer pool usage corresponding to pending or queued buffer pool requests; and
adjusting, by one or more processors, database object allocation according to the identified updated buffer pool usage,
wherein the adjusting the database object allocation according to the identified updated buffer pool usage comprises reconfiguring the buffer pool resource utilization by moving at least one small data object below a data threshold to a different resource within the one or more buffer pools in response to no resources of the one or more buffer pools having enough space to accommodate a large data object above the data threshold.