The database must include concurrency control software to ensure that several users trying to update the same data at the same time, it should maintain in a controlled manner. In the file system approach, many programmers will be creating files over a long period and various files have a different format, in various application languages.
Therefore there is the possibility of information getting duplicated, this redundancy in storing the same data multiple times leads to higher costs and wastage of space. This may result in data inconsistency in the application, this is because the update is done to some of the files only and not all the files.
Moreover, in-database approach, multiple views can be created. The view is a tailored representation of information contained in one or more tables. A multi-user database whose users have a variety of applications must provide facilities for defining multiple views. In the traditional file system, if any changes are made to the structure of the files if will affect all the programs, so changes to the structure of a file may require changing of all programs that access the file.
But in the case of the database approach the structure of the database is stored separately in the system catalogue from the access of the application programs. This property is known as program-data independence. The database can be used to provide persistent storage for program objects and data structures that resulted in an object-oriented database approach. Traditional systems suffered from impedance mismatch problems and difficulty in accessing the data, which is avoided in object-oriented database systems.
The database also provides facilities for recovering hardware and software failures. 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.
In the past, many organizations exclusively used file processing systems to store and manage data. Many of these systems, however, have two major weaknesses: they have redundant data and they isolate data. Thus, the same fields are stored in multiple files. 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. What is the difference between file based approach and database approach? Category: technology and computing databases. File based approach Each program defines,manages and maintains its own data.
Database approach Shared collection of logically related data which can be shared among application. What are the advantages file processing system? Advantage of File -oriented system :. What are the advantages of database approach?
What is file processing system with example? What are five main functions of a database administrator? The Key Responsibilities of a Database Administrator. Software installation and Maintenance. What is file processing system and its disadvantages?
What are the main differences between a file processing system and a database management system? What is a process in database?
What do you mean by database? What are the types of database approach? What are the characteristics of database approach? What are the different database approach? What is the main purpose of a database? What are the 4 types of database? What do you mean by normalization? What is the file based approach? Traditional file - based approach.
What is file oriented approach? What are the benefits of using queries? Benefits of Using Queries. Send messages to a subset of the database.
0コメント