What are the drawbacks of file oriented system in details, Database Management System

Assignment Help:

What are the drawbacks of File Oriented System in details?


Related Discussions:- What are the drawbacks of file oriented system in details

Type of views-data control, Type of views :  Simple views and Difficult ...

Type of views :  Simple views and Difficult Views Feature Simple Views Complex Views Number of tables One

Define the concept of generalization, Define the concept of generalization ...

Define the concept of generalization A generalization is relationship between specific kind of thing and general thing. It is also known as "is-a-kind-of" relationship. Inher

User error-database errors, User error :  This contains errors in the progr...

User error :  This contains errors in the program (e.g., Logical errors) with errors made by online users of database.  These types of errors can be avoided by applying some check

What is data independence, What is data independence? Data Independenc...

What is data independence? Data Independence: Techniques which permit data to be changed without affecting the applications in which procedure it. There are two types of data

Define deadlock detection, Define Deadlock detection If a system does ...

Define Deadlock detection If a system does not employ a few protocols that make sure deadlock freedom, after that a detection and recovery scheme should be used. An algorithm

Managing Data in Databases, Answer SQL Queries to extract data from data ta...

Answer SQL Queries to extract data from data tables and questions on mapping conceptual data models into relational data model.

Principles of good e-governance, Question: (a) e-Government implementa...

Question: (a) e-Government implementations normally evolve through a multi-stage process. Describe, using appropriate examples, the stages involved in an e-Government implemen

What is rigorous two phase locking protocol, Differentiate strict two phase...

Differentiate strict two phase locking protocol and rigorous two phase locking protocol. In strict two phase locking protocol all exclusive mode locks taken by a transaction is

Why were functional methods fashionable in early days, Why were functional ...

Why were functional methods fashionable in early days? These are inspired directly by computer architecture and thus popular among computer scientist in early days. The divisio

12/5/2013 4:16:59 AM

These are the disadvantages of File-Oriented System:


(i) Data redundancy and Inconsistency: Since files and application programs are formed by different programmers in excess of a long period of time, files are likely to be have different formats and the programs might be written in several programming languages. Moreover, same piece of information might be duplicated in several places. This unemployment leads to higher storage and access rate. In addition, it leads to data inconsistency such as the various copies of same data may no longer agree.

(ii) Difficulty in accessing data: the conventional file processing environments do not allow necessary data to be retrieved in convenient and efficient manner. Better data retrieval system has to be developed for general use.

(iii) Data isolation: Because data is scattered in a range of files, and files might be in different formats, it is tough to write new application programs to retrieve appropriate data.

(iv) Concurrent access anomalies: In order to improve overall performance of the system and obtain faster response time, many schemes allow multiple users to inform the data. In such an environment, interaction of parallel updates might result in inconsistent data.

(v) Security problems: Not every user of database system must be able to access all data. For example, in banking system, payroll personnel require only that part of the database that has information about various bank employees. They do not want access to information about the customer accounts. It is difficult to enforce security const rains.

(vi) Integrity problems: The data values stored in the database should satisfy certain types of consistency constraints. Such as the balance of a bank account may never fall below a prescribed amount. These constraints are forced in system by adding appropriate code in different application programs. When new restraints are added, it would difficult to change programs to implement them. The problem is compounded when constraints involve quite a few data items for dissimilar accounts.

(vii) Atomicity problem: A computer system like any other mechanical or electrical device is subject to failure. In many applications, it is vital to ensure that once a failure has occurred and has been detected, data will be restored to the consistent state existed prior to the failure.

 

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