CSE Roadmap

Common tier · about 2 hours · 4 parts

Part 1 of 4 · 1 min read

Why this page comes first

In this module you will

  • Name the two main kinds of persistent storage media a database runs on.
  • Explain why random access is slower than sequential access on a magnetic disk.
  • Explain why that gap mostly disappears on an SSD.
  • Connect this physical difference to why database storage is organized in fixed-size blocks.

This level is about what is actually underneath a table on disk. Before any of that structure makes sense, the physical medium it sits on needs a plain, honest picture, since the medium's own limits shaped nearly every design decision that follows.