Buffer pool extension for database server
AssigneeMicrosoft Corporation
InventorsChengliang Zhang, Sadashivan Krishnamurthy, Georgiy I. Reynya, Alexandre Verbitski, Pedro Celis, Dexter Paul Bradshaw
Life of this patent
Estimating the term…
Loading patent…
AssigneeMicrosoft Corporation
InventorsChengliang Zhang, Sadashivan Krishnamurthy, Georgiy I. Reynya, Alexandre Verbitski, Pedro Celis, Dexter Paul Bradshaw
Estimating the term…
Aspects of the subject matter described herein relate to a buffer pool for a database system. In aspects, secondary memory such as solid state storage is used to extend the buffer pool of a database system. Thresholds such as hot, warm, and cold for classifying pages based on access history of the pages may be determined via a sampling algorithm. When a database system needs to free space in a buffer pool in main memory, a page may be evicted to the buffer pool in secondary memory or other storage based on how the page is classified and conditions of the secondary memory or other storage.
A method, implemented at a computer system that includes one or more processors, a first memory, a second memory that is slower than the first memory, and a third memory that is slower than the second memory, for associating pages of a buffer pool with different memories, the method comprising:
A computer system, comprising:
A computer program product comprising one or more hardware storage devices having stored thereon computer-executable instruction that, when executed by one or more processors of a computer system, cause the computer system to associate pages of a buffer pool with different memories, the method comprising:
Dependencies are inferred from the claim text.