Difference between File
System and DBMS
File System Vs DBMS
File Management System (FMS) is a Data Management
System that allows access to single files or tables at a time.
FMS’s accommodate flat files that have no relation to other
files. The FMS was the predecessor for the Database
Management System (DBMS), which allows access to
multiple files or tables at a time.
A Database Management System (DMS) is a combination of
computer software, hardware, and information designed to
electronically manipulate data via computer processing.
12/31/2018 BBA 210 (Information system 2
Management)
File System Vs DBMS(contd..)
12/31/2018 BBA 210 (Information system 3
Management)
File System Vs DBMS(contd..)
12/31/2018 BBA 210 (Information system 4
Management)
File System Vs DBMS (contd..)
12/31/2018 BBA 210 (Information system 5
Management)
File System Vs DBMS (contd..)
12/31/2018 BBA 210 (Information system 6
Management)
Disadvantages of File Processing System
• Duplicate Data – As all files are independent of each other, so, duplicate
data may be present in more than one files.
• Inconsistency – Inconsistency means different copies of same data that are
not matching. Data may be inconsistent in file processing system.
• Poor Data Integrity – Data integrity refers to the overall completeness,
accuracy and consistency of data. But in Processing system, Poor data
integrity often develops.
• Data is isolated and separated – Data are separated in various files. So, if
it is needed to extract data from 2 different files, it will be require to
determine which parts of each of the files are needed and how files are
related to one another.
12/31/2018 BBA 210 (Information system 7
Management)
Disadvantages of File Processing System
• Application Programs are dependent on file formats – In processing
suystem, the physical formats of file are entered in application program that
process the files. Change in the file format result in program updates and a
change which is time consuming and error prone.
• Poor Data Security- Data is stored in different files causing the security
problems
• Difficult to represent complex object – Some data objects may be of
variable length which might produce difficulty in representation in file
12/31/2018 BBA 210 (Information system 8
Management)
12/31/2018 BBA 210 (Information system 9
Management)