Databases
What Is a Database?
A database is an organized store of data, managed by software called a DBMS that lets many users save, query and update it safely.
Definition
A database is a structured collection of data stored so it can be searched and updated quickly. The software that runs it, such as MySQL, PostgreSQL or MongoDB, is a database management system (DBMS).
Relational databases store data in tables with rows and columns and are queried with SQL. NoSQL databases store documents, key-value pairs or graphs instead.
How it works
The DBMS handles storage, indexing, permissions and many users at once. Transactions group several changes so they all succeed or all fail together, which keeps the data consistent.
Indexes work like the index of a book: they let the database find matching rows without scanning the whole table.