Limitations of file based system, Database Management System

Limitations of File Based System

The file-based system has some limitations. The limitations are listed as follows:

  • Isolation and separation of data: When the data is stored in separate files it becomes complex to access. It becomes very complex when the data has to be retrieved from more than two files as a large amount of data has to be looked for.
  • Duplication of data: Because of the decentralised approach, the file system varies to uncontrolled duplication of data. This is disagreeable as the duplication leads to wastage of a lot of storage space. It also money and cost times to enter the data more than once. For instance, the address information of student may have to be duplicated in bus list file data.
  • Inconsistent Data: The data in a file system can become inconsistent if more than one person changes the data simultaneously, for example, if any student changes the residence and the change is notified to only his/her file and not to bus list. Putting wrong data is also another reason for inconsistencies.
  • Data dependence: The physical structure and storage of data files and records are distinct in the application code. This means that it is very difficult to make changes to the existing structure. The programmer would have to recognize all the affected programs, change them and retest them. This characteristic of the File Based system is known as program data dependence.
  • Incompatible File Formats: As the structure of the files is embedded in application programs, the structure is fully dependent on application programming languages. Therefore the structure of a file generated by COBOL programming language may be quite dissimilar from a file generated by 'C' programming language. This incompatibility makes them hard to process together. The application developer may have to develop software to change the files to some common format for processing. Though, this may be time consuming and expensive.
  • Fixed Queries: File based systems are very much dependent on application programs. Any report or query needed by the organisation has to be developed by the application programmer. With type, the time, and number of queries or reports increases. Producing dissimilar types of queries or reports is not possible in File Based Systems. As a result, in some organisations the kind of queries or reports to be produced is fixed. No latest query or report of the data could be produced.

Besides the above, the maintenance of the File Based System is complex and there is no provision for security. Recovery is non-existent or inadequate.

Posted Date: 3/5/2013 4:28:59 AM | Location : United States







Related Discussions:- Limitations of file based system, Assignment Help, Ask Question on Limitations of file based system, Get Answer, Expert's Help, Limitations of file based system Discussions

Write discussion on Limitations of file based system
Your posts are moderated
Related Questions
Before we talk about the relational model in more detail, let us first define some very basic terms used in this model. Tuple Every row in a table shows a record and is cal

How can you map NULL values to other values while display? IF( ) , IFNULL( ) keywords are used to do so. They are 'LIMIT' is used for the following kinds of problems: 1) Ans

In a relation, tuples are not inserted in any definite order. Ordering of tuples is not defined as a part of a relation definition. Though, records may be structured later accordin

Illustrate the class diagram for class room scheduling system If in any college, the number of classrooms are limited which have to be allocated to various classes and instruct

You are required to write a report which evaluates two of the following issues in relation to your case study database: a. Security issues b. Performance issues c. Backup

1. Will you advise that your organization uses open source software and why? 2. Why is it important for business managers to have a basic understanding of the software development

The Second Normal Form (2NF) Definition: A relation is in 2NF if it is in 1NF and each non-key attribute is fully dependent on each candidate key of the relation. Some of th

Now that she understands more about the benefits of databases, the play-scheme manager would like to extend the play-scheme database to include data for schools and instructors as

Problem 1. Create a PL/SQL program to insert data into student table and display the details of the student having Reg.No 1010 Writing a PL/SQL program to Insert data

Sequential File Organisation The most necessary way to organise the collection of records in a file is to use sequential Organisation. Records of the file are stored in series