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

Time stamp ordering, explain in detail about time stamp orderting/

explain in detail about time stamp orderting/

Many-to-many relationship, For each m:n relationship type R, we make a new ...

For each m:n relationship type R, we make a new table (say S) to represent R. We also contain the primary key attributes of both the participating entity types as a foreign key att

Differentiate between a subquery and a join, Differentiate between a subque...

Differentiate between a subquery and a join If we need to acquire information from one or more tables after that either subquery or join can be used. If the columns which are t

Goals, what are the purposes of dbms in details

what are the purposes of dbms in details

Explain how the object classes are mapped to tables, Explain how the object...

Explain how the object classes are mapped to tables. Each object class maps to one or more than one tables in the database. The objects in the class may be partitioned horizont

Consistency, what do you mean by consistency in rdbms?

what do you mean by consistency in rdbms?

Find names of employees, Consider the relations EMP(ENO,ENAME,AGE,BASIC_S...

Consider the relations EMP(ENO,ENAME,AGE,BASIC_SALARY) WORK_IN(ENO,DNO) DEPT(DNO,DNAME,CITY) Express the following queries in SQL (i) Find names of employees who work in a dep

Describe the four main ways of optimising disk block access, Describe the f...

Describe the four main ways of optimising disk block access. Ans: a. Disk  b. Non-volatile writes buffers c. File organization (Clustering) d. Log-based file system

Define object oriented model, Object Oriented model :An object has values...

Object Oriented model :An object has values stored in instance variables within the object. An object also has bodies of code that execute on the object. These bodies of code are

What is the use of unique function, What is the use of unique function? ...

What is the use of unique function? UNIQUE function: If UNIQUE is specified then only unique values are used to computed the mean.

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