A.2.1 DBMS and RDBMS Notes

Outline the Functions and Tools of a DBMS

1. Data dictionary: The DBMS maintains a dedicated “metadata repository” that lists every table, column, data‑type, length and relationship, so the engine always knows the exact structure it must enforce.
2. Data safety: Built‑in backup, recovery and integrity‑checking modules create consistent snapshots, ship logs and verify pages so that data can be restored accurately after hardware failures or user errors.
3. Query processor: An SQL interpreter parses each query, validates it against the schema and hands it to an optimiser that chooses the most efficient execution plan before returning the result set.
4. Storage engine: Low‑level routines handle all create, read, update and delete (CRUD) operations on disk, translating logical rows into physical pages and ensuring every change is recorded in the transaction log.
5. Concurrency control: A transaction manager applies locks, timestamps or multiversion snapshots so that many users can work simultaneously without overwriting one another, giving the illusion of a serial schedule.
6. Security services: The DBMS enforces role‑based access rights that specify who may read or write each object, records every change in an audit trail, and optionally encrypts data at rest and in transit to safeguard confidentiality.
7. Database‑administrator (DBA) tasks: The DBA designs and updates schemas, assigns user privileges and passwords, schedules backups, and drafts disaster‑recovery plans to keep the system resilient and compliant.
8. Data‑definition language (DDL): A privileged command set (part of) which allows DBAs to create, alter or drop objects, automatically updating the data dictionary with each structural change.

How a DBMS Promotes Data Security

1. Data validation:
   1. Column data‑types, length limits and CHECK constraints block out‑of‑range or ill‑formed values as they enter the database.
   2. NOT NULL, primary‑key and foreign‑key rules stop duplicates and orphan records.