File System:- It helps to store a collection of raw files of data into a hard disk of the computer
DBMS:- It is a software system which helps to store, manipulate or recover data.
File System:- In this system, the user has to write the procedures for managing the database.
DBMS:- In DBMS, the user is not required to write the procedures.
File System:- File system approach used in large systems which interrelate many files.
DBMS:- Database approach used in large systems which interrelate many files.
File System:- In the file system, Redundant data can be present.
DBMS:- In DBMS there is no redundant data.
File System:- It doesn’t provide backup and recovery of data if lost.
DBMS:- It provides backup and recovery of data even if it is lost.
File System:- There is no efficient query processing in the file system.
DBMS:- Efficient query processing is there in DBMS.
File System:- There is less data consistency in the file system.
DBMS:- There is more data consistency because of the process of normalization.
File System:- It is less complex as compared to DBMS.
DBMS:- It has more complexity in handling as compared to the file system.
File System:- File systems provide less security in comparison to DBMS.
DBMS:- DBMS has more security mechanisms as compared to file systems.
File System:- It is less expensive than DBMS.
DBMS:- It has a comparatively higher cost than a file system.
File System:- There is no data independence.
DBMS:- In DBMS data independence exists.
File System:- Only one user can access data at a time.
DBMS:- Multiple users can access data at a time.
File System:- Data is distributed in many files. So, not easy to share data
DBMS:- Due to its centralized nature sharing is easy
File System:- It gives details of storage and representation of data
DBMS:- It hides the internal details of Database
File System:- Integrity Constraints are difficult to implement
DBMS:- Integrity constraints are easy to implement
File System:- Cobol, C++
DBMS:- Oracle, SQL Server