AGRI Grovestudies
Difference between File System and DBMS ?
| Basis | File System | DBMS |
|---|---|---|
| Structure | The file system is software that manages and organizes the files in a storage medium within a computer. | DBMS is software for managing the database. |
| Data Redundancy | Redundant data can be present in a file system. | In DBMS there is no redundant data. |
| Backup and Recovery | It doesn’t provide backup and recovery of data if it is lost. | It provides backup and recovery of data even if it is lost. |
| Query processing | There is no efficient query processing in the file system. | Efficient query processing is there in DBMS. |
| Consistency | There is less data consistency in the file system. | There is more data consistency because of the process of normalization. |
| Complexity | It is less complex as compared to DBMS. | It has more complexity in handling as compared to the file system. |
| Security Constraints | File systems provide less security in comparison to DBMS. | DBMS has more security mechanisms as compared to file systems. |
| Cost | It is less expensive than DBMS. | It has a comparatively higher cost than a file system. |
| Data Independence | There is no data independence. | In DBMS data independence exists. |
| User Access | Only one user can access data at a time. | Multiple users can access data at a time. |
| Meaning | The user has to write procedures for managing databases | The user not required to write procedures. |
| Sharing | Data is distributed in many files. So, not easy to share data | Due to centralized nature sharing is easy |
