Difference between File System and DBMS
Prerequisite – DBMS over the File system
File System :
The file system is basically a way of arranging the files in a storage medium like a hard disk. The file system organizes the files and helps in the retrieval of files when they are required. File systems consist of different files which are grouped into directories. The directories further contain other folders and files. The file system performs basic operations like management, file naming, giving access rules, etc.
Example: NTFS(New Technology File System), EXT(Extended File System).
DBMS(Database Management System) :
Database Management System is basically 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:
|Structure||The file system is software that manages and organizes the files in a storage medium within a computer.||DBMS is software for managing the database.|
|Data Redundancy||Redundant data can be present in a file system.||In DBMS there is no redundant data.|
|Backup and Recovery||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.|
|Query processing||There is no efficient query processing in the file system.||Efficient query processing is there in DBMS.|
|Consistency||There is less data consistency in the file system.||There is more data consistency because of the process of normalization.|
|Complexity||It is less complex as compared to DBMS.||It has more complexity in handling as compared to the file system.|
|Security Constraints||File systems provide less security in comparison to DBMS.||DBMS has more security mechanisms as compared to file systems.|
|Cost||It is less expensive than DBMS.||It has a comparatively higher cost than a file system.|
|Data Independence||There is no data independence.||In DBMS data independence exists.|
|User Access||Only one user can access data at a time.||Multiple users can access data at a time.|
|Meaning||The user has to write procedures for managing databases||The user not required to write procedures.|
|Sharing||Data is distributed in many files. So, not easy to share data||Due to centralized nature sharing is easy|
|Data Abstraction||It give details of storage and representation of data||It hides the internal details of Database|
|Integrity Constraints||Integrity Constraints are difficult to implement||Integrity constraints are easy to implement|
|Example||Cobol, C++||Oracle, SQL Server|