7 Limitations and Challenges to RDBMS
What is RDBMS?
RDBMS is a relational database management system in which the data is stored in the different tables. These tables are related to each other with the use of a primary key, indexes, and foreign key. Relational database management system uses database normalization techniques to avoid the redundancy in the tables. It is helpful to fetch the data from the database system in a fast manner with the use of RDBMS SQL queries. It is widely used by the software developers and enterprises in order to store large as well as the complex amount of data. The examples of relational database management system include Oracle, MariaDB, MySQL, and SQL Server. These further include OODBMS, network DBMS, hierarchical DBMS, ORDBMS (.R.S.V & M.K, 2007).
Relational database management systems are widely used by a number of industries to store the financial record, track the records of the employees, and keep track of the inventory system. In relational database management, all the data and information are stored in the tables. These tables are also known as relations and they help in structuring as well as organizing the data. (Kraleva, Kralev, Sinyagina, Koprinkova-Hristova & Bocheva, 2018).
The main components of the relational database management system include the following-
- Hardware and software
- Database access language
- Query processor
- The run time database manager
- Data manager
- Data dictionary
- Database engine
- Report writer
Even though the relational database management system is used widely, there are a numbered of drawbacks of the relational database management system.
The limitations of relational RBDMS
- The abundance of information: The advances in the complexity of the information can cause drawbacks for the relational database management system. Relational databases are designed in order to organize the data with the use of common characteristics. The complex numbers, designs, images, multimedia products, designs, can defy easily in the categorization of the leading way of the new type of the system known as an object-relational database management system. These types are designed for the purpose of handling the complex transactions in the data as well as to improve the scalability of the systems (Singh, 2018).
- Structure limits: This is another limitation as some of the relational databases have limits on the length of the field. Some of the search queries and names are shorter as compared to their actual position. This can lead to the loss of the data.
- Cost: One of the main disadvantages of the relational database management system is high cost. The relational databases are expensive to set up and also the maintenance of the databases is also expensive. For the purpose of setting up relational databases, there is a need to purchase the special software. In any of the large-scale organization, there is a need to hire the relational database management professional in order to manage the data od the organization.
- Isolated information: Because the relational databases use a large number of tables, there are higher chances that some information can be forgotten when it is transformed from one location to another location. This is the main problem in the large-scale organization in which there is a large amount of data of the employees, accounts and financial data. Isolation of information problem arises when the organization has different database systems.
Challenges to relational databases
- Performance: The rapid growth in the variety, volume, complexity, and velocity of data create a more complicated relationship (Singh, 2015).
- Relationships: Relational databases don’t actually store the relationship between the elements.
- Scalability: As the relational databases are built on a single server, to maintain proper scalability, there is a need to purchase more expensive hardware with more power, memory, and storage facilities.
- Singh, S. (2015). DATABASE MANAGEMENT SYSTEM. Journal Of Management Research And Analysis, 3(3). Retrieved from http://oaji.net/articles/2015/1875-1428995358.pdf
- Singh, G. (2018). Role of Relational Database Management System in Management Information System. International Journal Of Current Engineering And Technology. Retrieved from https://inpressco.com/wp-content/uploads/2017/12/Paper302109-2111.pdf
- Kraleva, R., Kralev, V., Sinyagina, N., Koprinkova-Hristova, P., & Bocheva, N. (2018). Design and Analysis of a Relational Database for Behavioral Experiments Data Processing. International Journal Of Online Engineering (Ijoe), 14(02), 117. doi: 10.3991/ijoe.v14i02.7988
- .R.S.V, A., & M.K, K. (2007). DATABASE MANAGEMENT SYSTEMS. International Journal Of Computer Applications. Retrieved from http://citeseerx.ist.psu.edu/viewdoc/download?doi=10.1.1.184.5817&rep=rep1&type=pdf