9618 · 8.2
Database Management Systems (DBMS)
A DBMS is like a highly organised librarian for a massive digital library. It doesn't just store the books (data); it manages who can access them, keeps them safe, and helps you find exactly what you need instantly.
Need to know
What you need to know
- **Data Definition Language (DDL):** This is for the architects. DDL is used to define and manage the structure of the database. You use it to create, modify, and delete tables, define columns, set data types, and establish primary and foreign keys. Think of it as creating the blueprint for your data warehouse.
- **Data Manipulation Language (DML):** This is for the day-to-day users and applications. DML is used to interact with the data stored within the tables. This includes retrieving data (querying), adding new records, deleting old ones, and updating existing information. The most common DML is SQL (Structured Query Language).
- **Data Control Language (DCL):** This is for the security administrators. DCL manages user permissions and access rights to the database. It determines who can see what data and what actions they are allowed to perform, using commands like `GRANT` (to give permissions) and `REVOKE` (to take them away).
Explanation
The Digital Librarian
- Define the database structure using Data Definition Language (DDL) to create tables and set data types, like building the shelves and sections in a library.
- Manage the data itself using Data Manipulation Language (DML) to add, delete, update, and query records, which is like adding new books or looking them up in the catalogue.
- Control user access with Data Control Language (DCL) to grant or revoke permissions, deciding who is allowed into the 'restricted section'.
- Rely on the DBMS to automatically handle complex tasks like security, backups, and allowing multiple users to access data at once without conflicts.