Difference Between File Processing System And Database system

The difference between file processing system and database approach is as follow:

File based system	Database system
1.    The data and program are inter- dependent.	1. The data and program are independent of each other.
2.    File-based system caused data redundancy. The data may be duplicated in different files	2. Database system control data redundancy. The data appeared only once in the system.
3.    File –based system caused data inconsistency. The data in different files may be different that cause data inconsistency.	3. In database system data always consistent. Because data appeared only once.
4.    The data cannot be shared because data is distributed in different files.	4. In database data is easily shared because data is stored at one place.
5.    In file based system data is widely spread. Due to this reason file based system provides poor security.	5. It provides many methods to maintain data security in the database.
6.    File based system does not provide consistency constrains.	6. Database system provides a different consistency constrains to maintain data integrity in the system.
7.    File based system is less complex system.	7. Database system is very complex system.
8.    The cost of file processing system is less then database system.	8. The cost of database system is much more than a file processing system.
9.    File based system takes much space in the system, and memory is wasted in this approach.	9. Database approach store data more efficiently it takes less space in the system and memory is not wasted.
10.  To generate different report to take a crucial decision is very difficult in file based system.	10. The report can be generated very easily in required format in database system. Because data in database is stored in an organized manner. And easily retrieve to generate different report.
11.  File based system does not provide concurrency facility.	11. Database system provides concurrency facility.
12.  File based system does not provide data atomicity functionality.	12. Database system provides data atomicity functionality.
13.  The cost of file processing system is less than database system.	13. The cost of database system is more than file processing system.
14.  It is difficult to maintain as it provides less controlling facility.	14. Database provides many facility to maintain program.
15.  If one application fail it does not affects other files in system.	15. If database fail it affects all application that dependent on database
16.  Hardware cost is less than database system	16. Hardware cost is high in database than file system.