storage engine
The part of a database that actually stores records on disk and reads them back.
In more detail
Every storage engine adds overhead per row for bookkeeping and alignment, which the course rounds to about a third. Different engines trade read speed, write speed and space differently.
Related terms
- log structured storage engine — A storage engine that appends every write to sequential files and later merges and rewrites them in the background.
- buffer pool — Memory a database uses to keep recently read disk pages, so it does not reread them from disk.
- database — A program that stores data in an organised way and answers questions about it, such as PostgreSQL.
Taught in
- Back Of The Envelope Estimation: Storage And Bandwidth — Scalable System Design & Distributed Architecture