Database management systems notes

How Rows Are Stored

Pages, heap files, and the row layout underneath every table you have written. Every section is a drawn page beside a clear written explanation, about 20 minutes in all.

  • Chapter 17 of 34
  • About 20 minutes
  • 7 sections

Sign in with Google or GitHub and you land straight on this page. DSA comes with the all labs plan and every ChaiCode batch.

The first drawn page of How Rows Are Stored: The page is the unit of everything
The chapter's first page: The page is the unit of everything

In this chapter

  • The page is the unit of everything
  • Inside a page: the slotted layout
  • How one row is laid out
  • Values too big for a page
  • The heap: unordered by design
  • What an UPDATE actually does
  • Row stores and column stores

Next chapters

Read the whole chapter

Sign in and the chapter opens with every drawn page, and all 35 database management systems chapters beside it.

DSA comes with the all labs plan and every ChaiCode batch.