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

Data files indices and data dictionary, The indices are accumulated in the ...

The indices are accumulated in the index files. The data is accumulated in the data files. Indices give fast access to data items. For example, a book database may be managed in th

Descrine an data dictionary, Describe an data dictionary? A data dictio...

Describe an data dictionary? A data dictionary is a data structure which keeps meta data about the structure of the database ie. the schema of the database.

What does data dictionary is a special file contains, What does data dictio...

What does data dictionary is a special file contains ? The data dictionary is a special file contain The name of all fields in all files.The width of all fields in all files an

Security-data fragmentation, Security: Data not needed by local applicatio...

Security: Data not needed by local applications is not stored at the site, therefore no unnecessary security violations may exist. But how can we carry out fragmentation? Fragm

Define forms based interfaces, Define Forms Based Interfaces? Forms-Bas...

Define Forms Based Interfaces? Forms-Based Interfaces - A forms-based interface display a form to each user. Forms are commonly designed and programmed for naive users and inte

What is the meaning of redundant associations, Adding Redundant Association...

Adding Redundant Associations for Efficient Access The expression redundant association means using "duplicate association for proficient access". While analysis, it is not a

Create a database for store company details, You group has been hired by  T...

You group has been hired by  TrainingrUs.com to keeps track of training revenues. TrainingrUS.com wants you to keep scheduling. COURSE table contains following information:

Functional dependencies and normalization for relational dat, Consider the ...

Consider the 1ollowin8 relation: CAR SALE (Car_id, Option_type, Option_listprice, Sale_date, Option_discountedprice) This relation refers to options installed in cars (e.g., crui

Binary relationships, One-to-one relationship: For every 1:1 relationshi...

One-to-one relationship: For every 1:1 relationship type R in the ER diagram including two entities E1 and E2 we take one of entities (say E1) preferably with total participatio

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