Lesson card · Data from zero
What a database system does
- You check the rules
- Edits can clash
- Crash = lost work
- Rules enforced
- Safe concurrent edits
- Recovers after a crash
You could keep data in files, but then you must stop bad data, handle two people editing at once, and survive crashes yourself.
A database management system (DBMS) does that work: it checks rules, runs many requests safely at once, and recovers after a crash.
Relational databases store tables you query with SQL. Document stores keep JSON-like records. Key-value stores look up one value by its key, very fast.
New words DBMS: database management system: software that stores data and enforces its rules
New words document store: a database that keeps whole JSON-like records
New words key-value store: a database that fetches one value by its key
New words lookup: finding one item directly by its key