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

What is a database, What is a Database? To know what database is, we ha...

What is a Database? To know what database is, we have to start from data, which is the basic building block of any DBMS. Data: Facts, figures, statistics etc. having no pa

relationship with the owner entity, A database for the Service and Mainten...

A database for the Service and Maintenance (SM) section of a Computer sales and service Company has to be developed. SM gives after sales service to customers. SM branch has a numb

Clinic, Need a sample of a clinic database relationships

Need a sample of a clinic database relationships

Difference between sql and sql*plus, Difference between SQL and SQL*Plus ...

Difference between SQL and SQL*Plus SQL SQL*Plus SQL is a language SQL *Plus is an environment It   is   bas

Sql queries, find a name whose address is erode from student table

find a name whose address is erode from student table

What are the situations while dbms should not be used, What are the situati...

What are the situations while DBMS should not be used? DBMS should not be used in situations like: (i) No need of security. (ii) Not difficulty to access the data (iii) N

Group by clauses-data manipulation language, Group By clauses  • It is ...

Group By clauses  • It is used to group database tuples on the basis of definite common attribute value like as employees of a department. WHERE clause still can be used

What is system r, What is System R? What are its two major subsystems? ...

What is System R? What are its two major subsystems? System R was intended and developed over a period of 1974-79 at IBM San Jose Research Center. It is a prototype and its pur

Explain the acid properties of a transaction, Explain the ACID properties o...

Explain the ACID properties of a transaction Ans: ACID properties are a significant concept for databases. The ACID stands for Atomicity, Consistency, Isolation, and Durability

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