A database management system (DBMS) is a collection of programs that manages the database structure and controls access to the data stored in the database.
Advantages of DBMS:
- Data can be shared in a centralised DBMS.
- Offers Data Integrity and Security.
- A DBMS schedules concurrent access to the data in such a manner that only one user can access the same data at a time.
- Provides Backup and Recovery.
- Redundancy can be controlled.
Disadvantage of DBMS:
Answerd on May 2020 by
Complexity : The provision of the functionality that is expected of a good DBMS makes the DBMS an extremely complex piece of software. Database designers, developers, database administrators and end-users must understand this functionality to take full advantage of it. Failure to understand the system can lead to bad design decisions, which can have serious consequences for an organization.
Size : The complexity and breadth of functionality makes the DBMS an extremely large piece of software, occupying many megabytes of disk space and requiring substantial amounts of memory to run efficiently.
Performance: Typically, a File Based system is written for a specific application, such as invoicing. As result, performance is generally very good. However, the DBMS is written to be more general, to cater for many applications rather than just one. The effect is that some applications may not run as fast as they used to.
Higher impact of a failure: The centralization of resources increases the vulnerability of the system. Since all users and applications rely on the ~vailabi1ity of the DBMS, the failure of any component can bring operations to a halt.
Cost of DBMS: The cost of DBMS varies significantly, depending on the environment and functionality provided. There is also the recurrent annual maintenance cost.
Data is the new fuel to the digital world and managing that data is another Difficult Task for the system. Data can be raw, functions, processed or not required & thus needs to be checked, read, modified, retrieved when required, delete, and updated within an equal interval of time according to the requirements. The system that helps in managing the data with the help of some commanding codes is known as DBMS or database management system.
Below are some advantages and disadvantages of the DBMS system.
S.No Advantages Disadvantages 1 Proper Management: DBMS system provides you with a formal structure in which your data will be stored and there is no questionary on the amount of data to be stored. Management Complexities: Once you shift on DBMS it comes with a bundle of codes, system tools, and other required software which may increase the complexity for the team. 2 Reduce Paper Management and manual dealing with data causing reduction in workload. With the new technical concept of data storage facility here comes a Frequent Upgrade/Replacement Cycle to make sure the productivity of the system should not hamper. 3 It causes Easy data accessibility, retrieval, and responsiveness to maintain the purpose of DBMS & thus reduce time to fetch data. Maintainance Cost increases. 4 There is a lot of Backup and recovery advantages irrespective of the amount of data stored and one can fetch data at any point of time. Cost of Hardware Software and data conversion are on the other hand make a large difference in the system. Data conversion becomes quite a difficult task, for a team to shift from file version to online document version. 5 To maintain the data we have a lot of tools available in the market like MySQL, IBM DB2, PostGRE, Oracle Database, Etc. Tasks to train the staff and cost increases for hiring technical staff to balance DBMS. 6 Prevent from the redundancy of data and increase productivity by saving and mining proper data into information Data Damage is the most basic risk involved.Answerd last month by
The DBMS serves as the intermediary between the user and the database. The database structure itself is stored as a collection of files, So, we can access the data in those files 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 internal complexity from the application programs and users.
1. Improved data sharing
An advantage of the database management approach is, the DBMS helps to 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 organizations 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 sales department stores a sales representatives name as Bill Brown and the company personnel department stores that same person name as William G. Brown, or when the company regional sales office shows the price of a product as 45.95and its national sales offices how . 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 adhoc 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 adhoc 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 (adhoc 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. Increased costs
One of the disadvantages of dbms is Database systems require sophisticated hardware and software and highly skilled personnel. The cost of maintaining the hardware, software, and personnel required to operate and manage a database system can be substantial. Training, licensing, and regulation compliance costs are often overlooked when database systems are implemented.
2. Management complexity
Database systems interface with many different technologies and have a significant impact on a company resources and culture. The changes introduced by the adoption of a database system must be properly managed to ensure that they help advance the company objectives. Given the fact that database systems hold crucial company data that are accessed from multiple sources, security issues must be assessed constantly.
3. Maintaining currency
To maximize the efficiency of the database system, you must keep your system current. Therefore, you must perform frequent updates and apply the latest patches and security measures to all components. Because database technology advances rapidly, personnel training costs tend to be significant. Vendor dependence. Given the heavy investment in technology and personnel training, companies might be reluctant to change database vendors. As a consequence, vendors are less likely to offer pricing point advantages to existing customers, and those customers might be limited in their choice of database system components.
4. Frequent upgrade/replacement cycles
DBMS vendors frequently upgrade their products by adding new functionality. Such new features often come bundled in new upgrade versions of the software. Some of these versions require hardware upgrades. Not only do the upgrades themselves cost money, but it also costs money to train database users and administrators to properly use and manage the new features.Answerd on November 2019 by