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.

MAIN MEMORY

DISK

disk page

free frame

Page Requests from Higher Levels

BUFFER POOL

choice of frame dictated

by replacement policy

Previous slide

Next slide

Back to first slide

View graphic version