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.

Question

Want to see the full answer?

Answer 1

Question

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.

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Students have asked these similar questions

I need to make a parallel version of this sequential code.

Benefits of using arrays as instance variables: What are the advantages of incorporating arrays as instance variables within a class? Initializing and managing arrays: How do you initialize and manage arrays within class constructors and mutators (setters)? Example of using arrays as instance variables: Share an example where you have used arrays as instance variables and discuss its application in a real-world scenario. Common mistakes with arrays as instance variables: What are some common mistakes to avoid when working with arrays as instance variables? Information hiding violations: What is the potential violation of information hiding when using arrays as instance variables? How can this be resolved?

Do you think that computers should replace teachers? Give three references with your answer.