Advantages of DBMS over file system

Disadvantages of File framework: 

Information Isolation: Because information are scattered in different records, and documents might be in various configurations, composing new application projects to recover the fitting information is troublesome.

Duplication of information – Redundant information

Reliance(dependency) on application programs – Changing documents would prompt change in application programs.

Favorable position of DBMS over file framework 

There are a few focal points of Database administration framework over document framework. Few of them are as per the following:

No excess information – Redundancy expelled by information standardization

Information Consistency and Integrity – information standardization deals with it as well

Secure – Each client has an alternate arrangement of get to

Security – Limited get to

Simple access to information

Simple recuperation

Adaptable

No comments:

Post a Comment

What is Normalization?

Database normalization is a data design and organization process applied to data structures based on rules that help building relational dat...