Monday, April 6, 2009

DBMS ADVANTAGES

When it comes to a DBMS many advantages can be described. The main advantages found throughout this internet research and that have come in many different websites are the following.

ADVANTAGES
-Controlling redundancy
-Providing storage structure for efficient query processing.
-Restricting unauthorized users.
-Providing concurrency.
-Providing backup and recovery.
-Enforcing integrity constraints.


When we talk about the advantage of the control of redundancy of data we mean that consistency is being obtained, no duplicates allowed. For example, if we want to update a specific data that is unique, an update to its value has to be executed only once, and the new value of the data is available to the users right away. With a controlled redundancy in the DBMS we get a system that will enforce the consistency of data as well. So if a data value is not unique and comes up more than once, the database will know to update all the occurrences of that data item in the database.
A DBMS has the advantage of enforcing integrity constraints if data is often accessed through the DBMS. For example, before you insert any kind of data, the DBMS can check if this type if data will be visible and available to all users of the system. If you need to insert salary information for a companies employee, your DBMS can check if the department still has enough budget, and it has not been exceeded.
Any business has advantages when using DBMS. An organization can use one type of database management system for the process of transactions that are made day by day and then have another DBMS on another computer that is used for random analysis and tasks.

Resources:
http://en.wikipedia.org/wiki/Database_management_system\
http://wiki.answers.com/Q/What_is_the_disadvantages_and_disadvantages_of_DBMS
http://www.ii.metu.edu.tr/~ion503/demo/chapter1/chapter15.htm
http://www.blurtit.com/q110246.html
http://estudents.co.cc/database-management-systems/advantages

No comments:

Post a Comment