dbms-files

how is database stored on disk?

tags: learning database

content

• database is stored as files on disks (erm. duh.)

• some DBMS break down database (referring to the content) into multiple files

• some has only one single file (e.g., SQLite)

• OS does NOT understand these files created by DBMS

  • OS does not know how to decipher the content, to it it’s just raw data bytes

• files are broken down into database pages.

up

down

reference

• 15-445/645 Database Systems (Spring 2025) - Lecture Notes - 03 Database Storage (Part I)