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

Physical records, Physical Records These are the records that are store...

Physical Records These are the records that are stored in the secondary storage devices. For the database relation, physical records are the group of fields kept in adjacent me

OLD HOME POLICIES, Write an sql statement to find what is the percentage of...

Write an sql statement to find what is the percentage of home policies which are from the state of Arizona out of all Home policies by Policy Value.

Define dbms, Define DBMS? DBMS: database management system (DBMS) is co...

Define DBMS? DBMS: database management system (DBMS) is computer software designed for the reason of supervision databases based on a variety of data models.

Normalise data to third normal form, A software contract and consultancy fi...

A software contract and consultancy firm maintains details of all the various projects in which its employees are currently involved. These details comprise: Employee Numbe

Name the three major database in oracle, Name the three major set of files ...

Name the three major set of files on disk that compose a database in Oracle. There are three main sets of files on disk that compose a database. All the files are binary. These

Describe data manipulation language, Describe Data Manipulation language ? ...

Describe Data Manipulation language ? Data Manipulation Language (DML) - A data manipulation language is a language which enables users to access or manipulate data as organize

Case snerio, each publisher has uniqe name a mial addrs are also kept on ea...

each publisher has uniqe name a mial addrs are also kept on each pubisher.a publisher publish one book.a book publish y one publisher.book identified by isbn.each book writn by one

Data warehouse, XYZ is a large chain of home entertainment rental over 100 ...

XYZ is a large chain of home entertainment rental over 100 stores distributed over all states in Australia. XYZ lends entertainment products such as movies, TV shows and games on v

Assignment, Research Value: 7% Due Date: 17-Sep-2018 Return Date: 11-Oct-2...

Research Value: 7% Due Date: 17-Sep-2018 Return Date: 11-Oct-2018 Length: 700 words Submission method options: Alternative submission method Task back to top You are required to

Create a database model, Submit the table creation statements (including co...

Submit the table creation statements (including constraints) for the Database Model. Submit them all in a single script file. Also submit a document explaining what test data yo

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