File organization in DBMS

Rumman Ansari   Software Engineer   2023-03-23   5693 Share
☰ Table of Contents

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.