DBMS
In one line
A DBMS (Database Management System) is the software that creates, reads, updates, and manages a database.
In simple words
The DBMS is the program that sits between your application and the raw data on disk. When you write a query, the DBMS parses it, figures out the most efficient way to execute it, reads the data, and returns the result. PostgreSQL, MySQL, SQLite, MongoDB, and Redis are all DBMSs.
People often say "I use PostgreSQL" when they really mean "I use the PostgreSQL DBMS to manage my database." The database is the data; the DBMS is the software that manages it.
A good DBMS handles concurrency (many users at once), security (who can read what), integrity (enforcing rules), and recovery (surviving crashes).
Example
# Start the PostgreSQL DBMS server
pg_ctl start
# Connect to it with the psql client
psql -U postgres -d mydbPostgreSQL is a DBMS — you start the server process, then connect with a client to run queries.
Common confusions
Confused with: database
The difference: The database is the data itself; the DBMS is the software that manages that data. One DBMS can manage many databases.
Related terms
Related Resources
Related Lessons
- Database Overview
Learn the difference between a database, a DBMS, and a query language.
Decode error messages
Plain-English explanations of common errors — what they mean, why they happen, and how to fix them.