What is a Database Management System (DBMS)?
Database Management Systems (DBMS)
A DBMS is the foundational software suite that manages database storage, transaction execution, data integrity, and multi-user access.
Taxonomy of Modern Databases
| Paradigm | Data Model | Representative Systems |
|---|---|---|
| Relational (RDBMS) | Tables, Rows, Foreign Keys | PostgreSQL, MySQL, SQL Server |
| Document | Hierarchical JSON / BSON | MongoDB, CouchDB |
| Key-Value | Key-to-value mappings | Redis, DynamoDB |
| Column-Family | Columnar wide tables | Apache Cassandra, ScyllaDB |
| Graph | Nodes, Edges, Properties | Neo4j, Amazon Neptune |