advantages of database over file system, Database Management System

Assignment Help:

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.


Related Discussions:- advantages of database over file system

Explain p command in the respect of qbe, Explain P command in the respect o...

Explain P command in the respect of QBE? P: It is the command in which is used to print (logically display) the value of the attribute in whose cell it is writ

Sorting-stacks, 1. Identify the comparisons and exchanges made to sort the ...

1. Identify the comparisons and exchanges made to sort the following array using the selection exchange sort technique. Note: you may not need all columns. Ori

Define entity integrity and referential integrity, Define entity integrity ...

Define entity integrity and referential integrity.  How does SQL allow specification of  these? Ans: Entity Integrity Rule- If the attribute A of relation R is a prime attribut

List the armstrong axioms for functional dependencies, List the Armstrong's...

List the Armstrong's axioms for functional dependencies.  What do you understand by soundness and completeness of these axioms?      Ans: The Armstrong's axioms are: F1:

Type of views-data control, Type of views :  Simple views and Difficult ...

Type of views :  Simple views and Difficult Views Feature Simple Views Complex Views Number of tables One

Benefits of using a relational database management system, Question 1: ...

Question 1: a) What is the difference between a non-impact and impact printer? b) Which type of printer is generally used in a supermarket to print your receipt? Describe

Describe integrity and security, Describe integrity and security? a)   ...

Describe integrity and security? a)      Domain constraint b)      Referential integrity A value that appears in one relation for a given set of attributes also appear fo

The structured query language, The Structured Query Language INTRODUCT...

The Structured Query Language INTRODUCTION Database is an organised set of information about an entity having controlled redundancy and serves numerous applications. DBMS

What are the desirable properties of a decomposition, Define What are the d...

Define What are the desirable properties of a decomposition Ans: What are the desirable properties of decomposition - dependency preserving.  Because Lossless join and dependen

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd