[prev] 29 [next]

Multiple-file Disk Manager

Most DBMSs don't use a single large file for all data.

They typically provide:

  • multiple files partitioned physically or logically
  • mapping from DB-level objects to files (e.g. via meta-data)
Precise file structure varies between individual DBMSs.

Using multiple files (one file per relation) can be easier, e.g.

  • adding a new relation
  • extending the size of a relation
  • computing page offsets within a relation