Question
Clearly sourced
Expert knowledge for digital decisions
What is a Database – Explained Simply?
Short answer
A database stores data in a structured way and ensures that many people can work with it simultaneously without overwriting each other. This is the key difference from a file: An Excel spreadsheet can only be effectively edited by one person at a time, while a database can handle hundreds.
What a Database Provides
- Simultaneous Access. Multiple people can work without interfering with each other.
- Consistency. A change either goes through completely or not at all. No partially booked transactions.
- Structure. A date is a date, not text that looks like a date.
- Searching in Large Volumes. Even with millions of records in fractions of a second.
- Permissions. Who can see and change 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 varies significantly from record to record.
For business software, relational is almost always the right choice. An invoice always has an amount – the fact that the database enforces this is an advantage, not a hindrance.
Why This is Relevant to You
Because it determines whether your data belongs to you. A database can be backed up, exported, and moved to another server. This is the difference between "our data" and "our data is stored somewhere."
Key facts
- Core Advantage
- Many people can work simultaneously without overwriting each other
- For Business Software
- Relational database is almost always the right choice