Q. What are the major difference between a file system and a database management system? 5 marks
DBMS(Database Management System) :
Database Management System is basically software that manages the collection of related data. Example: MySQL, Oracle, MS SQL server etc.
File System :
The file system is basically a way of arranging the files in a storage medium like a hard disk. Example: NTFS(New Technology File System), EXT(Extended File System)
The difference can be summarize as:
| File System | DBMS |
|---|---|
| It is a software application that organizes and maintains files on a storage device. It manages the storage and retrieval of data. | It is a software application that allows you to access, create, and manage databases. |
| Redundant data is present | No presence of redundant data |
| Data consistency is low in the file management system. | In DBMS, the data consistency is high |
| Storing and retrieving of data can’t be done efficiently in a file system. | DBMS is efficient to use as there are a wide variety of methods to store and retrieve data. |
| File system is relatively cheaper as compared to DBMS. | DBMS is costlier as compared to a file system. |
| The centralization process is hard in File Management System. | Centralization is easy to achieve in the DBMS system. |
| There is no efficient query processing in the file system. | You can easily query data in a database using the SQL language. |
No comments:
Post a Comment