DBMS

Advantages of file-oriented system

Advantage and Disadvantages of File-oriented system are given below

Advantage of File-oriented system:

1. Backup:

  • It is possible to take faster and automatic back-up of database stored in files of computer-based systems.
  • computer systems provide functionalities to serve this purpose.it is also possible to develop specific application program for this purpose.

2. Compactness:

  • It is possible to store data compactly.

3. Data Retrieval:

  • Computer-based systems provide enhanced data retrieval techniques to retrieve data stored in files in easy and efficient way.

4. Editing:

  • It is easy to edit any information stored in computers in form of files.
  • Specific application programs or editing software can be used for this purpose.

5. Remote Access:

  • In computer-based systems,it is possible to access data remotely.
  • so,to access data it is not necessary for a user to remain present at location where these data are kept.

6. Sharing:

  • Data stored in files of computer-based systems ca be shared among multiple users at a same time.

Disadvantage of File-oriented system:

1. Data Redundancy:

  • It is possible that the same information may be duplicated in different files.this leads to data redundancy results in memory wastage.

2. Data Inconsistency:

  • Because of data redundancy,it is possible that data may not be in consistent state.

3. Difficulty in Accessing Data:

  • Accessing data is not convenient and efficient in file processing system.

4. Limited Data Sharing:

  • Data are scattered in various files.also different files may have different formats and these files may be stored in different folders may be of different departments.
  • So, due to this data isolation, it is difficult to share data among different applications.

5. Integrity Problems:

  • Data integrity means that the data contained in the database in both correct and consistent.for this purpose the data stored in database must satisfy correct and constraints.

6. Atomicity Problems:

  • Any operation on database must be atomic.
  • this means, it must happen in its entirely or not at all.

7. Concurrent Access Anomalies:

  • Multiple users are allowed to access data simultaneously.this is for the sake of better performance and faster response.

8. Security Problems:

  • Database should be accessible to users in limited way.
  • Each user should be allowed to access data concerning his requirements only.



Subscribe us on Youtube

Share This Page on

Questions


Emmanuel Geniz | 18-Sep-2017 11:49:19 pm

How how can l know database and my sql


Pooja | 08-Jan-2018 07:48:59 am

Plz give us full information about advantage and disadvantage with simple example


Deekshitha | 07-Feb-2018 06:27:26 pm

What is data mining in dbms


Jam Waseem Asim | 18-Feb-2018 09:37:31 pm

Data Collection of raw facts (we understand easily but computer is not understand) and figures is called data. Data may unprocessed form of raw facts. Data used as input in the computer. It is not meaningful. Data is huge in volume. 2 +3 =5 The above example 2 and 3 in unprocessed form of raw facts but 5 is information on the computer screen by the CPU.


zama | 04-Mar-2019 04:48:39 pm

discuss flaws in system data management including data redundancy


Ask Question