[prev] 52 [next]

Buffer Pool

Aim of DBMS buffer pool:
  • reduce number of disk reads and disk writes
Assumption:
  • some pages are accessed many times during query evaln
Achieves read/write reduction by:
  • holding many pages in memory for re-use
  • only removing them when "absolutely necessary"
  • sharing pages among multiple transactions (global pool)