Invention Grant
- Patent Title: Randomized page weights for optimizing buffer pool page reuse
- Patent Title (中): 用于优化缓冲池页面重用的随机页面权重
-
Application No.: US13560700Application Date: 2012-07-27
-
Publication No.: US08880806B2Publication Date: 2014-11-04
- Inventor: Sam S. Lightstone , Adam J. Storm
- Applicant: Sam S. Lightstone , Adam J. Storm
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agency: Shumaker & Sieffert, P.A.
- Main IPC: G06F12/00
- IPC: G06F12/00

Abstract:
In general, the disclosure is directed to techniques for choosing which pages to evict from the buffer pool to make room for caching additional pages in the context of a database table scan. A buffer pool is maintained in memory. A fraction of pages of a table to persist in the buffer pool are determined. A random number is generated as a decimal value of 0 to 1 for each page of the table cached in the buffer pool. If the random number generated for a page is less than the fraction, the page is persisted in the buffer pool. If the random number generated for a page is greater than the fraction, the page is included as a candidate for eviction from the buffer pool.
Public/Granted literature
- US20140032851A1 RANDOMIZED PAGE WEIGHTS FOR OPTIMIZING BUFFER POOL PAGE REUSE Public/Granted day:2014-01-30
Information query