Prerequisite – DBMS over File system
1. File System :
File system is basically a way of arranging the files in a storage medium like hard disk. File system organizes the files and helps in retrieval of files when they are required. File systems consists of different files which are grouped into directories. The directories further contain other folders and files. File system performs basic operations like management, file naming, giving access rules etc.
NTFS(New Technology File System), EXT(Extended File System).
2. DBMS(Database Management System) :
Database Management System is basically a software that manages the collection of related data. It is used for storing data and retrieving the data effectively when it is needed. It also provides proper security measures for protecting the data from unauthorized access. In Database Management System the data can be fetched by SQL queries and relational algebra. It also provides mechanisms for data recovery and data backup.
Oracle, MySQL, MS SQL server.
Difference between File System and DBMS :
|1.||File system is a software that manages and organizes the files in a storage medium within a computer.||DBMS is a software for managing the database.|
|2.||Redundant data can be present in a file system.||In DBMS there is no redundant data.|
|3.||It doesn’t provide backup and recovery of data if it is lost.||It provides backup and recovery of data even if it is lost.|
|4.||There is no efficient query processing in file system.||Efficient query processing is there in DBMS.|
|5.||There is less data consistency in file system.||There is more data consistency because of the process of normalization.|
|6.||It is less complex as compared to DBMS.||It has more complexity in handling as compared to file system.|
|7.||File systems provide less security in comparison to DBMS.||DBMS has more security mechanisms as compared to file system.|
|8.||It is less expensive than DBMS.||It has a comparatively higher cost than a file system.|
Attention reader! Don’t stop learning now. Get hold of all the important CS Theory concepts for SDE interviews with the CS Theory Course at a student-friendly price and become industry ready.
- Difference between Local File System (LFS) and Distributed File System (DFS)
- Advantages of DBMS over File system
- Difference between File Transfer Protocol (FTP) and Secure File Transfer Protocol (SFTP)
- Difference between SVG file and PNG file
- Difference between FAT32, exFAT, and NTFS File System
- Difference between Management Information System (MIS) and Decision Support System (DSS)
- Difference between Open-Loop Control System and Closed-Loop Control System
- File Organization in DBMS | Set 2
- File Organization in DBMS | Set 1
- File Organization in DBMS | Set 3
- Difference between OLAP and OLTP in DBMS
- Difference between Row oriented and Column oriented data stores in DBMS
- Difference between RDBMS and DBMS
- Difference between 1NF and 2NF in DBMS
- Difference between DDL and DML in DBMS
- Main difference between Timestamp protocol and Thomos write rule in DBMS
- Difference between Trigger and Procedure in DBMS
- Difference between E-R Model and Relational Model in DBMS
- Difference between 2NF and 3NF in DBMS
- Difference between 3NF and BCNF in DBMS
If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to email@example.com. See your article appearing on the GeeksforGeeks main page and help other Geeks.
Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.
Improved By : brillianttyagi