DBMS Vs File Management System

S.no.	key point	DBMS	File System
1	Data Redundancy(Duplication of data)	DBMS has no presence of Redundant data.	In the File System, Redundant data is present.
2	Backup and Recovery	DBMS provides backup and crash recovery of data even if data is lost.	File Systems doesn’t provide backup and crash recovery of data when data is lost.
3	Query Processing	DBMS has efficient query processing.	File System has no efficient query processing.
4	Complexity	DBMS is more complex than file systems.	File System is less complex than DBMS.
5	Consistency	DBMS has high consistency due to the process of normalization.	The file system has less consistency compared to DBMS.
6	Security	DBMS provides high-security services to Users than normal File Systems.	File systems provide less security than DBMS.
7	Cost	DBMS is More Expensive than the File system.	File System is less expensive than DBMS.
8	User access	In DBMS, Multiple users can access the data at a single time.	In File System, Only one user can access data at a single time.
9	Data Independence	DBMS has data Independence.	In a File system, there is no data independence.
10	I/O Cost	DBMS creates an index on file to minimize I/O cost.	the file system has a higher I/O cost.
11	Data abstraction	DBMS hides the background details of the database and shows only an abstract view.	file system gives details of data storage and data representation.
12	Intergrity Constraints	Integrity constraints are easy to implement on DBMS.	Integrity Constraints are difficult to implement on file systems.
13	Data sharing	DBMS has a centralized approach, So data sharing is easy.	In the File system, data sharing is difficult because Files are distributed in different folders and different formats.
14	Example	Oracle, SQL Server.	Cobol , C++.

You might like this :-

○ ACID Properties in DBMS
○Codd's 12 Rules
○DBMS Introduction
○DBMS vs RDBMS

« Previous Next »