What are the advantages of dbms, Database Management System

Assignment Help:

What are the advantages of DBMS ?

1. Centralized Management and Control - One of the major advantages of using a database system is in which the organization could exert, through the DBA, centralized management and control over the data.

2. Reduction of Redundancies and Inconsistencies - Centralized control prevents unnecessary duplication of data and efficiently reduces the total amount of data storage needed. Removing redundancy eliminates inconsistencies.

3. Data Sharing - A database permits the sharing of data under its control through any number of application programs or users.

4. Data Integrity - Data integrity means in which the data holds in the database is both accurate and consistent. Centralized control could also ensure in which adequate checks are incorporated within the DBMS to gives data integrity.

5. Data Security - Data is of vital significance to an organization and may be confidential. Such secret data must not be accessed through unauthorized persons.

The DBA who has the ultimate responsibility for the data in the DBMS can ensure in which proper access process are followed. Different stages of security could be implemented for several kinds of data and operations.

6. Data Independence - Data independence is the capacity to modification the schema at one stage of a database system without having to modify the schema at the further level. It is commonly considered from two points of view: physical data independence and logical data independence. Physical data independence is the capacity to modify the internal schema without having to modify conceptual schema. Logical data independence is the capacity to change the conceptual schema without having to change external schemas or application programs.

7. Providing Storage Structures for Efficient Query Processing - Database systems gives capabilities for well executing queries and updates. Auxiliary files known as indexes are used for this reasons.

8. Backup and Recovery - These facilities are given to recover databases from hardware and/or software failures.


Related Discussions:- What are the advantages of dbms

Recovery techniques, Recovery Techniques: After Reading the types of failur...

Recovery Techniques: After Reading the types of failures and database errors, let us talk about how to recover from the failures. Recovery can be complete using/restoring the previ

Give the levels of data abstraction, Give the levels of data abstraction? ...

Give the levels of data abstraction? There are three levels of Data Abstraction a) Physical level b) logical level c) view level

Define deadlock term, a. Define the term "deadlock". There are four conditi...

a. Define the term "deadlock". There are four conditions that must hold before deadlock is possible. Name them. b. Outline an algorithm that detects whether there is a deadlock.

Describe different steps of object-oriented design process, Describe differ...

Describe different steps of the object-oriented design process.  The broad steps of the object-oriented design process are: a. Define context and modes of use of the system

Neo4j, I have one assignment that has to be done in neo4j

I have one assignment that has to be done in neo4j

What are the concurrency issues, Concurrency issues Data integrity...

Concurrency issues Data integrity: Threads accessing same object need to be synchronized, such as: banking account. Deadlock: One or more threads in system are perman

Normalization-e-r mapping , Normalize the following table upto and includin...

Normalize the following table upto and including the 3NF. Submit a 1 page printout of only the final set of normalized tables in Data Architect. Just use Data Architect to do the t

Higher normal forms, Higher Normal Forms Is there more normal forms beyond...

Higher Normal Forms Is there more normal forms beyond BCNF? Yes, though, these normal forms are not based on the concept of functional dependence. More normalisation is needed if

BOGUS VS GENUINE EMPOWERMENT, what is bogus empowerment. And what is genuin...

what is bogus empowerment. And what is genuine empowerment

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