Lec-2: Introduction to DBMS (Database Management System) With Real life examples | What is DBMS

Summary

The lecture introduces database systems, databases, and database management systems (DBMS), then explains how these concepts lead to relational DBMS (RDBMS).

Why DBMS Matters

The instructor notes that databases are important in computer science courses, competitive exams, and job interviews because many large companies rely on database systems.

Database System

A database system consists of two parts:

1. Database — an organized collection of data.
2. DBMS — software used to manage and work with that data.

Database

A database is a collection of related data. For example, a railway database may contain train and passenger information relevant to railway services. The key idea is that a database brings together information related to a particular purpose rather than unrelated data.

Database Management System (DBMS)

A DBMS lets users work with data without needing to know where it is physically stored. Typical operations include:

• Insert new data.
• Delete existing data.
• Update information, such as a changed address.
• Access or search for data.

Examples of DBMS products include Microsoft SQL Server, Oracle, MySQL, and IBM DB2.

Structured Data and RDBMS

Structured data follows a predefined organization. A common format is a table, technically called a relation, made up of rows and columns. The lecture compares this format to a spreadsheet.

A relational DBMS manages data stored in this table-based form. For example, a railway search might display trains in a table with columns such as train number, train name, seat type, and departure time. The lecture focuses on managing these relations and performing operations on them.

Unstructured Data

Unstructured data does not follow one fixed, predefined table format. Examples include photos, videos, chats, and mixed webpage content. A webpage, for instance, may combine text, images, and video in varying arrangements.

Scope of the Lecture

The course focuses on structured data and RDBMS, while also acknowledging that many modern technologies work with unstructured data. Big data and Hadoop are cited as examples. The instructor estimates that roughly 90% of the world’s data is unstructured.

Speaker

• Varun, Gate Smashers instructor — the sole speaker, presenting the DBMS lesson.