Difference Between File System and DBMS
Basics File System DBMS
The file system is a way
of arranging the files in a DBMS is software for
storage medium within a managing the database.
Structure computer.
Data Redundant data can be In DBMS there is no
Redundancy present in a file system. redundant data.
It doesn’t provide Inbuilt
It provides in house tools for
mechanism for backup
Backup and and recovery of data if it backup and recovery of data
even if it is lost.
Recovery is lost.
There is no efficient query
Query Efficient query processing is
processing in the file
there in DBMS.
processing system.
There is less data There is more data
consistency in the file consistency because of the
Consistency system. process of normalization .
It has more complexity in
It is less complex as
handling as compared to the
compared to DBMS.
Complexity file system.
File systems provide less DBMS has more security
Security security in comparison to mechanisms as compared to
Constraints DBMS. file systems.
It is less expensive than It has a comparatively higher
Cost DBMS. cost than a file system.
In DBMS data
independence exists, mainly
of two types:
There is no data
1) Logical Data
independence.
Independence .
Data 2)Physical Data
Independence Independence.
Basics File System DBMS
Only one user can access Multiple users can access
User Access data at a time. data at a time.
The users are not The user has to write
required to write procedures for managing
Meaning procedures. databases
Data is distributed in
Due to centralized nature
many files. So, it is not
data sharing is easy
Sharing easy to share data.
It give details of storage
Data It hides the internal details
and representation of
of Database
Abstraction data
Integrity Integrity Constraints are Integrity constraints are easy
Constraints difficult to implement to implement
To access data in a file ,
user requires attributes No such attributes are
such as file name, file required.
Attribute s location.
Example Cobol , C++ Oracle , SQL Server
