Data and Databases

Database Management Systems

Learning Objectives

  • You can describe what a DBMS is and what high-level components it contains.
  • You can explain the idea of data independence at a high level.
  • You can recognize that authorization and auditing are also part of responsible database system operation.

A database is the stored data itself. A database management system, or DBMS, is the software that helps applications and users store, retrieve, update, protect, and manage that data.

Although in every day language “database” and “DBMS” are often used interchangeably, it is useful to keep the distinction clear. The database is the remembered data, while the DBMS is the system that manages it. Students often blur these together at first, but later chapters become easier when the distinction is clear.

Loading Exercise...

A Simplified View of a DBMS

A real DBMS is a large system, but even a simplified mental model is helpful.

Figure 1 — A simplified DBMS view showing that requests, transactions, storage, recovery, and protection are all parts of the same system.

This picture is intentionally simplified. The exact internal architecture differs from system to system. Still, it already helps to understand that a DBMS is more than just a folder full of files, and that it brings several responsibilities together in one trusted place:

  • Request handling receives requests from applications and users and passes them to the right parts of the system.

  • Query processing turns a request into actual work on stored data.

  • Transaction management helps the DBMS keep multi-step operations consistent.

  • Storage management deals with how data is stored and accessed.

  • Recovery support helps the DBMS return to a trustworthy state after crashes or partial failures.

  • Authorization controls who may do what. In real systems, not every user or service should be able to read or change every table.

  • Auditing helps answer questions such as who changed data and when. In simple terms, authorization is about permission beforehand, while auditing is about traceability afterward.

If every application had to build all of that from scratch on top of plain files, the result would usually be fragile and inconsistent.

Loading Exercise...

Three Views of Data

A good DBMS gives us abstraction layers. An application or user should not need to know every detail of how bytes are arranged on disk.

A common simplified way to talk about this is through three levels:

  • External view: what a user or application sees
  • Conceptual view: the logical database structure
  • Internal view: how data is actually stored
Figure 2 — A common simplified view of data abstraction: user-facing views sit above logical structure, which sits above internal storage details.
Loading Exercise...

Data Independence

This separation supports data independence. In simple terms, it means that some changes at one level do not force changes everywhere else.

For example, an application page that lists courses should not have to change just because the DBMS changes how it organizes data internally.

Likewise, a table might gain a new column without forcing every existing page to change immediately. The application still sees a stable logical structure, even if the internal storage details change under the hood.

That separation is one reason databases scale better conceptually than ad hoc file handling. The logical model can stay understandable even when the physical storage becomes much more sophisticated.

Data independence is also partly an architectural choice. If a system mixes application logic too closely with storage details, later changes may become much harder.

Loading Exercise...

Check Your Understanding

  1. What is the difference between the stored data itself and the DBMS that manages it?
  2. Name three DBMS responsibilities beyond “storing rows.”
  3. Why are authorization and auditing useful in a system that stores important data?

AI Study Aid

Create a chapter diagram

We're looking into to what extent AI-generated diagrams could help with studying.

Use this study aid to generate an AI-generated visual summary of the material you just studied. Each diagram style emphasizes the content in a different way, so you can choose the focus that feels most useful.

Using the diagram generator is voluntary and does not affect your course progress. We encourage you to try it out and see if it helps, but it's totally up to you! Your answers help us understand how to make better study aids in the future.

Diagrams tried: 0

Selected style: choose a diagram style
← From Files to Databases
The Relational Model →