April 22, 2024

MentorWay

Ask Your MENTOR! AnyTime AnyWhere

What is Database? Advantages & Disadvantages of Database System

2 min read

Database System: A database is a collection of related information stored so that it is available to many users for different purposes. The content of the database is obtained by combining data from all the different sources in an organization. So that data are available to all users & redundant data can be eliminated or at least minimized.

Components of Database System

A database involves four major components

  1. Data

The data stored in the system is partitioned into one or more database.

 

  1. Hardware

The hardware consists of the secondary storage devices such as desks, drums etc on which the database resides.

 

  1. Software

Between the hardware & the users there is a layer of software, usually called the database management system or DBMS.

 

  1. Users

There are three classes of user

  1. Application Programmer
  2. End Users

Casual Users

Naïve Users

  1. Database Administrator

What is Database? Advantages & Disadvantages of Database System

 

Advantages of database/ Objectives of Database System

  1. Minimum Redundancy

Redundancy means duplication. The database system has minimal redundancy.

  1. Inconsistency to be avoided

This is actually part of a redundancy. In an organization, two entries have been made for one record say Roll No 201 is repeated two times. This will cause inconsistency if we update one & leave another.

  1. Sharing

Means all users have access to the same database.

  1. Privacy

Privacy generally determines the rights of individuals to access the data.

  1. Security

Database security may be defined as the protection of data against accidental or intentional disclosures.

  1. Integrated

By integrated we actually mean unification of several files into one file.

  1. Data Migration

The process of adjusting the storage of data to suit its popularity rating is called data migration.

 

Disadvantages of Database System

  1. High cost of DBMS
  2. High hardware cost because of additional memory & processing power.
  3. Conversion cost.
  4. Programming cost.
  5. Complex
  6. Backup & recovery are more difficult.
  7. Integration

Means failure on one component of an integrated system can stop the entire system.

Hope you liked this article. Keep visiting Mentor Way for more articles like this.

 

 

About Post Author