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
Explain controlled redundancy? Controlled redundancy : The replication of data within the data warehouse for the purposes of improved data access or understand ability.

Explain Dynamic Two-Phase Locking Here a transaction locks a data item instantly earlier than any operation is applied on the data item.  After finishing all the operations on

1. Which relational algebra operations do not need the participating tables to be union-compatible? Ans: Join is the relational algebra operations that do not need the particip

List the types of authorization. A) Read authorization B) Write authorization C) Update authorization D) Drop authorization


What is storage manager? A storage manager is a program module that gives the interface among the low level data keeps in a database and the application programs and queries su

Define average seek time. The average seek time is the average of the seek times, calculated over a sequence of random requests.

Let us first look into some of the important features of ER model. Entity relationship model is a high-level conceptual data model. It permits us to define the data invo


Define Shared locks? Ans: Shared lock: Throughout concurrent execution of transactions, earlier than a transaction can access a data item, it has to obtain a lock on it. Now he