Difference between file system and dbms(DBMS vs file system)


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