File organization in DBMS
Table of Content:
File System v/s DBMS
Parameters | DBMS | File System |
---|---|---|
Meaning | DBMS is a collection of data and set of programs to access those data. | File system is an abstraction to store, retrieve and update a set of files. |
Data Redundancy | Repetition of data can be reduced. | Repetition of data cannot be reduced. |
Data Inconsistency | Inconsistency of data can be avoided. | Inconsistency of data cannot be avoided. |
Data Inconsistency | Inconsistency of data can be avoided. | Inconsistency of data cannot be avoided. |
Sharing of Data | Data can be shared easily. | Data cannot be shared easily. There is difficulty in accessing the data. |
Data Integrity | The data can be accessed from the database through physically as well as logically. | Data independence cannot be provided to access the data. |
Response to Request | It gives fast response to information request because the data are integrated into a single database. | It gives slow response to information request. |
Security | It restricts unauthorized access. | Lack of security. |
Concurrency Control | Data can be accessed by multiple users at same point of time. | Problem in concurrency control. |
Data Recovery | It provides back up of data and restores the database to its original state after database failure. | It does not provide back up and data recovery. The data may loss if the operation is failed. |