Question

Distinguish between open and closed logical data units ppt

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. compiledprograms).3. A database management system is designed tocoordinate multiple users accessing the same data at the same time. A file-processing system is usually designed to allow one or more programsto 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 butnot 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.