Summary: Difference Between File Processing System and Database Approach is that in the past, many organizations exclusively used file processing systems to store and manage data. In a typical file processing system, each department or area within an organization has its own set of files. The records in one file may not relate to the records in any other file. Organizations have
used file processing systems for many years. While When an organization uses the database approach, many programs and users share the data in the database. A school’s database most likely at a minimum contains data about students, instructors, schedule of classes, and student schedules. File Processing SystemIn the past, many organizations exclusively used file processing systems to store and manage data. In a typical file processing system, each department or area within an organization has its own set of files. The records in one file may not relate to the records in any other file. Organizations have used file processing systems for many years. Many of these systems, however, have two major weaknesses: they have redundant data and they isolate data. 1: Data Redundancy – Each department or area in an organization has its own files in a file processing system. Thus, the same fields are stored in multiple files. If a file processing system is used at a school, for example, the Student file and the Student Schedule file both might store the same students’ names and addresses. Duplicating data in this manner wastes resources such as storage space and people’s time. When new students are added or student data is modified, file maintenance tasks consume additional time because people must update multiple files that contain the same data. Data redundancy also can increase the chance of errors. If a student changes his or her address, for example, the school must update the address wherever it appears. If the Address field is not changed in all the files where it is stored, then discrepancies among the files exist. 2: Isolated Data – Often it is difficult to access data stored in separate files in different departments. Sharing data from multiple, separate files is a complicated procedure and usually requires the experience of a computer programmer. Database ApproachWhen an organization uses the database approach, many programs and users share the data in the database. A school’s database most likely at a minimum contains data about students, instructors, schedule of classes, and student schedules. As shown in the above image, various areas within the school share and interact with the data in this database. The database does secure its data, however, so that only authorized users can access certain data items. While a user is working with the database, the DBMS resides in the memory of the computer. The database approach addresses many of the weaknesses associated with file processing systems. The following list presents some strengths of the database approach.
Also Read: Difference Between File Processing System and DBMS Difference Between File and Database Difference Between Database and DBMS Differences Between Fields and Records in a Database Difference Between Database and Schema You may also likeWhat is the difference between traditional and database approach?Therefore in traditional file processing every user will be defining their own constraints and implement the files needed for the applications. In database approach, a single repository of data is maintained that is defined once and then accessed by many users.
What is the difference between DBMS and traditional file system?The file system is software that manages and organizes the files in a storage medium within a computer. DBMS is software for managing the database. Redundant data can be present in a file system. In DBMS there is no redundant data.
What is the difference between file processing approach and database approach?The key difference between filesystem and database is that filesystem manages only the physical access while database manages both the physical and logical access to the data. Database and File System are two methods that help to store, retrieve, manage and manipulate data.
What is the difference between a file and a database?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 (depending on application). On the other hand, a file system is a more unstructured data store for storing arbitrary, probably unrelated data.
|