DBMS Topics
HubUnit 1 — Introduction to DBMS & Entity-Relationship ModelAdvantages and Disadvantages of DBMSAggregationCharacteristics of DBMSData IndependenceData ModelsDatabase Users and AdministratorsDBMS LanguagesER DiagramsEntity-Relationship ER ModelIntroduction to DBMSKeys in DBMSRelationships and CardinalitySchema and InstanceSpecialization and GeneralizationUnit 1 Summary — Introduction to DBMS & ER ModelThree-Level Architecture ANSI/SPARC ArchitectureWeak Entity SetUnit 2 — Relational Model & SQLConstraints in SQLCursorsDCL and TCL CommandsDDL CommandsDML CommandsDomain Relational Calculus DRCFunctions and Stored ProceduresJoins in SQLNested Queries SubqueriesRelational AlgebraRelational CalculusRelational ModelSQL IntroductionUnit 2 Summary — Relational Model & SQLTriggers in SQLTuple Relational Calculus TRCViews in SQLArmstrong's Axioms & Closure of AttributesBoyce-Codd Normal Form BCNFClosure of AttributesDependency PreservationFifth Normal Form 5NFFirst Normal Form 1NFFourth Normal Form 4NFFunctional DependencyLossless DecompositionMultivalued DependencyNormal Forms — OverviewNormalization — IntroductionSecond Normal Form 2NFUnit 3 Summary — NormalizationThird Normal Form 3NFUnit 4 — Transaction Management & Concurrency ControlACID PropertiesCheckpointsConcurrency Control & SerializabilityDeadlock in DBMSLock-Based Protocols & Two-Phase LockingLog-Based RecoveryRecovery SystemSerializabilityShadow PagingUnit 4 Summary — Transaction Management & Concurrency ControlTimestamp-Based ProtocolTransaction ManagementTransaction StatesTwo-Phase Locking 2PLUnit 5 — Storage & IndexingB+ TreeB-TreeCost EstimationDynamic HashingFile OrganizationHashing TechniquesIndexing — IntroductionMulti-Level IndexingQuery OptimizationQuery ProcessingSingle-Level IndexingStatic HashingUnit 5 Summary — Storage & IndexingUnit 6 — Advanced Topics in DBMSBig Data and DBMSCloud DatabaseData MiningData WarehouseDatabase SecurityDistributed DatabaseDistributed Query ProcessingDistributed DBMS Architecture, Fragmentation & ReplicationMongoDB — IntroductionNoSQL DatabaseReplication in Distributed DatabasesUnit 6 Summary — Advanced Topics in DBMSViva Voce — DBMSImportant Viva Questions — DBMSInterview Questions — DBMSViva Answers — DBMSDBMS Multiple Choice Questions MCQsDBMS Lab Programs
Introduction to DBMS
Last Updated : 21 May, 2026
A database is an organized collection of structured data stored electronically so that it can be easily accessed, managed, and updated. Databases store data in a way that
Unit 1480 words8 headingsTables includedExamples included
What is a Database?
A database is an organized collection of structured data stored electronically so that it can be easily accessed, managed, and updated. Databases store data in a way that enables efficient retrieval and manipulation.
Examples of databases in everyday life:
- A library catalog storing information about books
- A hospital system storing patient records
- An e-commerce platform storing products and orders
- A university storing student and course information
What is a DBMS?
A Database Management System (DBMS) is a software system that provides an interface for users and applications to interact with databases. It controls the organization, storage, management, and retrieval of data.
User / Application
SQL
Result
DBMS
Database
(Disk)
(Disk)
Popular DBMS Software:
- MySQL, PostgreSQL, MariaDB (Open Source)
- Oracle Database, Microsoft SQL Server (Commercial)
- SQLite (Embedded/Lightweight)
- MongoDB, Cassandra (NoSQL)
History of Database Systems
| Era | System | Characteristic |
|---|---|---|
| 1960s | File-based systems | Data stored in flat files |
| Late 1960s | IMS (IBM) | First hierarchical DBMS |
| 1970s | CODASYL | Network model databases |
| 1970 | E.F. Codd's paper | Relational model proposed |
| 1980s | Oracle, DB2 | Commercial relational DBMS |
| 1986 | SQL standardized | ANSI SQL standard published |
| 2000s | Open source | MySQL, PostgreSQL growth |
| 2010s | NoSQL era | MongoDB, Cassandra for big data |
| Present | NewSQL/Cloud | CockroachDB, Amazon Aurora |
File-Based System vs. DBMS
Before DBMS, data was stored in flat files managed by application programs.
Problems with File-Based Systems
Application A
Customer.txt
Redundant copy
Application B
Customer.csv
Redundant copy
Application C
Customer.dat
Redundant copy
- Data Redundancy: Same data stored in multiple files → wastes space and causes inconsistency.
- Data Inconsistency: Updating one file doesn't update others.
- Difficult Data Access: No standard query language — programs must be written for each query.
- Data Isolation: Data scattered in different formats; hard to access together.
- Integrity Problems: Enforcing rules (e.g., age must be > 0) is entirely up to application code.
- Concurrency Issues: No mechanism for multiple users to access data simultaneously without conflict.
- Security Problems: No fine-grained access control.
- No Recovery: System crashes can corrupt files with no automatic recovery.
How DBMS Solves These Problems
| Problem | DBMS Solution |
|---|---|
| Redundancy | Central storage, normalization |
| Inconsistency | Single authoritative source |
| Poor access | SQL query language |
| Integrity | Constraints (CHECK, FK, NOT NULL) |
| Concurrency | Locking, MVCC protocols |
| Security | Roles, GRANT/REVOKE |
| Recovery | Transaction logs, checkpoints |
Components of a DBMS
DBMS
| Query Processor | Storage Manager | |||
|---|---|---|---|---|
| - Parser | - Buffer Manager | |||
| - Optimizer | - File Manager | |||
| - Executor | - Auth Manager | |||
| Transaction Mgr | Data Dictionary | |||
| - Concurrency Ctrl | (System Catalog) | |||
| - Recovery Mgr |
- Query Processor: Parses, optimizes, and executes SQL queries
- Storage Manager: Manages physical file I/O and buffer pool
- Transaction Manager: Ensures ACID properties; handles concurrency and recovery
- Data Dictionary (System Catalog): Stores metadata — table schemas, indexes, user info, constraints
Purpose of a DBMS
- Data Storage and Retrieval — Store large volumes of data and retrieve them efficiently
- Data Integrity — Ensure data accuracy through constraints
- Data Security — Control who can read, write, or modify data
- Concurrent Access — Allow multiple users simultaneously without conflicts
- Data Independence — Applications unaffected by changes in data storage structure
- Backup and Recovery — Automatic mechanisms to restore data after failures
Exam Focus
Revise definitions, diagrams, examples, and short-answer points for Introduction to DBMS.
Interview Use
Prepare one clear explanation, one practical example, and one common mistake for this DBMS topic.
Search Terms
dbms, database management system, database notes, sql, unit, introduction, introduction to dbms
Related DBMS Topics
Continue learning this concept
Unit 1Unit 1 — Introduction to DBMS & Entity-Relationship ModelThis unit introduces the fundamental concepts of database management systems, the architecture that underlies them, and the Entity-Relationship ER model used for conceptuUnit 1Unit 1 Summary — Introduction to DBMS & ER ModelUnit 1Advantages and Disadvantages of DBMSData is stored in a centralized location. Normalization ensures that each fact is stored only once, eliminating duplicate data across multiple files.Unit 1Characteristics of DBMSA DBMS has distinct characteristics that differentiate it from simple file-storage systems. These characteristics are what make a DBMS powerful, flexible, and reliable foUnit 1DBMS LanguagesA DBMS provides several specialized languages for different types of database operations. These languages are collectively referred to as database languages or sublanguagUnit 1Keys in DBMSA key is an attribute or a set of attributes that is used to uniquely identify tuples rows in a relation table. Keys are fundamental to the relational model — they enforc