Question
Clearly sourced
Expert knowledge for digital decisions
What is a database – simply explained?
Short answer
A database stores data in a structured way and enables multiple people to work with it simultaneously without overwriting each other. This is the key difference to a file: An Excel table can only be meaningfully edited by one person at a time, while a database can be used by hundreds.
What a database does
- Simultaneous access. Multiple people can work without interfering with each other.
- Consistency. Either a change is fully applied or not at all. No partially recorded transaction.
- Structure. A date is a date, not text that looks like a date.
- Searching in large volumes. Even with millions of data records in fractions of a second.
- Permissions. Who is allowed to view and modify what.
Relational or document-oriented
Relational (MySQL, PostgreSQL) – Data in tables with fixed columns and relationships between them. The standard for business applications because it enforces consistency.
Document-oriented (MongoDB) – Data as flexible documents. Useful when the structure of each data record varies significantly.
For business software, relational is almost always the right choice. An invoice always has an amount – enforcing this in the database is an advantage, not a hindrance.
Why this is relevant for you
Because it determines whether your data belongs to you. A database can be backed up, exported, and migrated to another server. This is the difference between "our data" and "our data is somewhere out there".
Key facts
- Core Advantage
- Many people can work simultaneously without overwriting each other
- For Business Software
- Relational database is almost always the right choice
Sources
All external claims are backed by traceable sources.- 01