Difference between DBMS and file system

Share this

Hello friends, today I tell you the difference between DBMS and file system, so let’s see what is the difference between DBMS and file system.

Difference between DBMS and File Management system

DBMS

File System

1. A DBMS is a collection of data. It does not require users to write procedures.

1. A file system is also a collection of data. In this, users need to write procedures.

2. It is a system software that creates and manages databases.

2. It is a software that manages data files in a computer system.

3. The DBMS provides abstract view of the data. Due to which the details are hidden.

3. It provides details of data representation and storage of data.

4. The DBMS provides a crash recovery mechanism ie it protects the user from system failure.

4. It does not have a crash recovery mechanism. That is, if the system crashes while storing some data, the data in the file will be lost.

5. It is very easy to update, select and search the data because SQL query is used in it.

5. In this, the functions of store, search, retrieve etc. are done manually so it is difficult to manage the data in it.

6. It provides high data consistency. For this, normalization is used in it.

6. There is data inconsistency.

7. The duplicate data in d.b.m.s is very low, ie it has very little data redundancy.

7. Data redundancy in the file system is very high.

8. In this, the data is more secure.

8. The data in this is much less secure.

9. The backup and recovery process in dbms is very difficult

9. The backup and recovery process in the file system is easy.

10. It is suitable for multiple users.

10. It is suitable for single user.

11. Examples: – MySQL, MSSQL, Oracle, DB2 etc.

11. Example: – NTFS, Ext etc.

Also read:-


Share this

17 thoughts on “Difference between DBMS and file system”

  1. Today, I went to the beachfront with my children. I found a sea
    shell and gave it to my 4 year old daughter and said “You can hear the ocean if you put this to your ear.” She placed the shell to
    her ear and screamed. There was a hermit crab inside and it pinched her ear.

    She never wants to go back! LoL I know this is entirely off topic but I had to tell someone!

  2. Excellent post. Ӏ wаs checking сonstantly this weblog аnd І am inspired!
    Verʏ usеful іnformation specіfically the final phase :
    ) Ӏ handle sᥙch infoгmation a lot. I usеd to be seeking thiѕ particular information for a ѵery long time.
    Thаnks and good luck.

  3. Hey, I think your website might be having browser compatibility issues.
    When I look at your blog in Ie, it looks fine but when opening in Internet Explorer,
    it has some overlapping. I just wanted to give you a quick heads up!
    Other then that, great blog!

  4. hello there and thank you for your information – I’ve certainly picked up something new from right here.
    I did however expertise some technical issues using this web
    site, since I experienced to reload the website a lot of times previous to I could get it to load properly.

    I had been wondering if your web host is OK?
    Not that I am complaining, but slow loading instances times will
    often affect your placement in google and can damage your quality score if ads and marketing with Adwords.
    Anyway I am adding this RSS to my e-mail and can look out for a lot more of your
    respective fascinating content. Make sure you update this again soon.

  5. My family members aⅼl thе timе ѕay that Ι am killing mу time here at web, hoѡever
    I know I am ɡetting familiarity all tһe time bу reading thes pleasant contеnt.

Leave a Reply

Your email address will not be published. Required fields are marked *