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

List the data structures implemented by the storage manager. The storage manager executes the following data structure a) Data files b) Data dictionary c) indices

How much would you charge to create a database encompassing an Online Bakery with all the elements below? I. Describe the application that you would like to design. This should

Draw an entity relationship diagram (ERD) for the following situation: A company has a number of employees. Each employee is identified by an Employee_Id. The company wants to st

What is a Database? To know what database is, we have to start from data, which is the basic building block of any DBMS. Data: Facts, figures, statistics etc. having no pa

Define the concept of aggregation.  Give two examples where this concept is useful. Ans: Aggregation transforms a relationship among the objects into a higher-level object. A

What do you mean by DBMS? What is its need and what are its goals. Explain?        OR   Explain Data Base Management System? Sol.  Database management system is a

The following relational database schema represents part of a simplified database used by a library: tblBook (BookID, Title, PublisherID, Category,Price) tblPublisher (Publishe

What are the ways of obtaining the connection parameters?  Hardwire the parameters into the program. Ask for the parameters interactively. Get the parameters

Primary Key The primary key is the candidate key that is selected by the database designer as the principal denotes of identifying entities within an entity set. The left candi