In the previous days, Data was stored using a File processing system in place of DBMS. On the other hand, the File processing system is nothing but saving data in different file formats. Let us take an example of the data of employees in an organization. Previously, Most companies considered MS Excel to store the data of their employees.
However, nowadays the use of computers has increased, therefore leading to the lot increase of Data. Moving forward, it became difficult to manage data in FPS. Considering the digital environment, companies started looking forward to DBMS software. Also, using DBMS proved out to be more advantageous than using FPS.
Some of the Drawbacks of the File Processing system that DBMS accomplished are:-
- Data Redundancy- Data redundancy means the duplication of the Data. For instance, Madhu has both a savings and a current account in Indian Bank. However, there might be a higher probability of having a duplicate copy of details about Madhu stored, leading to the wastage of memory and space.
- Less Security- FPS does not practice good security of data. As Multiple files in a system are used to store data, any user accessing the system can retrieve it. Thus, leading to less security of data.
- Isolation of Data- The files are present in different file formats when it comes to the File Processing System. Such file format can have .dov, .exe, etc. extension.
- Inconsistency- As in FPS, data was stored using multiple files. So, there can be the probability of having multiple copies of the same file. So change in one file can make two different files thus, creating inconsistency.
- Hard retrieval of Data- In a File Processing system, it is hard to access data suitably and competently.
DBMS vs File System
|A file system is a more unstructured data store for storing arbitrary, probably unrelated data.||A database is generally used for storing related, structured data, with well defined data formats, in an efficient manner for insert, update and/or retrieval (depending on application).|
|Data Redundancy||In a file management system, data redundancy is high.||Data redundancy is low in a DBMS.|
|Consistency||In file system, does not provide data consistency.||In DBMS, the data consistency is high.|
|Data Sharing||Sharing data is harder in file management system.||Sharing data is easier in DBMS.|
|Integrity||In file management system, the data integrity is low.||Data integrity is high in DBMS.|
|Operations||Updating, searching, retrieving data is harder in a file management system.||Updating, searching, retrieving data is easier in DBMS because of queries.|
|Security||Data is not very secure in file management system.||In DBMS, the data is more secure.|
|Backup and Recovery Process||Backup and recovery process is simple in a file system.||Backup and recovery process is complex in a DBMS.|
|Number of Users||File management system is suitable for small organizations or single users.||DBMS is suitable for large organizations to support multiple users.|
|Data storage||File System allows you to stores the data as isolated data files and entities.||Database Management System stores data as well as defined constraints and interrelation.|
|Transactions||Not provide support for complicated transactions.||Easy to implement complicated transactions.|
|Centralization||The centralization process is hard in File Management System.||Centralization is easy to achieve in the DBMS system.|
|Concurrency||These system doesn't offer concurrency.||DBMS system provides a concurrency facility.|