CSE Roadmap

Core tier · about 2 hours · 5 parts

Part 1 of 5 · 1 min read

Why this page comes first

In this module you will

  • Explain why a database keeps its own cache of disk pages in memory.
  • Explain what a dirty page is, and why it cannot simply be discarded.
  • Describe, at a high level, how a buffer pool decides which page to evict.
  • Connect the buffer pool to why a repeated query can be far faster the second time.

Every block read in this level ultimately goes through memory first. This page covers that memory layer directly: why it exists, and the one rule that makes it more than a simple cache.