What Are The Benefits Of DBMS (Data Base Managment System)?

Question

What Are The Benefits Of DBMS (Data Base Managment System)?

6 Answers

Answer Question

Answer 1

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.

Answer 2

Advantages of DBMS (Database Management Systems) are followings:
A true DBMS offers several advantages over file processing. The principal advantages of a DBMS are the followings:
• Flexibility: Because programs and data are independent, programs do not have to be modified when types of unrelated data are added to or deleted from the database, or when physical storage changes.

• Fast response to information requests: Because data are integrated into a single database, complex requests can be handled much more rapidly then if the data were located in separate, non-integrated files. In many businesses, faster response means better customer service.

• Multiple access: Database software allows data to be accessed in a variety of ways (such as through various key fields) and often, by using several programming languages (both 3GL and nonprocedural 4GL programs).
• Lower user training costs: Users often find it easier to learn such systems and training costs may be reduced. Also, the total time taken to process requests may be shorter, which would increase user productivity.
• Less storage: Theoretically, all occurrences of data items need be stored only once, thereby eliminating the storage of redundant data. System developers and database designers often use data normalization to minimize data redundancy.

Answer 3

Benefits of DBMS (Database Management Systems) are followings:
A true DBMS offers several advantages over file processing. The principal advantages of a DBMS are the followings:
• Flexibility: Because programs and data are independent, programs do not have to be modified when types of unrelated data are added to or deleted from the database, or when physical storage changes.
• Fast response to information requests: Because data are integrated into a single database, complex requests can be handled much more rapidly then if the data were located in separate, non-integrated files. In many businesses, faster response means better customer service.

• Multiple access: Database software allows data to be accessed in a variety of ways (such as through various key fields) and often, by using several programming languages (both 3GL and nonprocedural 4GL programs).
• Lower user training costs: Users often find it easier to learn such systems and training costs may be reduced. Also, the total time taken to process requests may be shorter, which would increase user productivity.
• Less storage: Theoretically, all occurrences of data items need be stored only once, thereby eliminating the storage of redundant data. System developers and database designers often use data normalization to minimize data redundancy.

Answer 4

Database Management System is used in all large and small organizations for managing and handling data. There are various benefits of using DBMS in companies. The prime benefit of DBMS is that it allows the integration of data. Secondly, DBMS reduces the duplication of data and helps the organizations in managing, collecting and manipulating information. Information can be easily accessed by the users through DBMS and current information can be easily updated. Moreover, DBMS has also increased the speed of handling and accessing data.

Answer 5

Most databases offer four things:
1) Storage of data
2) Management of relationships between the data
3) Understanding of data type
4) Metadata (If you put something in a table called "widgets" you already know that anything described in that table are probably widgets.

Good database software and database management tools, together with APIs that are usable externally with other programming languages facilitate simple and predicatable management of data in a database - someone else has already done the real work - you just interface to it.

Answer 6

Controlling Data Redundancy :
In non-database systems (traditional computer file-based processing), each application program has its own private files. In this case, the duplicated copies of the same data is created in many places. In DBMS, all data of an organization is integrated into a single database file. The data is recorded in only one place in the database and it is not duplicated. For example, the dean's faculty files and the faculty payroll file contained several items that were identical.

When they are converted to database, the data is integrated into a single database file so that multiple copies of the same data is not stored.In DBMS, the data redundancy can be controlled or reduced but does not remove thoroughly. Sometimes, it is necessary to create duplicate copies of the same stored data due to some technical reasons.
By controlling the data redundancy, you can save storage space. Similarly, it is useful for retrieving data from database using queries.

Sharing of Data:
In DBMS, data can be shared by authorized users of the organization. The DBA manages the data and gives rights to users to access the data. Many users can be authorized to access the same piece of information simultaneously. The remote users can also share some data. Similarly, the data of same database can be shared between different application programs.