Invention Grant
US08880806B2 Randomized page weights for optimizing buffer pool page reuse 有权
用于优化缓冲池页面重用的随机页面权重

Randomized page weights for optimizing buffer pool page reuse
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
Information query
Patent Agency Ranking
0/0