File processing or traditional file approach system definition & Problems
Traditional file processing system was used to manage information. It stores data in various files of different application programs to extract or insert data to appropriate file. This processing system has several drawbacks due to which database management system is required. A file is a collection of information that is used to organize and access information but in this, the information is allocated in an unstructured and non-relation manner so that there is some limitation as compared to the database. Database management system removes problems found in this processing system.
Some major problems of file processing system are:
- Data redundancy and inconsistency
- Difficulty in accessing data
- Data isolation
- Integrity problem
- Concurrent access problem
- Security problem
Data redundancy and inconsistency
In the file processing system, to store information we have to pay higher storage or various file. And there is more chance of repeating data. Then it may leads database in inconsistent state.
Difficulty in accessing data
In file processing system, we cannot easily access required data stored in particular file. For each new task we have to write a new application program.
Data are scatter in different files and data may store in different format. So it is difficult to write program to retrieve appropriate data.
Integrity problem refers to the inability to provide appropriate information. In the file processing system, to each data store may require different file or program and later it difficult to change or modify.
Concurrent access problem
Concurrent access increase to the overall performance of the system providing fast response time but uncontrolled concurrent accesses can lead inconsistencies in the system.
File processing consists large no. of application programs. So it is difficult to enforce security for each application to allow accessing only part of data for individual database users.
For offline read download PDF file below:
Introduction to PowerPoint