Difference between File System and DBMS

Difference Factor	File System	DBMS
Definition	With this, you need to develop information manipulation program.	With this, you will get predefined information manipulation program, you have to just use it by writing proper syntax.
Data Redundancy	It may possible that same information is duplicated in different files.	Due to centralized database, it is possible to avoid information duplication.
Data Inconsistency	Because of data redundancy, data may not be in consistent state.	Data is in consistent state because of minimal data redundancy.
Accessing Data	It is difficult and inconvenient to access data.	It is easy and convenient to access data.
Data Sharing	Data  are scattered in different files, So Data sharing is limited.	Data sharing is easy and not limited because of centralized database.
Integrity	Integration of new rule/constraint is difficult.	Integration of new rule/constraint is easy.
Atomicity	It is difficult to achieve atomicity in file system, for that you have to write separate supervisor program.	DBMS itself provides atomicity for each transaction.
Concurrent Access	It is difficult to achieve a safe concurrently data access by multiple users.	It provides a facility for concurrent access of data by multiple users.
Security	Data security is less than DBMS.	Data security is more than file system.

<-- Previous     Next--->