What is the difference between a file processing system and a database system?

Answer 1

In file processing system a permanent system file is created for every new object. Application softwares are used to manipulate these files. SO characteristics (Some of them became its drawbacks) of file processing system are:-

1)Data redundancy and inconsistency

2)Difficulty in accessing data

3)Data isolation ie. data is in different formats and files.

In database system these issues where addressed, by data abstraction.

In DBMS, data is stored using 3 levels of abstraction

1)Physical Level : How data is stored

2)Conceptual level : What data is stored, relationship between data

3)View Level : What is visible to different users.

Answer 2

A file processing system manages data using individual files, without any inherent structure for organizing or querying data. A database system uses a structured approach to store, retrieve, and manage data in a centralized repository, providing features like data consistency, concurrency control, and query capabilities through a database management system (DBMS).