Document 1:
Advanced_Database_Management_Note
s_2024.pdf
Title: Fundamentals of Database
Management Systems (DBMS)
1. Introduction to DBMS
A Database Management System (DBMS)
is software designed to store, retrieve,
define, and manage data in a database. It
serves as an interface between the
database and its end-users or programs,
ensuring that data is consistently
organized and remains easily accessible.
2. Key Components of a DBMS
• Hardware: Physical devices such as
storage drives, servers, and network
infrastructure.
• Software: The core database
management engine along with
application programs and OS
interfaces.
• Data: The operational collection of
information stored within the system.
• Data Access Language: SQL (Structured
Query Language) used to access,
modify, and query data.
3. Database Architecture (3-Schema
Architecture)
1. Internal Level (Physical Schema):
Describes how data is physically stored
on the hardware.
2. Conceptual Level (Logical Schema):
Defines the logical structure, entity
relationships, and constraints.
3. External Level (View Schema):
Describes various views of the
database for different user roles.
4. ACID Properties in Transaction
Management
• Atomicity: All operations in a
transaction complete successfully, or
none do.
• Consistency: Data moves from one
valid state to another, upholding all
constraints.
• Isolation: Concurrent execution of
transactions yields the same result as
sequential execution.
• Durability: Committed changes persist
even in the event of system failures.