Differences between a file processing system and a DBMS:
|
File
processing system
|
DBMS
|
|
(i)
A file system is a more unstructured data store for storing arbitrary
probably unrelated data.
|
(i)
A database is generally used for storing related, structured data, with well
defined data formats, in an efficient manner for insert, update and / or
retrieval.
|
|
(ii)
A file processing system coordinates only the physical access to the data.
|
(ii)
A database management system coordinates both the physical and the logical
access to the data.
|
|
(iii)
False data cannot remove.
|
(iii)
False data can be removed easily.
|
|
(iv)
A file processing system is designed to allow predetermined access to data
(i.e. compiled programs).
|
(iv)
A database management system is designed to allow flexible access to data (i.
e. queries).
|
|
(v)
Unauthorized access cannot be restricted in file processing system.
|
(v)
Unauthorized access is restricted in DBMS.
|
|
(vi)
Redundancy cannot be controlled in file processing system.
|
(vi)
Redundancy can be controlled in DBMS.
|
|
(vii)
All data is not considerable to make a report.
|
(vii)
Report can be produced considering all data.
|
|
(viii)
Security problem arises.
|
(viii)
Database can be secured using password.
|
No comments:
Post a Comment