Beginner-DBMS-understanding dbms

Understanding DBMS: How Data Is Stored and Managed

I’ve recently started my journey into tech, focusing on building real skills and understanding core Computer Science fundamentals. One of the first concepts I learned is DBMS (Database Management System) and how data is stored and managed.

What is Data?

Data is raw, unprocessed facts. It can exist in many forms such as:

Text, Numbers , Images, Files , Qualitative and quantitative values

On its own, data doesn’t give much meaning.

From Data to Information

When data is organized, analyzed, and processed, it becomes information.

Example:
Suppose we receive random data about school students—names, marks, roll numbers, etc.
When we organize students based on their marks (pass/fail, grades, rank-wise), we extract useful information from raw data.

What is a Database?

A database is an organized collection of related data stored electronically so that it can be easily accessed, managed, and updated.

What is DBMS?

A DBMS (Database Management System) is software that allows users and applications to interact with a database.

Using a DBMS, we can perform CRUD operations:

• Create data

• Read/Retrieve data

• Update data

• Delete data

Examples of DBMS: MySQL, PostgreSQL, Oracle ,MongoDB

Database Architecture

The DBMS acts as a bridge between the user and the database.

USER→DBMS→DATABSE

Why Not Traditional File Systems?

Before DBMS, data was stored using file systems, which caused several issues:

1. Data Inconsistency-The same data stored in multiple files could become different after updates.

2. Data Redundancy-Duplicate data wasted storage space.

3. Data Isolation-Data was scattered across different files and formats, making access difficult.

4. Security Issues-There was no proper access control or authorization.

5. Difficulty in Data Retrieval-Fetching required data was slow and inefficient.

Why DBMS Was Introduced?

To overcome the limitations of file systems, DBMS was introduced. It provides:

• Centralized data control

• Reduced redundancy

• Better security

• Consistent and reliable data

• Efficient data retrieval

Conclusion

Understanding DBMS is essential for anyone starting in tech. It forms the foundation for backend development, data engineering, and system design. Learning how data is stored and managed helps build scalable and secure applications.