Database system vs file system-computer world

Database system vs file system

pixabay

Data redundancy

it means duplication of data for more than one place. Like a customer detail like name, account number, address are stored at more than one place. In file system redundancy of data increase which consume more space and more difficult to maintain. By using DBMS we can reduce data duplication and update the data.

Insert and delete records

In file system we cannot insert and delete any particular record from data. DBMS provides faculty of deletion and also we can easily insert new record or data.

Difficult to search the data

In file system if we want to search popular record for example record of that customer who's minimum balance is 75000 in saving account so it is difficult to retrieve those data. But by using DBMS there are searching options are easily available.

Security problem

In file system there is very less or no security DBMS provides high level security mechanism like password,security, bio metric devices.

Data isolation

In file system there is no standard format of data, so retrieving data is now difficult.

Concurrent access anomalies

For speed and faster working, we need to accept more than one data concurrently but it is difficult to access in file system.

File system