File System Vs DBMS

Database management system (DBMS) is a collection of interrelated data and a set of programs to access those data. The very well known DBMS are Microsoft Access, Microsoft SQL Server, Oracle, SAP, dBASE, FoxPro, IBM dB2, SQLite etc.


File Management System keep track on the files and also manage them. For Example: Hierarchical Management System using its directories manage the different files in a tree structure.

The disadvantages of file management systems over DBMS are:

a) Data redundancy and inconsistency
b) Difficulty in accessing data
c) Data isolation
d) Integrity problems
e) Atomicity problems

The advantages of DBMS over file management system are:

a) Control redundancy
b) Restrict unauthorized access
c) Provide multiple user interfaces
d) Enforce integrity constraints.
e) Provide backup and recover

File Management System	DBMS
File management system is a DBMS that  allows access to single files at a time.	File management system was the  predecessor for the DBMS which allows   access to multiple files a a time.
File management system accommodate  flat files that have no relation to other files.	DBMS provides replation between the files.
File mangament system doesnot support  multiuser access.	DBMS support multi user access.
Limited to smaller databases.	It fits for the needs of many medium to  large sized organization or database.
Decentralization of data.	Centralized data.
Issues occur such as redundancy and  integrity	No such issue like redundancy and  integrity occurs here.Infact ,it controls the  redundancy and integrity problem which  occurs in File management system.