Advertisement

File System : difference between DBMS and file system

File Processing System 

File System-

File Processing system is supposed to by a conventional operating system. The system stores permanent record in various files, and it's near different application program to extract record from and add record to the appropriate files before DBMS came along. Organization usually stored information in such system.  


Traditionally, data was stored end processed multiple files with the help of a program (or a group of programs) for each application. This is known as file based approach of database management. A file may be defined as systematized self containing collection of records. 
It may consist of Data (data file) or it may contain a sequence of basic statements. Each user work with a different program that handles its own independent data.    





DBMS-

A database system is a computerized record, keeping system whose overall purpose is to maintain information and to make it available on demand. 
The management of data involves defining the structure for information storage and provision of mechanisms for its manipulation. 

DBMS also provide mechanism for the safety of the stored information from data corruption and or unauthorized access. In addition, the database system avoid possible anomalous result in case the data is to be shared among several users.

Difference between File System and DBMS


File System DBMS
redundancy problem exist. Data redundancy problem is not found.
Data inconsistency does exits. Data inconsistency does not exist.
File system does not support multi user access. DBMS support multi user access.
Handling of a file system is easy. Handling of a DBMS is complex.
Cost of a file system is less than the DBMS. Cost of DBMS is more than the file system. Too human.
No data backup and recovery process is present in a file system. There is a backup recovery for data in DBMS.
Atomicity and integrating problem are found. Atomicity and integrating problem are not found.
There is no concurrent access and no recovery. Concurrent access and crash recovery.
File system is not secured. DBMS is highly secured.
Data inconsistency is less in the file system. Data inconsistencies more due to the use of normalization.
File system software that manage and control the data file in a computer system. DBMS Is the system software used for creating and managing the database? DBMS provider systematic way to access update and delete data.
File system is used for storing the unstructured data. DBMS is used for storing the structured data.



 

Conclusion-


These were some of the point discussed in the post- File System and Difference between DBMS and File System.

There is more coming with the next post keep reading...

Post a Comment

0 Comments