Difference between File System and DBMS

What is File Management System?

A file management system is a collection of programs that manage and store data in files and folders in a computer hard disk. A file management system manages the way of reading and writing data to the hard disk. It is also known as conventional file system.
This system actually stores data in the isolated files which have their own physical location on the drive, and users manually go to these locations to access these files. It is the easiest way to store the data like text, videos, images, audios, etc. in general files. Data redundancy is high in file management system, and it cannot be controlled easily. Data consistency is not met, and the integration of data is hard to achieve.

Operating System such as Linux and Windows has its own file system.

For example, NTFS is the Windows file system, and EXT is the Linux file system.

These operating systems provide less security to these files where they have options such as hide files, locks, and sharing on files.

What is Database Management System?

  • The Database Management System or DBMS is an effective or easy way to store the data, mainly when data maintenance and security are the primary concern of the user.
  • The database management system stores the data or information in the form of interrelated tables and files.
  • In this type of system, data security is maximized using encryption/decryption, password protection, granting authorized access and others.
  • DBMS helps users to easily retrieve, insert, and manipulate data in a database.
  • It also helps to perform data recovery, transactions, and many more.
    Handling DBMS is difficult than the file system, but it provides more advantages than a file system.

Difference between File System and Database Management System

There are following differences between file system and DBMS:

File System     Database Management System (DBMS)
1. It is a software system that manages and controls the data files in a computer system. 1. It is a software system used for creating and managing the databases. DBMS provides a systematic way to access, update, and delete data.
2. File system does not support multi-user access. 2. Database Management System supports multi-user access.
3.  Data consistency is less in the file system. 3. Data consistency is more due to the use of normalization.
4. File system is not secured. 4. Database Management System is highly secured.
5. File system is used for storing the unstructured data. 5. Database management system is used for storing the structured data.
6. In the file system, data redundancy is high. 6. In DBMS, Data redundancy is low.
7. No data backup and recovery process is present in a file system. 7. There is a backup recovery for data in DBMS.
8. Handling of a file system is easy. 8. Handling a DBMS is complex. 
9. Cost of a file system is less than the DBMS. 9. Cost of database management system is more than the file system.
10. If one application fails, it does not affect other application in a system. 10. If the database fails, it affects all application which depends on it.
11. In the  file system, data cannot be shared because it is distributed in different files. 11. In DBMS, data can be shared as it is stored at one place in a database.
12. These system does not provide concurrency facility. 12. This system provides concurrency facility.
13. Example: NTFS (New technology file system), EXT (Extended file system), etc. 13. Example: Oracle, MySQL, MS SQL Server, DB2, Microsoft Access, etc.