A database management system (DBMS) is software that controls the storage, organization, and retrieval of data. It is the software layer that users and applications use to create, query, change, and administer a database. The definition below follows Oracle’s database concepts documentation, which states it in these terms, and matches the functional descriptions in OpenStax’s database course material and MongoDB’s documentation.
The definition in Oracle’s words
Oracle’s Introduction to Oracle Database concepts documentation defines the term in one sentence: “A database management system (DBMS) is software that controls the storage, organization, and retrieval of data.” That sentence is the anchor for the rest of this article. The National Institute of Standards and Technology (NIST) glossary also lists DBMS as the abbreviation for Database Management System, so the acronym and the full term can be used interchangeably.
| # | Preview | Product | Price | |
|---|---|---|---|---|
| 1 |
|
Concepts of Database Management (MindTap Course List) | $69.76 | Buy on Amazon |
| 2 |
|
Concepts of Database Management | $44.41 | Buy on Amazon |
| 3 |
|
Database Systems: The Complete Book | $184.50 | Buy on Amazon |
| 4 |
|
Database Management Systems | $432.87 | Buy on Amazon |
| 5 |
|
Database Systems: Design, Implementation, & Management (MindTap Course List) | $96.21 | Buy on Amazon |
As an Amazon Associate I earn from qualifying purchases.
Database, DBMS, and database system: three different things
Much of the confusion around this term comes from the word “database” being used for two different things. In precise usage, the three terms are separate:
Quick wins for a faster PC:
Clear out junk files and repair common Windows errorsFree Scan →Fix the driver behind crashes, sound loss and screen glitchesFind Drivers →- Database: the organized collection of data itself.
- DBMS: the software that manages that collection and mediates every access to it.
- Database system: the data, the DBMS, and the applications that work with them, taken together.
When someone says “our database is down,” they usually mean the database system. When a vendor sells a “database,” they usually mean the DBMS. Keeping the data and the managing software apart makes it easier to reason about backups, licensing, and performance, because each lives in a different layer.
#1 Best Overall
What a DBMS does
A DBMS is more than a container for files. It provides a managed way to define the structure of data and to work with it. Depending on the product, a DBMS typically does the following:
- Stores and organizes data, including metadata that describes the structure of the data.
- Lets users and applications query, insert, update, and delete data through a defined language or interface.
- Enforces integrity rules and supports consistent handling of data.
- Controls access and supports multiple concurrent users.
- Supports backup and recovery. The exact tools and behavior differ from product to product.
Oracle describes three typical DBMS elements: kernel code that does the core work, a metadata repository often called a data dictionary, and a query language. OpenStax’s discussion covers integrity, consistency, data independence, security, concurrent access, and backup and recovery. Not every DBMS implements each of these features in the same way, so a feature list should be checked against the specific product’s documentation before it is relied on.
Rank #2
Types of DBMS
The most common distinction is by data model. An RDBMS (relational database management system) is a relational type of DBMS. It stores data in tables made of rows and columns, and SQL is the common language used to query and modify that data. Other DBMS approaches are non-relational, and Amazon Web Services (AWS) groups them into key-value, document, and graph categories.
| Category | How data is organized | Typical use |
|---|---|---|
| Relational (RDBMS) | Tables with rows and columns, linked by relationships | Structured records with defined relationships |
| Key-value | Each item is retrieved by a unique key | Simple, fast lookups of individual items |
| Document | Semi-structured records stored as documents | Data whose shape varies between records |
| Graph | Nodes connected by edges | Data where the connections between items are central |
These categories can overlap, since some products support more than one model. Do not use “DBMS” and “RDBMS” as synonyms: every RDBMS is a DBMS, but not every DBMS is relational.
Rank #3
Choosing among DBMS types
The choice between types is a set of trade-offs rather than a ranking. AWS’s guidance on database types points to these factors:
- Data structure and the relationships between records
- Expected workload and performance requirements
- Scalability needs
- Cost
- Integration requirements with existing applications
- Staff expertise
- Security needs
Examples of DBMS software
Oracle’s overview names MySQL, Microsoft Access, Microsoft SQL Server, FileMaker Pro, Oracle Database, and dBASE as examples of database software. Oracle’s technical documentation identifies Oracle Database specifically as an RDBMS. These examples illustrate the categories, and they are not a current ranking of products; the market changes, and a product’s suitability depends on the factors listed above.
Rank #4
Key points to remember
- A DBMS is software. The database is the managed collection of data.
- Its core role is controlling how data is stored, organized, and retrieved.
- It gives users and applications ways to query and change data, and the management features vary by system.
- RDBMS is one category of DBMS, based on the relational model. Other models exist.
- Choosing a system depends on the data, the workload, and operational constraints.
For a deeper treatment of how these systems are designed and taught, OpenStax’s database management systems textbook is a suitable next step for readers who want more than a definition.
What’s actually slowing this PC down?
Pick the symptom - the matching free tool is one click away.
Quick Recap
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
