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
Difference between SQL and SQL*Plus SQL SQL*Plus SQL is a language SQL *Plus is an environment It   is   bas

Explain Derived and Non-Derived Attribute? In few cases, two or more attribute values are related, for instance, Age and BirthDate attributes of a person. For specific person e

a) Distinguish between ‘database' and ‘Database Management Systems (DBMS)'. b) List and briefly describe five potential benefits of the database approach compared to conventio

What is the disadvantage of a call by reference? During a call by reference damage or loss of data is not restricted to the subroutine, but will instantly lead to alters to th

The entity type STUDENT has the following attributes: Student Name, Address, Phone, Age, Activity, and No of Years. Activity represents some campus-based student activity, and No o

What are the requirements to ensure the objectives of file management principle is realized?

A View may be defined of as a virtual table, that is, a table that does not really exist in its own right but is instead inferred from one or more underlying base data table. T

Distributed query and transaction processing a.  Construct a query around any one of the functional divisions you made in 4a such that if executed in the distributed design of 4

Explain Hashing techniques The hashing techniques can be categorized as: Static Hashing Techniques - In this method, the data can be viewed a collection of buckets, along with

Smart Alex Catering Sevice (SACS) is a company offering top class catering staff  for prestigious events.  The company employs approximately 200 hourly paid contact staff - chefs,