Buffer Management in a DBMS
•
Data must be in RAM for DBMS to operate on it!
•
Table of <frame#, pageid> pairs is
maintained.
•
LRU is not always good.
DB
MAIN MEMORY
DISK
disk page
free frame
Page Requests from Higher Levels
BUFFER POOL
choice of frame dictated
by
replacement policy