Relational Database Management System Advantages And Disadvantages

Powerful Essays
Relational Database Management System:
A relational database management system is a database management system that stores the data as tables which can related to each other. The tables might be related to each other by common attributes. It consists of a set of tables or files containing data that is fitted into some particular groups. These tables have data in the forms of rows and columns. Relational databases allows the user to update delete add and access a data entry from the tables. This is done by the help of structured query language, or SQL. SQL also provides users the facility to manipulate and query data in a relational database. It also provides the facility of multiple users can access the data that can be controlled by individual
…show more content…
It provides a middle group between relational database management system and object oriented database management system. It combines the advantages of relational database management system and object oriented database management system.
(Figure-3: Combination of RDBMS and OODBMS)
Advantages of ORDBMS:
ORDBMS provides advantages of object oriented programming as well as relational database management system. Following are the advantages of ORDBMS:
• One of the main advantage of ORDBMS is the flexibility in data reusability which will help in reducing the time and cost of the database designing
• It can work with the complex datatypes and based on the real world modeling
• The union of relational database management system and object oriented database management system increases the flexibility and functionality of the database
• As ODBMS provides better maintenance of database the ORDBMS also has the same feature therefore the data is easily manageable
Disadvantages of
…show more content…
The other databases give the users a major access of their data or storage therefore there is a possibility of bugs entrance or making the data corrupt. The RDBMS however consumes a lot of physical memory and the problem on the other hand is not present in the object oriented programming database management systems. This system uses the objects of classes to manipulate data and therefore the data with similar data types consumes the same classes making it possible for the database consume less storage. But in order to take the advantages of both the databases there is a combination of the two databases i.e. object relational database management system. It has the data security and less data physical storage but because of the use of both databases the object relational database becomes complex. But it gives many features and user friendly usage to its users and therefore it is more preferable. However it becomes complex for the database developers. Other than these three databases there is XML database which is written in the most easiest and flexible language which is self-describing so the developers prefer using it. However this type of database provides least amount of data
Get Access