DBMS Notes

A Database Management System (DBMS) is a collection of interrelated data along with a set of programs that are used to access and manage that data.

Definition of DBMS

A DBMS is software that helps in storing, organizing, and retrieving data efficiently. It allows users to manage data in different forms such as:

• Tables

• Schemas

• Views

• Reports

Primary Goal of DBMS

The main goal of a DBMS is to provide a convenient and efficient way to:

• Store data

• Retrieve data

Components of DBMS

DBMS consists of two main parts:

• Database: A collection of related data stored in a structured format, accessible to multiple users for different purposes.

• Management System: A set of programs that help users create, maintain, and control the database.

Role of DBMS

A DBMS acts as an interface between the application programs and the operating system, allowing users to:

• Access data

• Manipulate data

Working Structure

Examples of DBMS

Some popular DBMS software are:

• MySQL

• Oracle

• Microsoft SQL Server

These are widely used in different applications for managing data efficiently.

• Digital Data Storage
  DBMS uses a digital repository (database server) to store and manage data efficiently.

• Logical Data View
  It provides a clear and logical view of the data, allowing users to easily access and manipulate information.

• Backup and Recovery
  DBMS includes automatic backup and recovery procedures to protect data in case of system failure.

• ACID Properties
  DBMS follows the ACID properties:

  • Atomicity – Ensures complete execution of transactions or none at all

  • Consistency – Maintains data consistency before and after transactions

  • Isolation – Transactions are executed independently

  • Durability – Once a transaction is committed, it remains permanent

• Data Integrity and Reliability
  It ensures that data remains accurate and reliable even in case of system failures.

• Reduced Data Complexity
  DBMS reduces the complexity of relationships between data by organizing it efficiently.

• Data Manipulation
  It supports easy manipulation of data (insert, update, delete, retrieve).

• Data Security
  DBMS provides strong security features to protect data from unauthorized access.

• Multiple Views of Data
  It allows different users to view the database according to their requirements.

Advantages of DBMS

1. Control of Data Redundancy
   DBMS reduces data redundancy by storing all data in a single database, avoiding duplicate records.

2. Data Sharing
   Authorized users can easily share data among multiple users within an organization.

3. Easy Maintenance
   Due to its centralized nature, the database is easy to maintain and manage.

4. Time Saving
   It reduces development time and maintenance efforts.

5. Backup and Recovery
   DBMS provides automatic backup and recovery systems to protect data from hardware or software failures.

6. Multiple User Interface
   It offers different types of user interfaces such as:

   • Graphical User Interface (GUI)

   • Application Programming Interface (API)

Disadvantages of DBMS

1. High Cost
   DBMS requires expensive hardware and software to operate efficiently.

2. High Hardware Requirements
   It needs a high-speed processor and large memory (RAM) to run smoothly.

3. Large Storage Space
   DBMS occupies a large amount of disk space and memory.

4. System Complexity
   The database system is complex to design, manage, and understand.

5. High Impact of Failure
   If the central database is damaged (due to power failure or corruption), it can lead to serious data loss since all data is stored in one place.

There are various types of databases used for storing different kinds of data.

1. Centralized Database
2. Distributed Database
3. Relational Database
4. NoSQL Database
5. Cloud Database
6. Object-Oriented Database
7. Hierarchical Database
8. Network Database

1. Centralized Database

• A database that stores data in a centralized system.
• Users can access data from different locations using applications.
• These applications include authentication for secure access.
• Example: Central library system in a college/university.

2. Distributed Database

• Data is distributed across multiple database systems in an organization.
• These systems are connected through communication links.
• Helps users access data easily from different locations.

Types:

• Homogeneous Database
• Heterogeneous Database

3. Relational Database

• Stores data in the form of rows (tuples) and columns (attributes).
• Data is organized into tables (relations).
• Uses SQL (Structured Query Language).
• Each table has a primary key for unique identification.

Examples:

• MySQL
• Microsoft SQL Server
• Oracle

4. NoSQL Database (Not Only SQL)

• Used for storing a wide variety of data.
• Not limited to tabular format like relational databases.
• Stores data in multiple formats.

Types:

1. Key-Value Store
2. Document-Oriented Database
3. Graph Database
4. Wide-Column Store

5. Cloud Database

• Data is stored in a cloud (virtual environment).
• Runs on cloud computing platforms.
• Provides services like:
  • SaaS (Software as a Service)
  • PaaS (Platform as a Service)
  • IaaS (Infrastructure as a Service)

Examples:

• Amazon Web Services (AWS)
• Microsoft Azure
• Google Cloud SQL

6. Object-Oriented Database

• Stores data in the form of objects.
• Based on object-oriented programming concepts.
• Objects contain both data and methods.

7. Hierarchical Database

• Organizes data in a tree-like structure.
• Uses parent-child relationships.

Key Points:

• Each child has only one parent.
• A parent can have multiple children.
• Data is stored as records connected via links.

8. Network Database

• Follows a network data model.
• Data is represented as nodes connected by links.
• Allows multiple parent and child relationships.
• Forms a graph structure.