Lecture Notes on Database Management System (DBMS)

Introduction to DBMS

• DBMS is crucial for GATE, UGC NET, and other competitive exams.
• Important for B.Tech and BCA students.
• Increasing relevance in interviews; top companies base their operations on databases.

Database System

• A database system consists of two main components: Database and DBMS.
• Database: Collection of related data (e.g., Indian Railways data).
  • Related data means data that is specifically connected (e.g., train info, passenger info).
• DBMS: A system that allows users to perform operations on the database (insertion, deletion, update).

Types of Data

• Structured Data: Data stored in a specific format, typically in tables (RDBMS).
• Unstructured Data: Data that lacks a predefined structure (e.g., images, videos, web pages).
  • Majority of data today is unstructured (90%).

Structured vs Unstructured Data

• Structured data: Stored in table format (e.g., columns and rows, similar to Excel).
• Unstructured data: No defined format or structure for storage.
• RDBMS: Focuses on structured data and allows operations on that data in a relational format.

Operations in DBMS

• Key operations include:
  • Insertion: Adding new data.
  • Deletion: Removing existing data.
  • Update: Modifying existing data.

Management Systems

• Various companies offer different DBMS platforms:
  • Microsoft SQL Server
  • Oracle SQL Server (different versions)
  • MySQL (owned by Oracle)
  • IBM’s DB2.

Conclusion

• DBMS is essential for managing structured data efficiently through relational management systems.
• Future discussions will focus on RDBMS.