Category: 

What are the Advantages of DBMS?

Article Details
  • Written By: Carol Francois
  • Edited By: Bronwyn Harris
  • Last Modified Date: 24 March 2014
  • Copyright Protected:
    2003-2014
    Conjecture Corporation
  • Print this Article
Free Widgets for your Site/Blog
Artists tend to grow up in wealthier households than doctors.  more...

April 24 ,  2005 :  The world's first cloned dog was born.  more...

There are five major advantages of DBMS or database management systems: data structure, authorization control, processing speed, modular development, and independent back-up functionality. A DBMS is a computer software that manages the organization and access to data in a database.

A DBMS allows large amounts of data to be stored in the most efficient manner possible. The data is stored in lists of independent information. Additional data sets can be added at any time. Relationships between the data sets are defined in the DBMS, and can be altered without affecting the data.

For example, a simple database has three tables: car names, engine sizes, and seating capacity. Reports or queries can be created to access these tables and link them together in a logical way. Six months later, another table can be added listing the safety ratings. These tables can be updated independently, with no impact on any reports already created. The database management system can be programmed to run different queries or reports to retrieve specific data.

It is very common to have different access levels built into a database system, and a DBMS makes this very easy to manage. Access can be defined at the data table level. If the user does not have access to a specific table, they cannot run any query that uses data from that table. Control at this level is easy to maintain, and preferable to setting the access at the individual reporting level.

Ad

The processing speed and responsiveness of a computer system is much better with a DBMS than with a linear computer program. Common functions, such as count, sum, and calculate are programmed at the DBMS level. In a DBMS, the programs to update, report, and store the information are set at the system level.

Each section of the system can reuse code from another section or module. For example, inventory data can be stored and maintained in a module that is completely separate from sales data. However, queries can be written to combine information from these two modules without needing to change the database structure. This assumes that both modules are in the same database management system.

DBMS provide a separate architecture for the data and the programming logic. This separation allows the database manager to back up just the data to one hard drive and the programming onto another. Should the hardware fail for either system, it is possible to redirect the program server to utilize the data from the back-up, and vice versa.

Ad

Discuss this Article

anon284097
Post 5

What about hierarchical dbms?

discographer
Post 3

@feruze-- I'm not sure about the exact number of different dbms. The ones I know of are: network, hierarchical, relational, proprietary and maybe a few more.

I think relational dbms is the most commonly used, quite popular with large libraries and university consortium libraries. It's pretty well developed, has some control mechanisms for data that you can't find in others. You can also recover lost data. The main relational dbms disadvantage has to be the browsing. If you want to browse alphabetically, its not the most efficient.

I don't know too much about hierarchical, I don't even think they are in use anymore.

Can someone else pitch in?

bear78
Post 2

Several big technology companies use a relational dbms. What are the advantages and disadvantages of this kind of dbms? What about hierarchical dbms? How many different kinds of dbms are there?

Post your comments

Post Anonymously

Login

username
password
forgot password?

Register

username
password
confirm
email