System and method for relocating pages pinned in a buffer pool of a database system
US7007146B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Apr 22, 2003 |
| Grant date | Feb 28, 2006 |
| Priority date | — |
| Expiry date | May 13, 2024 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F12/126
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A system and associated method are provided for directing a database management system, to relocate buffer pages that are pinned in a buffer pool of a data processing system. Each of the buffer pages has a respective page descriptor for indicating the location of the buffer page in the buffer pool. Once the pages are relocated, the now free system memory of the buffer pool is resized. Prior to resizing, a selected pinned page is latched by an agent of the system, wherein the selected page of the buffer pages is in a resize region of the buffer pool. The pinned and latched page becomes a fixed page. The agent for the database management system determines a suitable relocation region of the buffer pool for the fixed page. A resizer module copies the contents of the fixed page to the relocation region and changes the respective page descriptor to indicate the relocation region. The resizer module performs the relocation of other pages in the resize region to allow dynamic resizing of the buffer pool while maintaining the presence of pinned versions of the pages in the buffer pool prior to resizing.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.