File System Vs DBMS

 File management  and DBMS

File management:-

File management is used to store the  data into hierarchical folder and file into the suitable storage. For example you want to store a information of employee data into in your local storage like Hard disk. Then you create a excel for the information and create a folder and store the excel file into the folder.

·        Organised: Organized store data in the form of File and Folder into the Suitable Storage.

·        Data Redundancy:  Same name of data or Duplicacy of Data across the multiple file.

·        Integrity: There have no data constraint (rules for a data) to stored data. So there have low data integrity and consistency.

·        Concurrency: Only Single Person has access the file at a time because the file store on a local device so concurrent execution is very difficult.

·        Security: Limited protection on the folder and file.

·        Scalability: file system is not scalable because only single person can access data.

·        Complexity: Very complex to find the data into the file.

 

DBMS:-

Database is used set of  rule and constraint to store , retrieve and update the data with the structured table format.

·        Organization: Organizes data into structured tables and defines relationships between them. 

·        Data Redundancy: Minimizes redundancy by storing data centrally. 

·        Data Integrity:  data integrity and consistency through rules and constraints. 

·        Concurrency: Manages concurrent access from multiple users, preventing conflicts. 

·        Security: Provides robust security features to control access and protect data. 

·        Scalability: Designed to handle large volumes of data efficiently. 

·        Features: Includes backup and recovery, data independence, and sophisticated data manipulation languages like SQL.

 

 

File System Vs DBMS:

S. NO	Features	File System	DBMS
1	Organized	Hierarchical file and folder	Structured data in table
2	Data Redundancy	Low	High
3	Integrity	Low	High
4	Consistency	Low	High
5	Data Independency	Lack independency	Provide Data Independancy
6	Concurrency	No Concurrency	Multiple User use concurrently
7	Security	Low Security	High Security
8	Scalability	Limited	High
9	Cost	Low	High