0
0
Answer Now
Comment
Report
5
Answers
Improved availability: One of the principle advantages of a DBMS is that the same information can be made
available to different users.
Minimized redundancy: The data in a DBMS is more concise because, as a general rule, the information in
it appears just once. This reduces data redundancy, or in other words, the need to repeat the same data over
and over again. Minimizing redundancy can therefore significantly reduce the cost of storing information on hard
drives and other storage devices. In contrast, data fields are commonly repeated in multiple files when a file
management system is used.
Important Note โ Preparing for IT?
CAKART provides Indias top faculty each subject video classes and lectures โ online & in Pen Drive/ DVD โ at very cost effective rates. Get video classes from CAKART.in. Quality is much better than local tuition, so results are much better.
Watch Sample Video Now by clicking on the link(s) below โ
For any questions Request A Call Back
Hie Uma,
**Advantages of DBMS are as follows :-**
1. Improved data sharing.
The DBMS helps create an environment in which end users have better access to more and better-managed data. Such access makes it possible for end users to respond quickly to changes in their environment.
2. Improved data security.
The more users access the data, the greater the risks of data security breaches. Corporations invest considerable amounts of time, effort, and money to ensure that corporate data are used properly. A DBMS provides a framework for better enforcement of data privacy and security policies.
3. Better data integration.
Wider access to well-managed data promotes an integrated view of the organizationโs operations and a clearer view of the big picture. It becomes much easier to see how actions in one segment of the company affect other segments.
4.Improved decision making.
Better-managed data and improved data access make it possible to generate better-quality information, on which better decisions are based. The quality of the information generated depends on the quality of the underlying data. Data quality is a comprehensive approach to promoting the accuracy, validity, and timeliness of the data. While the DBMS does not guarantee data quality, it provides a framework to facilitate data quality initiatives.
5.Increased end-user productivity.
The availability of data, combined with the tools that transform data into usable information, empowers end users to make quick, informed decisions that can make the difference between success and failure in the global economy.
The Main advantages of DBMS are described below.
Controlling Redundancy
In file systems 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.
Sharing of Data
In DBMS, data can be shared by authorized users of the organization. The database administrator 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 same data. Similarly, the data of same database can be shared between different application programs.
Data Consistency
By controlling the data redundancy, the data consistency is obtained. If a data item appears only once, any update to its value has to be performed only once and the updated value is immediately available to all users. If the DBMS has controlled redundancy, the database system enforces consistency.
Integration of Data
In Database management system, data in database is stored in tables. A single database contains multiple tables and relationships can be created between tables (or associated data entities). This makes easy to retrieve and update data.
Integration Constraints
Integrity constraints or consistency rules can be applied to database so that the correct data can be entered into database. The constraints may be applied to data item within a single record or the may be applied to relationships between records.
Data Security
Form is very important object of DBMS. You can create forms very easily and quickly in DBMS. Once a form is created, it can be used many times and it can be modified very easily. The created forms are also saved along with database and behave like a software component. A form provides very easy way (user-friendly) to enter data into database, edit data and display data from database. The non-technical users can also perform various operations on database through forms without going into technical details of a fatabase.
Report Writers
Most of the DBMSs provide the report writer tools used to create reports. The users can create very easily and quickly. Once a report is created, it can be used may times and it can be modified very easily. The created reports are also saved along with database and behave like a software component.
Control Over Concurrency
In a computer file-based system, if two users are allowed to access data simultaneously, it is possible that they will interfere with each other. For example, if both users attempt to perform update operation on the same record, then one may overwrite the values recorded by the other. Most database management systems have sub-systems to control the concurrency so that transactions are always recorded with accuracy.
Backup and Recovery Procedures
In a computer file-based system, the user creates the backup of data regularly to protect the valuable data from damage due to failures to the computer system or application program. It is very time consuming method, if amount of data is large. Most of the DBMSs provide the 'backup and recovery' sub-systems that automatically create the backup of data and restore data if required.
Data Independence
The separation of data structure of database from the application program that uses the data is called data independence. In DBMS, you can easily change the structure of database without modifying the application program.
> Advantages of the DBMS:
The DBMS serves as the intermediary between the user and the database. The database structure itself is stored as a collection of files, and the only way to access the data in those files is through the DBMS. The DBMS receives all application requests and translates them into the complex operations required to fulfill those requests. The DBMS hides much of the databaseโs internal complexity from the application programs and users.
The different advantages of DBMS are as follows.
1. **Improved data sharing.**
The DBMS helps create an environment in which end users have better access to more and better-managed data. Such access makes it possible for end users to respond quickly to changes in their environment.
2. **Improved data security.**
The more users access the data, the greater the risks of data security breaches. Corporations invest considerable amounts of time, effort, and money to ensure that corporate data are used properly. A DBMS provides a framework for better enforcement of data privacy and security policies.
3. **Better data integration.**
Wider access to well-managed data promotes an integrated view of the organizationโs operations and a clearer view of the big picture. It becomes much easier to see how actions in one segment of the company affect other segments.
4. **Minimized data inconsistency.**
Data inconsistency exists when different versions of the same data appear in different places. For example, data inconsistency exists when a companyโs sales department stores a sales representativeโs name as โBill Brownโ and the companyโs personnel department stores that same personโs name as โWilliam G. Brown,โ or when the companyโs regional sales office shows the price of a product as $45.95 and its national sales office shows the same productโs price as $43.95. The probability of data inconsistency is greatly reduced in a properly designed database.
5. **Improved data access.**
The DBMS makes it possible to produce quick answers to ad hoc queries. From a database perspective, a query is a specific request issued to the DBMS for data manipulationโfor example, to read or update the data. Simply put, a query is a question, and an ad hoc query is a spur-of-the-moment question. The DBMS sends back an answer (called the query result set) to the application. For example, end users, when dealing with large amounts of sales data, might want quick answers to questions (ad hoc queries) such as:
- What was the dollar volume of sales by product during the past six months?
- What is the sales bonus figure for each of our salespeople during the past three months?
- How many of our customers have credit balances of $3,000 or more?
6. **Improved decision making.**
Better-managed data and improved data access make it possible to generate better-quality information, on which better decisions are based. The quality of the information generated depends on the quality of the underlying data. Data quality is a comprehensive approach to promoting the accuracy, validity, and timeliness of the data. While the DBMS does not guarantee data quality, it provides a framework to facilitate data quality initiatives.
7. **Increased end-user productivity.**
The availability of data, combined with the tools that transform data into usable information, empowers end users to make quick, informed decisions that can make the difference between success and failure in the global economy.
1. Improved availability: One of the principle advantages of a DBMS is that the same information can be made
available to different users.
2. Minimized redundancy: The data in a DBMS is more concise because, as a general rule, the information in
it appears just once. This reduces data redundancy, or in other words, the need to repeat the same data over
and over again. Minimizing redundancy can therefore significantly reduce the cost of storing information on hard
drives and other storage devices. In contrast, data fields are commonly repeated in multiple files when a file
management system is used.
2. Accuracy: Accurate, consistent, and up-to-date data is a sign of data integrity. DBMSs foster data integrity
because updates and changes to the data only have to be made in one place. The chances of making a mistake
are higher if you are required to change the same data in several different places than if you only have to make
the change in one place.
3. Program and file consistency: Using a database management system, file formats and system programs
are standardized. This makes the data files easier to maintain because the same rules and guidelines apply
across all types of data. The level of consistency across files and programs also makes it easier to manage data
when multiple programmers are involved.
4. User-friendly: Data is easier to access and manipulate with a DBMS than without it. In most cases, DBMSs
also reduce the reliance of individual users on computer specialists to meet their data needs.
5. Improved security: As stated earlier, DBMSs allow multiple users to access the same data resources. This
capability is generally viewed as a benefit, but there are potential risks for the organization. Some sources of
information should be protected or secured and only viewed by select individuals. Through the use of passwords,
database management systems can be used to restrict data access to only those who should see it.
Thanks