• Skip to main content
  • Skip to primary sidebar
  • Skip to secondary sidebar
  • Skip to footer

Computer Notes

Library
    • Computer Fundamental
    • Computer Memory
    • DBMS Tutorial
    • Operating System
    • Computer Networking
    • C Programming
    • C++ Programming
    • Java Programming
    • C# Programming
    • SQL Tutorial
    • Management Tutorial
    • Computer Graphics
    • Compiler Design
    • Style Sheet
    • JavaScript Tutorial
    • Html Tutorial
    • Wordpress Tutorial
    • Python Tutorial
    • PHP Tutorial
    • JSP Tutorial
    • AngularJS Tutorial
    • Data Structures
    • E Commerce Tutorial
    • Visual Basic
    • Structs2 Tutorial
    • Digital Electronics
    • Internet Terms
    • Servlet Tutorial
    • Software Engineering
    • Interviews Questions
    • Basic Terms
    • Troubleshooting
Menu

Header Right

Home » Fundamental » database » Advantages of Database
Next →
← Prev

Advantages of Database

By Dinesh Thakur

There are four basic components of Database Management System:

(i) Data: Raw facts which we want to feed in the computer.

(ii) Hardware: On which the data to be processed.

(iii) Software: The interface between the hardware and user, by which the data   will change into the information.

(iv) User: There are so many types of users some of them are application programmer, end case users and DBA.

Purpose of Database Systems:

(i) To see why database management systems are necessary, let’s look at a typical “

File-Processing System” supported by a conventional operating system.

The application is a savings bank:

• Savings account and customer records are kept in permanent system files.

• Application programs are written to manipulate files to perform the following tasks:

Debit or credit an account.

Add a new account.

Find an account balance.

Generate monthly statements.

(ii) Development of the System proceeds as follows:

• New application programs must be written as the need arises.

• New permanent files are created as required.

• But over a long period of time files may be in different formats, and

• Application programs may be in different languages.

(iii) So we can see there are problems with the Straight File-Processing Approach:

• Data Redundancy and Inconsistency:

Same information may be duplicated in several places.

All copies may not be updated properly.

• Difficulty in Accessing Data :

May have to write a new application program to satisfy an unusual request.

E.g. find all customers with the same postal code.

Could generate this data manually, but a long job.

• Data Isolation :

Data in different files.

Data in different formats.

Difficult to write new application programs.

• Multiple Users :

Want concurrency for faster response time.

Need protection for concurrent updates.

E.g. two customers withdrawing funds from the same account at the same time – account has $500 in it, and they withdraw $100 and $50. The result could be $350, $400 or $450 if no protection.

• Security Problems :

Every user of the system should be able to access only the data they are permitted to see.

E.g. payroll people only handle employee records, and cannot see customer accounts; tellers only access account data and cannot see payroll data.

Difficult to enforce this with application programs.

• Integrity Problems :

Data may be required to satisfy constraints.

E.g. no account balance below $25.00.

Again, difficult to enforce or to change constraints with the file-processing approach.

Above all problems lead to the development of Database Management Systems.

Advantages:

• An organized and comprehensiveness of recording the result of the firms activities.

• A receiver of data to be used in meeting the information requirement of the MIS users.

• Reduced data redundancy.

• Reduced updating errors and increased consistency.

• Greater data integrity and independence from applications programs.

• Improved data access to users through use of host and query languages.

• Improved data security.

• Reduced data entry, storage, and retrieval costs.

• Facilitated development of new applications program.

• Standard can be enforced: Standardized stored data format is particularly desirable as an old data to interchange or migration (change) between the system.

• Conflicting requirement can be handled.

Disadvantages :

• It increases opportunity for person or groups outside the organization to gain access to information about the firms operation.

• It increases opportunity for fully training person within the organization to misuse the data resources intentionally.

• The data approach is a costly due to higher H/W and S/W requirements.

• Database systems are complex (due to data independence), difficult, and time-consuming to design.

• It is not maintain for all organizations .It is only efficient for particularly large organizations.

• Damage to database affects virtually all applications programs.

• Extensive conversion costs in moving form a file-based system to a database system.

• Initial training required for all programmers and users.

You’ll also like:

  1. What are the Advantages and Disadvantages of Distributed Database Management System?
  2. What is Object Oriented Database (OODB)? Advantages and Disadvantages of OODBMSS.
  3. What is Object-Relational Database Systems? Advantages and Disadvantages of ORDBMSS.
  4. What is Fragmentation in Database? Advantages & Disadvantages of fragmentation.
  5. What is Distributed Database? Characteristics of Distributed Database Management System.
Next →
← Prev
Like/Subscribe us for latest updates     

About Dinesh Thakur
Dinesh ThakurDinesh Thakur holds an B.C.A, MCDBA, MCSD certifications. Dinesh authors the hugely popular Computer Notes blog. Where he writes how-to guides around Computer fundamental , computer software, Computer programming, and web apps.

Dinesh Thakur is a Freelance Writer who helps different clients from all over the globe. Dinesh has written over 500+ blogs, 30+ eBooks, and 10000+ Posts for all types of clients.


For any type of query or something that you think is missing, please feel free to Contact us.


Primary Sidebar

DBMS

Database Management System

    • DBMS - Home
    • DBMS - Definition
    • DBMS - What is
    • DBMS - Entity Sets
    • DBMS - Components
    • DBMS - Languages
    • DBMS - Normalization
    • DBMS - Data Models
    • DBMS - Processing System
    • DBMS - Advantages
    • DBMS - ER-Model
    • DBMS - Functional Dependence
    • DBMS - Relational Model
    • DBMS - Architecture
    • DBMS - Network Model
    • DBMS - Approach
    • DBMS - Data Independence
    • DBMS - Relational Schema
    • DBMS - Instance
    • DBMS - Functions and Service
    • DBMS - Server
    • DBMS - DBA
    • DBMS - Instance & Schemas
    • DBMS - System Type
    • DBMS - DDL, DML and DCL
    • DBMS - Users
    • DBMS - Model
    • DBMS - System Structure
    • DBMS - Role of DBA
    • DBMS - Metadata
    • DBMS - ER-Diagram
    • DBMS - E-R Model Problems
    • DBMS - DBMS Vs.RDBMS
    • DBMS - Basic Construction of E-R
    • DBMS - E-R Notation
    • DBMS - Database View
    • DBMS - Concurrency Control
    • DBMS - Schema
    • DBMS - Procedure for Access
    • DBMS - Object
    • DBMS - dBase
    • DBMS - Relational Algebra
    • DBMS - Deadlock
    • DBMS - Relational Database
    • DBMS - Query
    • DBMS - Schema

DBMS Normal Forms

    • Database - CODD’S Rules
    • Database - 1NF
    • Database - 2NF
    • Database - 3NF
    • Database - 4NF
    • Database - 5NF
    • Database - BCNF

Advance Database

    • Database - File Organization
    • Database - Type Lock
    • Database - Transaction
    • Database - Key Type
    • Database - Relational Algebra
    • Database - Components
    • Database - Deadlock Detect
    • Database - Design Methodology
    • Database - Relational Operators
    • Database - Relational Calculus
    • Database - Lock Granularity
    • Database - Deadlocks Handling
    • Database - Concurrent Control
    • Database - Denormalization
    • Database - Starvation
    • Database - OODB
    • Database - Data Warehouse
    • Database - Fragmentation
    • Database - Data Replication
    • Database - Distributed
    • Database - Transparences
    • Database - ORDBMSS
    • Database - Data Mining
    • Database - Security
    • Database - DBTG
    • Database - OLAP
    • Database - Integrity
    • Database - Data Encryption
    • Database - Recover
    • Database - Data Protection

Some Other Advance Articls

  • Adv of Distributed DBMS
  • Homogeneous and Heterogeneous
  • Causes for Database Failure
  • DBMS Architecture
  • Features for Any DBMS
  • OLTP Systems Vs Data Warehousing
  • Data Warehousing Architecture

Other Links

  • DBMS - PDF Version

Footer

Basic Course

  • Computer Fundamental
  • Computer Networking
  • Operating System
  • Database System
  • Computer Graphics
  • Management System
  • Software Engineering
  • Digital Electronics
  • Electronic Commerce
  • Compiler Design
  • Troubleshooting

Programming

  • Java Programming
  • Structured Query (SQL)
  • C Programming
  • C++ Programming
  • Visual Basic
  • Data Structures
  • Struts 2
  • Java Servlet
  • C# Programming
  • Basic Terms
  • Interviews

World Wide Web

  • Internet
  • Java Script
  • HTML Language
  • Cascading Style Sheet
  • Java Server Pages
  • Wordpress
  • PHP
  • Python Tutorial
  • AngularJS
  • Troubleshooting

 About Us |  Contact Us |  FAQ

Dinesh Thakur is a Technology Columinist and founder of Computer Notes.

Copyright © 2023. All Rights Reserved.