DBMS

Stands for "Database Management System."

A DBMS is a software program that creates and runs a database. It creates a framework that can store, organize, retrieve, and manipulate the contents of a database in a structured manner. It also provides an interface for users and applications to access a database's contents using a standardized query language like SQL.

DBMS software also provides tools for database administrators to manage their databases. First, it provides a way for administrators to design a database by creating schemas, defining tables, and creating relationships. It helps administrators configure the database's user accounts, including permissions levels for each one. Administrators can specify which users can access data and which can add or modify database records; they may even choose to keep some data private and only accessible by specific accounts. A DBMS also helps administrators automate database backups and then restore from those backups when necessary. It can even monitor database performance, like how long each query takes.

Many types of DBMS are available, with some popular options including MySQL, Microsoft Access, Oracle Database, and MongoDB. Even though most databases use one of several standard query languages, with SQL being the most common, each DBMS has a unique feature set and implements those features using custom query commands. Since databases often need to communicate with each other, most database management systems include an Open Database Connectivity (ODBC) driver that converts proprietary syntax into a dialect that other databases can understand.

Updated August 15, 2023 by Brian P.

quizTest Your Knowledge

Which of these is not a permissions operation in Unix, Linux, and macOS?

A
Read
0%
B
Write
0%
C
Delete
0%
D
Execute
0%
Correct! Incorrect!     View the Permissions definition.
More Quizzes →

The Tech Terms Computer Dictionary

The definition of DBMS on this page is an original definition written by the TechTerms.com team. If you would like to reference this page or cite this definition, please use the green citation links above.

The goal of TechTerms.com is to explain computer terminology in a way that is easy to understand. We strive for simplicity and accuracy with every definition we publish. If you have feedback about this definition or would like to suggest a new technical term, please contact us.

Sign up for the free TechTerms Newsletter

How often would you like to receive an email?

You can unsubscribe or change your frequency setting at any time using the links available in each email.

Questions? Please contact us.