Dbms vs file system
Difference Between file system and Dbms
The file system approach refers to an early method of data management in which each department or unit within an organization independently handles its own data using individual files. In this decentralized system, data processing specialists create, manage, and maintain these files and the associated structures, as well as develop programs to produce reports from the data. This approach contrasts with more integrated systems where data is centralized and managed uniformly across the organization.
In this above figure:
In the example of a student's file system, there are separate files for different types of information: a student file with details such as roll number, name, and course; a subject file with information about the subjects; and a result file with details about student results. However, some fields are repeated across these files, leading to data redundancy. To address this issue and eliminate duplication, it is necessary to transition to a centralized system, such as a Database Management System (DBMS).
DBMS
A Database Management System (DBMS) represents a structured and coherent collection of data that is interrelated and stored in a single location, yet accessible to multiple users. The DBMS enables various operations, including adding, removing, retrieving, and organizing data.
In the figure provided, data duplication is minimized due to the centralization of information.
There are the following differences between DBMS and File systems:
