Overview of database management systems (DBMS), their importance in modern information systems, and the basic concepts and components involved in database management.
Introduction to Database Management Systems (DBMS)
Prepared as concise, easy‑to‑read study notes
| Term | Definition |
|---|---|
| Database | A collection of logically related data stored for retrieval, update, and management. |
| DBMS | Software that provides systematic methods to create, store, query, and maintain databases. It acts as an interface between users/application programs and the physical data. |
Key Idea: The DBMS abstracts the complexities of storage hardware, allowing users to focus on what data they need, not how it is stored.
| Function | Description | Typical SQL Commands |
|---|---|---|
| Data Definition | Define database schema (tables, indexes, constraints). | CREATE, ALTER, DROP |
| Data Manipulation | Insert, modify, delete, retrieve data. | INSERT, UPDATE, DELETE, SELECT |
| Security & Authorization | Control who can access/modify data. | GRANT, REVOKE |
| Transaction Management | Ensure atomicity, consistency, isolation, durability (ACID). | BEGIN TRANSACTION, COMMIT, ROLLBACK |
| Concurrency Control | Manage simultaneous accesses without conflicts. | Locking protocols, MVCC |
| Backup & Recovery | Protect data against loss/failure. | BACKUP, RESTORE, log-based recovery |
| Integrity Enforcement | Enforce rules that keep data correct. | Primary/foreign keys, CHECK constraints, triggers |
| Query Optimization | Choose the most efficient execution plan. | Query planner, statistics, indexes |
| Model | Characteristics | Example Use Cases |
|---|---|---|
| Hierarchical | Tree‑like structure; each child has one parent. | XML storage, IBM IMS |
| Network | Graph structure; a child can have multiple parents. | Complex bill‑of‑materials, legacy systems |
| Relational | Data organized in tables (relations); uses set theory & predicate logic. | Most modern business applications |
| Object‑Oriented | Stores objects with attributes & methods. | CAD/CAM, multimedia |
| Document / NoSQL | Stores semi‑structured data (JSON, XML). | Content management, big data pipelines |
| Key‑Value / Column‑Family | Simple key‑lookup or wide‑column stores. | Caching, time‑series data |
The relational model remains the dominant paradigm for transactional systems.
SQL (Structured Query Language) is the standard language for defining and manipulating relational data.
| Property | Meaning |
|---|---|
| Atomicity | All operations of a transaction succeed or none do (all‑or‑nothing). |
| Consistency | Transaction brings the database from one valid state to another, preserving all constraints |