Explain the advantages of database management system, Database Management System

Advantages of Database management system

Let us summarize the advantages.

Reduction of Redundancy: This is perhaps the most important advantage of using DBMS. Redundancy is the problem of storing the similar data item in more one place.  Redundancy makes several problems like requiring extra storage space, entering similar data more than once during data insertion, and deleting data from more than one place during deletion. Anomalies may happen in the database if insertion, deletion etc are not done properly.

Sharing of Data: In a paper-based record keeping, data cannot be shared between many users. But in computerized DBMS, lots of users can share the similar database if they are connected via a network.

 Data Integrity: We can handle data integrity by specifying integrity constrains, which are rules and restrictions about what type of data may be entered or manipulated within the database. This enhances the reliability of the database as it can be guaranteed that no wrong data can exist within the database at any point of time.

 Data security: We can restrict certain people from accessing the database or permit them to see certain portion of the database whereas blocking sensitive information. This is not possible very simply in a paper-based record keeping.

 

Posted Date: 7/26/2013 5:41:22 AM | Location : United States







Related Discussions:- Explain the advantages of database management system, Assignment Help, Ask Question on Explain the advantages of database management system, Get Answer, Expert's Help, Explain the advantages of database management system Discussions

Write discussion on Explain the advantages of database management system
Your posts are moderated
Related Questions
UNION If R1 and R2 are two union compatible relations then R3 = R1 ∪ R2 is the relation having tuples that are either in R1 or in R2 or in both. In case, R3 will have tuples

What are the ways of obtaining the connection parameters?  Hardwire the parameters into the program. Ask for the parameters interactively. Get the parameters

Use again the GE Flight Quest Data and build on the work done for homework 1 and 2. The goal is to create a classification model which classifies flights into "on-time" (you can de

Which of the operations constitute a basic set of operations for manipulating relational data? Relational algebra operations constitute a basic set of operations for manipulati

What is a super key? A super key is a set of one or more attributes that collectively permits us to recognize uniquely an entity in the entity set.

Explain the Aggregation implies concurrency Concurrency actually is: This in objects can be identified by the way they change state. Present objects can change state independen

Discuss the types of integrity constraints in which must be checked for the update operations - Insert and Delete. Give examples. Insert operation can violet any of the subse

What are the key features of Oracle? Key features of Oracle are as follows: • Read Consistency • Concurrency • Locking Mechanisms • Quiesce Database • RAC • Portability

we need example of 2phase locking

When is a transaction rolled back? Any changes that the aborted transaction made to the database must be uncompleted. While the changes caused by an aborted transaction have be