Difference Between File System and DBMS
Advertisements
Difference Between File System and DBMS
The main difference between file system and DBMS is that the file system helps to store a collection of raw data files into the hard disk while the DBMS helps to easily store, retrieve and manipulate data in a database.
A file system is a software that manages the data files in a computer system. On the other hand, DBMS is a software to create and manage databases. Handling a file system is easier than DBMS, but the DBMS provides more advantages than a file system.
Difference Between File System and DBMS
| DBMS | File System |
|---|---|
| DBMS is a collection of data. In DBMS, the user is not required to write the procedures. | File system is a collection of data. In this system, the user has to write the procedures for managing the database. |
| DBMS gives an abstract view of data that hides the details. | File system provides the detail of the data representation and storage of data. |
| DBMS provides a crash recovery mechanism, i.e., DBMS protects the user from the system failure. | File system doesn't have a crash mechanism, i.e., if the system crashes while entering some data, then the content of the file will lost. |
| DBMS provides a good protection mechanism. | It is very difficult to protect a file under the file system. |
| DBMS contains a wide variety of sophisticated techniques to store and retrieve the data. | File system can't efficiently store and retrieve the data. |
| DBMS takes care of Concurrent access of data using some form of locking. | In the File system, concurrent access has many problems like redirecting the file while other deleting some information or updating some information. |
| Redundancy is control in DBMS | Redundancy not control in file system |
| Unauthorized access is restricted in DBMS | Not in the file system |
| DBMS provide back up and recovery | Data lost in file system can't be recovered. |
| DBMS provide multiple user interfaces | Data is isolated in file system. |
| A database management system coordinates both the physical and the logical access to the data | file-processing system coordinates only the physical access. |
| A database management system is designed to allow flexible access to data (i.e. queries) | A file-processing system is designed to allow predetermined access to data (i.e. compiled programs). |
| A database management system is designed to coordinate multiple users accessing the same data at the same time. | A file-processing system is usually designed to allow one or more programs to access different data files at the same time. |
Google Advertisment