Functions, Advantages, and Disadvantages of Database Management System(DBMS)
1.Data Dictionary Management,
Data Dictionary Management is the one of the most important function of database management system.
DBMS stores definitions of the data elements and their relationships (metadata) in a data dictionary.
2.Data Storage Management,
Data storage management is also important for database performance tuning. Performance tuning relates to the activities that make the database perform more efficiently in terms of storage and access speed. So, the data storage management is another important function of Database Management System.
3.Data Transformation and Presentation,
The DBMS transforms entered data in to required data structures. The DBMS relieves you of the chore of making a distinction between the logical data format and the physical data format. That is, the DBMS formats the physically retrieved data to make it conform to the user’s logical expectations.
4.Security Management,
Security Management is another important function of Database Management System(DBMS). The DBMS creates a security system that enforces user security and data privacy. Security rules determine which users can access the database, which data items each user can access, and which data operations (read, add, delete, or modify) the user can perform. This is especially important in multiuser database systems.
5.Multi user Access Control,
Multiuser access control is another important DBMS Function. To provide data integrity and data consistency, the DBMS uses sophisticated algorithms to ensure that multiple users can access the database concurrently without compromising the integrity of the database.
6.Backup and Recovery Management,
The DBMS provides backup and data recovery to ensure data safety and integrity.
7.Data Integrity Management,
Data integrity management is another important DBMS function.
The DBMS promotes and enforces integrity rules, thus minimizing data redundancy and maximizing data consistency.
The data relationships stored in the data dictionary are used to enforce data integrity. Ensuring data integrity is important DBMS functionality in transaction-oriented database systems
8.Database Access Languages andApplication Programming Interfaces,
The DBMS provides data access through a query language. A query language is a non procedural language—one that lets the user specify what must be done without having to specify how it is to be done.
Structured Query Language (SQL) is the defacto query language and data access standard supported by the majority of DBMS vendors.
9.Database Communication interfaces.
Current-generation DBMS's accept end-user requests via multiple, different network environments. For example, the DBMS might provide access to the database via the Internet through the use of Web browsers such as Mozilla Firefox or Microsoft Internet Explorer.
1.Better Data Transferring:
Database management creates a place where users have an advantage of more and better-managed data. Thus making it possible for end-users to have a quick look and to respond fast to any changes made in their environment.
2.Better Data Security:
The more accessible and usable the database, the more it is prone to security issues. As the number of users increases, the data transferring or data sharing rate also increases thus increasing the risk of data security. It is widely used in the corporate world where companies invest money, time, and effort in large amounts to ensure data is secure and is used properly. A Database Management System (DBMS) provides a better platform for data privacy and security policies thus, helping companies to improve Data Security.
3.Better data integration:
Due to the Database Management System we have an access to well managed and synchronized form of data thus it makes data handling very easy and gives an integrated view of how a particular organization is working and also helps to keep a track of how one segment of the company affects another segment.
4.Minimized Data Inconsistency:
Data inconsistency occurs between files when different versions of the same data appear in different places. For Example, data inconsistency occurs when a student’s name is saved as “John Wayne” on a main computer of the school but on the teacher registered system same student name is “William J. Wayne”, or when the price of a product is $86.95 in the local system of the company and its National sales office system shows the same product price as $84.95. So if a database is properly designed then Data inconsistency can be greatly reduced hence minimizing data inconsistency.
5.Faster data Access:
The Database management system (DBMS) helps to produce quick answers to database queries thus making data access faster and more accurate. For example, to read or update the data. For example, end-users, when dealing with large amounts of sale data, will have enhanced access to the data, enabling a faster sales cycle.
6.Better decision making:
Due to DBMS now we have Better managed data and Improved data access because of which we can generate better quality information hence on this basis better decisions can be made. Better Data quality improves accuracy, validity, and time it takes to read data. DBMS does not guarantee data quality, it provides a framework to make it easy to improve data quality.
7.Increased end-user productivity:
The data which is available with the help of a combination of tools that transform data into useful information, helps end-users to make quick, informative, and better decisions that can make difference between success and failure in the global economy.
8.Simple:
Database management system (DBMS) gives a simple and clear logical view of data. Many operations like insertion, deletion, or creation of files or data are easy to implement.
9.Data abstraction:
The major purpose of a database system is to provide users with an abstract view of the data. Since many complex algorithms are used by the developers to increase the efficiency of databases that are being hidden by the users through various data abstraction levels to allow users to easily interact with the system.
10.Reduction in data Redundancy:
When working with a structured database, DBMS provides the feature to prevent the input of duplicate items in the database. for e.g. – If there are two same students in different rows, then one of the duplicate data will be deleted.
1. Increased Cost:
Cost of Hardware and Software - This is the first disadvantage of the database management system. This is because, for DBMS, it is mandatory to have a high-speed processor and also a large memory size. After all, nowadays there is a large amount of data in every field which needs to be store safely and with security.
Cost of Staff Training - Educated staff (database administrator, application programmers, data entry operations) who maintains the database management system also requires a good amount. We need the database system designers to be hired along with application programmers.
Cost of Data Conversion - We need to convert our data into a database management system, there is a requirement of a lot of money as it adds to the cost of the database management system. This is because for this conversion we need to hire database system designers whom we have to pay a lot of money and also services of some software house will be required.
As we all know that nowadays all companies are using the database management system as it fulfills lots of requirements and also solves the problem. But a problem arises, that is all this functionality has made the database management system an extremely complex software. For the proper requirement of DBMS, it is very important to have a good knowledge of it by the developers, DBA, designers, and also the end-users. This is because if any one of them does not acquire proper and complete skills then this may lead to data loss or database failure.
This is very necessary to keep your system current because efficiency which is one of the biggest factors and needs to be overlooked must be maximized. That is we need to maximize the efficiency of the database system to keep our system current. For this, frequent updation must be performed on all the components as new threats come daily.
4. Performance:
The traditional file system is written for small organizations and for some specific applications due to which performance is generally very good. But for the small-scale firms, DBMS does not give a good performance as its speed is very slow. As a result, some applications will not run as fast as they could. Hence it is not good to use DBMS for small firms.
5. Frequency Upgrade/Replacement Cycles:
Nowadays in this world, we need to stay up-to-date about the latest technologies, developments arriving in the market. Frequent upgrade of the products is done by the DBMS vendors to add new functionality to the systems. New upgrade versions of the software often come bundled. Sometimes these updates also need hardware upgrades.
Comments
Post a Comment