What are the advantages of DBMS ?

Question

What is Data Model?
What is E-R model?
What is Object Oriented model?
What is an Entity?
What is an Entity type?
What is an Entity set?

Answer 1

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.

Credit: http://www.wisegeek.com

Answer 2

1) Redundancy is controlled.

2) Unauthorised access is restricted.

3) Providing multiple user interfaces.

3) Enforcing integrity constraints.

4) Providing backup and recovery.

Answer 3

Database Management Systems (DBMS) have many advantages. Some of these include:
Storing lots of information in one place
Security of data
Ability to relate two or more tables
DBMS can house a wealth of information in one place. Data can be stored for a variety of purposes and many of us use DBMS on a daily basis without realizing it. Cell phone numbers listed alphabetically are a form of DBMS. In the workplace, DBMS can be used to store a large amount of important, and sometimes, confidential information, such as pay records and personal details.

Tables can be created using data and this data can be split into fields. These fields can then be assigned a primary key, which enables the user to search for information easily and effectively. Secondary keys can also be applied to fields and by creating these fields users are able to search for data that is only applicable to the two fields in question.

Security is a major issue, and in the case of confidential information being stored, passwords can be created, so that only those who need to see the information can do so. In business, databases can be used to create mailing lists, whether the mail will be sent electronically or by hard copy.

The speed of DBMS is also a huge advantage compared to having to search through reams of paper to find out certain information. Certain keywords can be searched for and this will enable all the relevant information to appear on the screen immediately.

The size of the databases is huge, so there is no need to create new databases if they are not needed. Similarly, if a second or third database is needed then these can be linked together if needs be.