Difference between File System and
DBMS
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).
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.
Example:
Oracle, MySQL, MS SQL server.
DBMS
Difference between File System and DBMS
Basics File System DBMS
The file system is a way of
DBMS is software for managing
arranging the files in a storage
the database.
Structure medium within a computer.
Data Redundant data can be present in a In DBMS there is no redundant
Redundancy file system. data.
Basics File System DBMS
It doesn’t provide Inbuilt It provides in house tools for
Backup and mechanism for backup and recovery backup and recovery of data
Recovery of data if it is lost. even if it is lost.
Query There is no efficient query Efficient query processing is
processing processing in the file system. there in DBMS.
There is more data consistency
There is less data consistency in the
because of the process of
file system.
Consistency normalization.
It has more complexity in
It is less complex as compared to
handling as compared to the file
DBMS.
Complexity system.
DBMS has more security
File systems provide less security in
Security mechanisms as compared to file
comparison to DBMS.
Constraints systems.
It has a comparatively higher
It is less expensive than DBMS.
Cost cost than a file system.
In DBMS data independence
exists, mainly of two types:
There is no data independence.
Data 1) Logical Data Independence.
Independence 2)Physical Data Independence.
Only one user can access data at a Multiple users can access data at
User Access time. a time.
The users are not required to write The user has to write procedures
Meaning procedures. for managing databases
Data is distributed in many files. So, Due to centralized nature data
Sharing it is not easy to share data. sharing is easy
Basics File System DBMS
Data It give details of storage and It hides the internal details of
Abstraction representation of data Database
Integrity Integrity Constraints are difficult to Integrity constraints are easy to
Constraints implement implement
To access data in a file , user
requires attributes such as file name, No such attributes are required.
Attributes file location.
Example Cobol, C++ Oracle, SQL Server
The main difference between a file system and a DBMS (Database Management
System) is the way they organize and manage data.
1. File systems are used to manage files and directories, and provide basic operations for
creating, deleting, renaming, and accessing files. They typically store data in a
hierarchical structure, where files are organized in directories and subdirectories. File
systems are simple and efficient, but they lack the ability to manage complex data
relationships and ensure data consistency.
2. On the other hand, DBMS is a software system designed to manage large amounts of
structured data, and provide advanced operations for storing, retrieving, and
manipulating data. DBMS provides a centralized and organized way of storing data,
which can be accessed and modified by multiple users or applications. DBMS offers
advanced features like data validation, indexing, transactions, concurrency control,
and backup and recovery mechanisms. DBMS ensures data consistency, accuracy,
and integrity by enforcing data constraints, such as primary keys, foreign keys, and
data types.
In summary, file systems are suitable for managing small amounts of unstructured data,
while DBMS is designed for managing large amounts of structured data, and offers more
advanced features for ensuring data integrity, security, and performance.
