“File System Vs Database Management System (DBMS)…”
What is a File System?
A File System defines how & where files are stored and how they are named. (A file system is a process that manages how and where data on a storage disk.) The most important purpose of a file system is to manage user data. This includes storing, retrieving and updating data. Some file systems accept data for storage as a stream of bytes which are collected and stored in a manner efficient for the media.
Examples :- FAT , FAT32 , NTFS
What is a Database Management System?
A database management system (DBMS) is system software for creating and managing databases. A DBMS makes it possible for end users to
· Create
· Protect
· Read
· update and
· delete
data in a database.
Examples :- MySQL, PostgreSQL, Microsoft Access, SQL Server, FileMaker, Oracle, RDBMS, Clipper, FoxPro
File System Vs Database Management System (DBMS)
File System :-
o Definition :- How & where files are stored and how they are named.
o User Access :- Only one user can access data at a time.
o Data Independence :- There is no data independence.
o Backup and Recovery :- It doesn’t provide backup and recovery of data if it is lost.
o Sharing :- Data is distributed in many files. So not easy to share data.
o Consistency :- There is less data consistency in the file system.
o Data Abstraction :- It gives details of storage and representation of data.
o Security Constraints :- Less security
o Cost :- Less expensive
o Example :- FAT , FAT32 , NTFS
Database Management System (DBMS) :-
o Definition :- Software system that allows the access to the data contained in a database.
o User Access :- Multiple users can access data at a time.
o Data Independence :- In DBMS data independence exists.
o Backup and Recovery :- It provides backup and recovery of data even if it is lost.
o Sharing :- Due to centralized nature sharing is easy.
o Consistency :- There is more data consistency because of the process of normalization.
o Data Abstraction :- It hides the internal details of Database.
o Security Constraints :- More security mechanisms.
o Cost :- comparatively higher cost
o Example :- MySQL, PostgreSQL, Microsoft Access, SQL Server, FileMaker
