Difference between file system and dbms(DBMS vs file system)
File system DBMS
File system is a collection of data. Any management with DBMS is a collection of data and user is not required
the file system, user has to write the procedures. to write the procedures for managing the database.
File system gives the details of the data representation DBMS provides an abstract view of data that hides
and Storage of data. the details.
DBMS is efficient to use since there are wide
In File system storing and retrieving of data cannot be
varieties of sophisticated techniques to store and
done efficiently.
retrieve the data.
Concurrent access to the data in the file system has
many problems like : Reading the file while other form of DBMS takes care of Concurrent access using some
locking. deleting some information, updating some form of locking.
information
File system doesn’t provide crash recovery mechanism.
DBMS has crash recovery mechanism, DBMS
Eg. While we are entering some data into the file if
protects user from the effects of system failures.
System crashes then content of the file is lost
Protecting a file under file system is very difficult. DBMS has a good protection mechanism.