advantages of database over file system, Database Management System

Q. Why would you choose a database system instead of simply storing data in operating system file? Define  at a base concept in details.

Sol. Advantages of Database over File System:

1. Controlling redundancy: The redundancy in storing the same data multiple time leads to several problems. In database approach, the views of different use of groups are integrated during database design.

 2. Restricting unauthorized access: When multiple users share a database, it is likely that some users will not be authorized to access all information in the database. The DBMS provides security and authorization suggestions which the DBA uses.

3. Providing persistent storage: Database can be used to provide persistent storage for program objects and data structures.

4. Permitting inferencing and actions using rules: Some systems provide capabilities for defining deduction rules for inferencing new information from ser database facts.

5. Provides multiple user interfaces.

6. Representing complex relationships among data.

7. Enforcing constraints: A DBMS should provide capabilities for defining and enforcing these constraints.

8. Providing backup and recovery: A DBMS must provide facilities for recovering from hardware and software families.

Disadvantages: These are a few situations in which such a system may involve unnecessary overhead costs. The costs are due to:

1. High initial investments

2. Generality that a DBMS provides

3. Overhead for providing security, etc.

Hence, it may be more desirable to use regular files when

(i)                  The database and applications are simple, well defined and not expected to change.

(ii)                 Multiple user access is not required.

Posted Date: 7/11/2012 4:25:51 AM | Location : United States







Related Discussions:- advantages of database over file system, Assignment Help, Ask Question on advantages of database over file system, Get Answer, Expert's Help, advantages of database over file system Discussions

Write discussion on advantages of database over file system
Your posts are moderated
Related Questions
Define a job scheduling strategy that will meet business requirement of reporting availability by 6am CST for the following cubes? Show the job scheduling dependencies in a pictori

Project Description: I am having a random problem with my Wordpress site. If I click on "Publish" and "Add new", it takes me to a 404 page not found of /wp-admin/post.php (th

Explain the shadow paging recovery technique.  Ans: Shadow paging is a method used to acquire atomic and durable transactions, and provides the capability to manipulate pages i

Define weak and strong entity sets? Weak entity set: entity set that do not have key attribute of their own are known as weak entity sets. Strong entity set: Entity set that

Derived horizontal fragmentation: Some applications may include a join of two or more relations. If the relations are stored at dissimilar locations, there may be a major overhead

Determine the OBJECTIVES of  object design After passing through this unit, you should be able to: describe and apply concept of generalisation; understand and appl

These are interactive interfaces, graphical that hide the difficulty of the DBMS and query language behind an intuitive, simple to understand, and convenient interface. This permit

Write a program within embedded SQL to associative the total trip expenses of the salesman named ‘John' for the relations. EXEC SQL BEGIN DECLARE SECTION; long total_expenses;

Cardinality of Relationship One-to-One Only one entity of the first set is linked to only one entity of the second set. E.g. A teacher teaches a student. Only one teacher

Modify a sequence: ALTER SEQUENCE SEQSS INCREMENT 2 MAXVALUE 3000;   Removing a sequence: DROP SEQUENCE SEQSS;