Chapter 16, Problem 1SA

Program Plan Intro

Usage of DBMS over File Management System:

• The search operation becomes difficult when a text or binary files contains huge amounts of data.
• The basic operations like insert data as well as delete data becomes difficult in file management system.
  • DBMS software is designed exclusively to store, search and manipulate huge data amount.
• The file system may not control data redundancy as each user would define and maintain required files for specific application.
  • DBMS can control redundancy, it stores single data storage that is been accessed by many users.
• The data sharing facility is difficult in file system.
  • In DBMS data could be shared by centralized system.
• File system has no provision to stop anomalies.
  • DBMS provides locking system to stop anomalies.
• File system requires different application programs for each search operation performed.
  • DBMS provides searching operations that are inbuilt.
  • A small query is to be written to retrieve the required data.
• File system has no provision to check constraints for data integrity.
  • DBMS maintains integrity of data; it enforces constraints on data that are user defined.
• In file system there is a heavy interdependence between data as well as programs.
  • DBMS provides a separation between data as well as program.
• In file systems, enforcing security constraints is difficult.
  • In DBMS, with central control over database, database administrator can enforce security constraints.
• Hence, due to all these advantages most businesses use DBMS to store data instead of text or binary files.