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

Php optimization on iis 8, Project Description: We have purchased facebo...

Project Description: We have purchased facebook style chat software which we are using with our site. It is prepared in PHP but the rest of the site is developed asp.net. Iss

Need customer management program, Project Description: This is a Custome...

Project Description: This is a Customer Management project. Customer data is presented in a text file. The program can load this text data into its database columns. The data ma

Modelling and normalisation, Task Part A. Create an ERD from a business pro...

Task Part A. Create an ERD from a business problem. (50 marks) Read the following problem and complete the tasks listed below. THE ABS Blood Bank Australian Blood Services (ABS) i

What are the states of transaction, What are the states of transaction? ...

What are the states of transaction? The states of transaction are:- a) Active b) Partially committed c) Failed d) Aborted e )Committed   f) Terminated

Stock market, need requirement analysis for database management of stock ma...

need requirement analysis for database management of stock market

Explain superkey, Explain Superkey Ans: A superkey is described in the ...

Explain Superkey Ans: A superkey is described in the relational model of database organization like a set of attributes of a relation variable for which it holds that in all re

Datawarehouse Case studies, I have been given 8 differebt data warehouseing...

I have been given 8 differebt data warehouseing failure case studies. I need to question 4 questions for each

Describe physical data independence, Describe Physical Data independence ? ...

Describe Physical Data independence ? Physical Data Independence - It is capacity to modify the internal schema without having to change conceptual schema. Therefore, the exter

Dirty reads-problems of concurrent transactions, Dirty Reads: T10 reads a ...

Dirty Reads: T10 reads a value which is updated by T9. This update has not been committed and T9 aborts. T9 T10 Value of x old value = 200

Identify all renters who have viewed all properties, Consider the subsequen...

Consider the subsequent relations RENTER(rno, fname, lname, address, tel_no, pref_type, max_rent) VIEWING(rno, pno, date, comment) PROPERTY_FOR_RENT( pno, street, area ,city,

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