Invention Grant
- Patent Title: Method for range operation data management statement
-
Application No.: US17305790Application Date: 2021-07-14
-
Publication No.: US11645259B2Publication Date: 2023-05-09
- Inventor: Xiaobo Wang , Shuo Li , Sheng Yan Sun , Hong Mei Zhang
- 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
- Agency: Yee & Associates, P.C.
- Main IPC: G06F16/22
- IPC: G06F16/22 ; G06F16/23

Abstract:
Processing range operation data management statements in a database is provided. The method comprises receiving statements for range operations that specify referenced pages in the database. The range operations are stored in a search structure in a table directory in the database and applied to any referenced pages in a memory buffer pool. Application of the range operations is postponed for any referenced pages not in the memory buffer pool. The database determines if reading the postponed pages into the buffer pool would exceed a specified input/output threshold. If reading the postponed pages into the buffer pool does not exceed the specified threshold, the database reads the postponed pages from disk to the buffer pool asynchronously in parallel, and the range operations are then applied to the postponed pages. Pages modified by the range operations are then written from the buffer pool back to disk.
Public/Granted literature
- US20230016163A1 Method for Range Operation Data Management Statement Public/Granted day:2023-01-19
Information query