DBMS Benefits, Characteristics, Adv & Disadv

 

DBMS Benefits

  • Improved strategic use of corporate data
  • Reduced complexity of the organization’s information systems environment
  • Reduced data redundancy and inconsistency
  • Enhanced data integrity
  • Application-data independence
  • Improved security
  • Reduced application development and maintenance costs
  • Improved flexibility of information systems
  • Increased access and availability of data and information
  • Logical & Physical data independence
  • Concurrent access anomalies.
  • Facilitate atomicity problem.
  • Provides central control on the system through DBA.

 

Characteristics of DBMS

• Represents complex relationship between data

• Controls data redundancy.

• Enforces user defined rules.

• Ensures data sharing.

• It has automatic and intelligent backup and recovery procedures.

• It has central dictionary to store information.

• Pertaining to data and its manipulation.

• It has different interfaces via which user can manipulate the data.

• Enforces data access authorization.

 

ADVANTAGES OF DBMS

  1. Redundancy control: centralized control of data be DBA avoids unnecessary duplication of data and effectively reduces the total amount of data storage required Controlling redundancy in data storage and independent and maintained efforts insure that information is not repeated many times at many places but stored in single copy which save cost and space and avoiding multiple updating in case a data item is need to be exchanged.
  2. Access control: DBA uses security and authorization around restriction a DBA has full control on who can use the data in what ways.
  3. Persistent for program object and data structure: The object stored in data base survive the termination of program execution and can later be retrieve the data remains in the data base even after it has been used many time by users.
  4. Multi-user Interface: DBMS provide multi user interface may be implemented in any of the programming language have compatibility with data base.
  5. Complex Relationship Representation: any amount of complexity in the relationship of given data item can be concisely represented by the database capability to retrieve and update data easily and effacingly
  6. Integrity constraint enforcement: DBMS have capability for defying ad enforcing constraint that must be satisfied by the data entering by the system and used by to process
  7. Backup and Recovery: A DBMS is a subject to failure due to many reasons DBMS provide facility for recovering from such software ad hardware failure
  8. Data Sharing: since data is stored a single copy many user can use the same without the need of having separate data for each user. DBMS provide such facility.
  9. Standard Enforcement: A no of international standard may be enforced in the certain and operation of data base.
  10. Flexibility to change data structure: due to data abstraction data structure of data base can be modified without distrusting the data base users.
  11. Reduced application development time: the effort required to develop user utility reduces considerably and so does the time
  12. Availability of update information: the data base always has latest state providing each user with the up to date information all the time.

 

DISADVANTAGES OF DBMS

  1. Cost: the data base system is a combination of h/w and s/w and training intensive and calls for a large cost is not justified for a particular situation it is advisable to look for a cheaper alternative.
  2. DBMS are very general in nature if the solution are required for a very specific purpose it is better to have non- DBMS system.
  3. Overhead on processor: generally a lot of overhead is involved in a DBMS many of these feature may not be required in a particular situation.
  4. In real time system where processing time critical it may not be suitable. The time overhead may be un acceptable in such case.

 

 

 

Registration


A password will be e-mailed to you.

Feedback Form

Name (required)

Email (required)

Feedback