Advantage of DBMS/Comparison of TFS&DBMS / Objective of DBMS

Advantage of DBMS or Comparison of Traditional File System & DBMS or Objective of DBMS

...................................................................................................................................................................

1.Data Redundancy & Inconsistency can be control:       

  since the files & application programs are created by different programmers so various files are likely to have different formats & information may be duplicate at many cases.

“ Duplicate information is data Redundancy”. It causes wastage of space if the modification is needed & it’s not done at all places than it will cause Inconsistency."

In DBMS approach we design the database and apply Normalization to reduce data redundancy & relationships can be used to control inconsistency.

2. Simplicity in Data Access:

DBMS provide the environment & standard methods to access the data in various ways with simplicity. The traditional file system does not provide such facility it needs considerable programming efforts.

3. Co-relation of data:

In TFS data are scattered in various files which are not logically related the files may be in different formats it causes difficulty in accessing &organizing the data.

In DBMS various files are interlinked it results in better organization of data.

4. Integrity Maintenance:

There are many type of integrity constraints like minimum and maximum permitted value of data to apply such constraints needs considerable programming efforts in TFS.

In DBMS these integrity constraints can be applied easily because there are special provisions for it.

5. Data Security:

Every user should not be able to access the complete database the data should be protected with the help of passwords.

There should be protection & security of data from system failures.

TFS does not provides such facilities.

6. Development Time:

Since DBMS provide many standard facilities so that the total development time is less than TFS.

7. Flexibility to change data structure:

In DBMS structure of database may change as new requirements are defined.

But in TFS its not possible.

8. Concurrent Access:

In multi-user database there can be multiple request can arise simultaneously to access the database.

But TFS does not provide such facilities.

9. Availability of up to date information:

This feature is very important for online transaction system such as airline, banking, railway, and hotel etc.

But TFS does not provide such facilities.