US 11,966,338 B2
Prefetching management in database system based on number of pages being prefetched
Sheng Yan Sun, Beijing (CN); Xiaobo Wang, Beijing (CN); Shuo Li, Beijing (CN); and Chun Lei Xu, Xian (CN)
Assigned to International Business Machines Corporation, Armonk, NY (US)
Filed by INTERNATIONAL BUSINESS MACHINES CORPORATION, Armonk, NY (US)
Filed on Jul. 19, 2022, as Appl. No. 17/813,339.
Prior Publication US 2024/0028515 A1, Jan. 25, 2024
Int. Cl. G06F 12/0862 (2016.01)
CPC G06F 12/0862 (2013.01) [G06F 2212/602 (2013.01); G06F 2212/6026 (2013.01)] 15 Claims
OG exemplary drawing
 
1. A computer-implemented method, comprising:
obtaining, by one or more processing units, shared information associated with page access, wherein the shared information associated with the page access includes information associated with the page access from a plurality of computing nodes, and wherein the information associated with the page access i) is recorded by each of the plurality of computing nodes and ii) written into a global page list periodically and in response to a change, in relation to a predetermined page range, in the information associated with the page access;
determining, by the one or more processing units, whether to prefetch a number of pages into a global buffer pool based at least on the shared information associated with the page access, wherein the shared information associated with the page access indicates whether the number of pages are accessed in a near sequential fashion;
in response to determining that the number of pages are not accessed in the near sequential fashion, reducing the number of pages that can be prefetched at one time; and
in response to determining that the reduced number of pages being prefetched becomes lower than a predefined value, turning off prefetching.