Limitations of file based system, Database Management System

Assignment Help:

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.


Related Discussions:- Limitations of file based system

What is the aim of object design, What is the aim of object design The ...

What is the aim of object design The aim of object design is to identify object which the system   contains and the interactions among them. The system implements specification

Construct an er diagram for a hospital, Construct an ER diagram for a hospi...

Construct an ER diagram for a hospital along with a set of patients and a set of medical doctors Associate with every patient a log of the several tests and examinations conducted.

Cases of constraint violations, (1)     Insert into PERSON Violated con...

(1)     Insert into PERSON Violated constraint: - Key constraint Reason: - Primary key 1 already exists in PERSON. Dealing: - DBMS could ask the user to provide valid PER

Define rule that value of foreign key appear in other table, Determine the ...

Determine the rule that a value of a foreign key should appear as a value of some particular table is called a  Ans: Referential constraint.    The rule that a value of a fo

Data Analysis, A buyer for a large department store chain must place orders...

A buyer for a large department store chain must place orders with an athletic shoe manufacturer six months prior to the time the shoes will be sold in the department stores. In par

What is the purpose of storage manager, What is the purpose of storage mana...

What is the purpose of storage manager? The storage manager is responsible for the following a) Interaction with the file manager b) Translation of DML commands in to low

Explain the attribute inheritance, Explain the Attribute inheritance An...

Explain the Attribute inheritance Ans: Throughout the rendering of the objects in a view, attribute sets of objects higher in the view hierarchy are inherited via objects below

What is oracle process explain for processes of oracle, What is Oracle Proc...

What is Oracle Process? Explain any four processes started by Oracle. Oracle Process is as follows: SMON: The System Monitor carries out a crash recovery while a crashed in

Create a technology web server, Database design Database tables will be...

Database design Database tables will be created for you on the Technology web server. The schema will be as follows. Please note that this is a simplified database structure, d

Explain the uses of deadlock, Explain the uses of deadlock It will lea...

Explain the uses of deadlock It will lead to deadlock since this is the only place where incoming acknowledgements are processed. Without this code, sender will keep timing ou

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd