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

A Database Management System (DBMS) is a software package with computer programs that control the creation, maintenance and the use of a database. It allows organisations to conveniently develop databases for various applications by database administrators (DBAs) and other specialists. A database is an integrated collection of data records, files and other database objects needed by an application. A DBMS allows different user application programs to concurrently access the same database.
Depending on the task which the database is being used for, the advantages will usually outweigh the disadvantages but, like with most things, there are some disadvantages. First of all, the database systems are complex, difficult, and time-consuming to design and often need a specialist to help with the design. There are substantial hardware and software start-up costs as well as the employment of a database specialist who may be needed to train employees during the initial stages of using the database. Other disadvantages include the fact that damage to database affects virtually all applications programs. There are extensive conversion costs in moving from a file-based system to a database system. If databases are online and more users have access to the information, there are additional risks with confidentiality, privacy and security. Most databases store valuable information that must be protected against deliberate trespass and destruction. The database must also be monitored to ensure quality data. As some of the data may be entered into to the database remotely, there may be issues with the quality of input.

Many databases will contain a vast amount of information which is usually extremely important to a business. This can cause a certain amount of vulnerability. Centralising all data of an enterprise in one database may mean that the database becomes an indispensible resource. The survival of the enterprise may depend on reliable information being available from its database. The enterprise therefore becomes vulnerable to the destruction of the database or to unauthorised modification of the database.

Although there are many advantages of DBMS, the DBMS may also have some minor disadvantages. These are:
1. Cost of Hardware & Software
A processor with high speed of data processing and memory of large size is required to run the DBMS software. It means that you have to up grade the hardware used for file-based system. Similarly, DBMS software is also very costly.
2. Cost of Data Conversion
When a computer file-based system is replaced with a database system, the data stored into data file must be converted to database file. It is very difficult and costly method to convert data of data files into database. You have to hire database and system designers along with application programmers. Alternatively, you have to take the services of some software house. So a lot of money has to be paid for developing software. •
3. Cost of Staff Trailing
Most DBMSs are often complex systems so the training for users to use the DBMS is required. Training is required at all levels, including programming, application development, and database administration. The organization has to be paid a lot of amount for the training of staff to run the DBMS.
4. Appointing Technical Staff
The trained technical persons such as database administrator, application programmers, data entry operators etc. Are required to handle the DBMS. You have to pay handsome salaries to these persons. Therefore, the" system cost increases.
5. Database Damage
In most of the organizations, all data is integrated into a single database. If database is damaged due to electric failure or database is corrupted on the storage media, then your valuable data may be lost forever.
Siddhi Doifode

Although there are many advantages of DBMS, the DBMS may also have some minor disadvantages. These are:
1. Cost of Hardware & Software
A processor with high speed of data processing and memory of large size is required to run the DBMS software. It means that you have to up grade the hardware used for file-based system. Similarly, DBMS software is also very costly.
2. Cost of Data Conversion
When a computer file-based system is replaced with a database system, the data stored into data file must be converted to database file. It is very difficult and costly method to convert data of data files into database. You have to hire database and system designers along with application programmers. Alternatively, you have to take the services of some software house. So a lot of money has to be paid for developing software. •
3. Cost of Staff Trailing
Most DBMSs are often complex systems so the training for users to use the DBMS is required. Training is required at all levels, including programming, application development, and database administration. The organization has to be paid a lot of amount for the training of staff to run the DBMS.
4. Appointing Technical Staff
The trained technical persons such as database administrator, application programmers, data entry operators etc. are required to handle the DBMS. You have to pay handsome salaries to these persons. Therefore, the" system cost increases.
5. Database Damage
In most of the organizations, all data is integrated into a single database. If database is damaged due to electric failure or database is corrupted on the storage media, then your valuable data may be lost forever.

Disadvantages/Demerits of DBMS:-

• High cost for implementing DBMS.
• May involve more expensive hardware
• Specific programming skills
• Database file conversion
• Slower processing of less critical applications
• Increased vulnerability as resources are centralized
• More sophisticated recovery required when concurrent updates allowed.

It is reduces the redundancy

DBMS - Database Management System.

one of the few disadvantages of it are:
1 - files can be easily copied from the system to flsh devices (USB) and hence can be given to people who don't have the correct access.
2 - typing mistakes can cause serious problems if not corrected.
3 - a virus attack can edit, copy, delete data easily.
4 - computer can be hacked and sensitive data accessed.
5 - if backups are not taken on regular intervals, an accident like fire, earthquake, etc will cause loss of data that may not be recovered.
6 - a bug in a customized DBMS will effect business as the system can't be used until it is fixed.
7 - large DBMS will require constant maintenance which might be costly.
8 - important DBMS will require redundant connections and servers which are expensive to buy, setup and maintain.

It is really tough to mention the disadvantages of DBMS and these disadvantages are not severe. However, there are few disadvantages of DBMS.
* AS users can access the data from any place, any time so some techniques are needed to control quality of data. Several users can access data directly; so many opportunities for users exist to damage data. But there must be some strong controls to protect data quality.

* As many users can access the same data at the same time so it is a threat to data integrity. So any mechanism is necessary to ensure the safety of data.
* In a conventional system the possibilities of abuse are less than in a centralized system. Because users can access information in a centralized system from remote locations. As DBMS provides restriction against unauthorized users, but in those cases where multiple users from different locations access the data makes difficult for DBMS to enforce its rules.
* By using database approach new application can be developed by using the old applications. It means that database approach is flexible but this approach is not without its cost as it takes additional cost of running those applications which are designed by conventional system.

• Database systems are complex, difficult, and time-consuming to design
• Substantial hardware and software start-up costs
• Damage to database affects virtually all applications programs
• Extensive conversion costs in moving form a file-based system to a database system
• Initial training required for all programmers and users

A DBMS system is designed to meet the specific needs of the data handling as compare to the conventional system. A large number of users are involved in handling DBMS therefore; there are many risks which are involved in using DBMS. The first disadvantage of using DBMS is the issues of confidentiality, privacy and security. Secondly, it raises issues regarding the data quality and data integrity. Thirdly, because of DBMS enterprise vulnerability can be higher. Moreover, DBMS systems are developed in consideration to the needs of the company therefore, huge costs are incurred to use DBMS.

Disadvantages of database

1)its complex,difficult and time consuming to design
2)Damage to database effects virtually all application programs
3)Initial training required for all programmers and users
4)Substantial hardware and software start up costs

There are many DBMS you can choose from and they all have diffrent limitations, for example, excel has a limit 0f 65'536 row and 256 columns (there a lot of other limits, check out: www.asap-utilities.com for more information)

if you are asking about DBMS that are made to order (coded from scratch) then these DBMS limitations are based on the crew's knowledge and experience, budget, hardware and time scale, usually these DBMS have low amount of limitations.

Centralization:That is use of the same program at a time by many user
sometimes lead to loss of some data.
-High cost of software.

Technical experties are required

power dependency

security issues

DBMS stands for database management system. It is used for handling large databases in corporations. The disadvantages are:
- It is very costly
- It is not required by small SME's
- It takes a lot of time and effort in getting started