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

Define weak and strong entity sets, Define weak and strong entity sets?  ...

Define weak and strong entity sets?  Weak entity  set:  entity  set  that  do not  have  key  attribute  of  their  own are  known as weak entity sets.  Strong entity set

E-r model uses this symbol to represent weak entity set, E-R model uses thi...

E-R model uses this symbol to represent weak entity set ? A Doubly outlined rectangle symbol is used to represent weak entity set.

RDM & ER Modelling, #questiRegional Gardens has many nurseries, including W...

#questiRegional Gardens has many nurseries, including Wagga Wagga, Bathurst, Albury, Orange, and Dubbo. Each nursery is known by its campus code, eg WW, B, A, O and D respectively.

Access data using logical database, If one requires to access data using...

If one requires to access data using Logical Database , the use of events is unavoidable. Yes, if someone wants to access data using Logical database then the use of events

Relation and relational schema, A relation has: Relational Schema ...

A relation has: Relational Schema Relation instance Relational Schema: A relational schema shows the relation's name, its attributes and the domain of every a

Explain the integrity constraints, Explain the integrity constraints: Not N...

Explain the integrity constraints: Not Null,  Unique, Primary Key with an example each. Is the combination 'Not Null, Primary Key' a valid combination. Justify. Not Null - Shou

What are the benefits of decomposing a system, What are the benefits of dec...

What are the benefits of decomposing a system? The benefits of decomposing a system into subsystems are that after decomposition, each individual component become smaller and e

Explain how the binary tree, QUESTION (a) Give two advantages of using ...

QUESTION (a) Give two advantages of using Linked List as compared to arrays. (b) (i) You are working as programmer at the Orange Mauritius branch. You have been asked to cre

Heap files (unordered file), Heap files (unordered file) Mostly these f...

Heap files (unordered file) Mostly these files are unordered files. It is the easiest and most basic type. These files having of randomly ordered records. The records will have

Select statement-data manipulation language, SELECT Statement This stat...

SELECT Statement This statement is used for retrieving information from the databases. It can be coupled with many clauses. Let us talk about these clauses in more detail:

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