Skip to content

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

bash
# Start the PostgreSQL DBMS server
pg_ctl start

# Connect to it with the psql client
psql -U postgres -d mydb

PostgreSQL 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.

View errors

← Back to glossary