Question

Difference b/w dbms and file processing system

Answer 1

Difference between File processing system and DBMS:

1. A database management system coordinates both the physical and the logical access to the data, whereas a file-processing system coordinates only the physical access.

2.A database management system is designed to allow flexible access to data (i.e. queries), whereas a file-processing system is designed to allow predetermined access to data (i.e. compiled programs).

3. 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. In a file-processing system, a file can be accessed by two programs concurrently only if both programs have read-only access to the file.

4.Redundancy is control in DBMS, but not in file system.

5. Unauthorized access is restricted in DBMS but not in the file system.

6. DBMS provide back up and recovery whereas data lost in file system can't be recovered.

7. DBMS provide multiple user interfaces. Data is isolated in file system.