RDBMS:
- Data is stored inside any Relational Database Management System as tables or relations.
- Data is updated using SQL.
- Data is retrieved using SQL.
- The relationship between the tables is built to maintain the referential integrity by using the matching columns. Hence these are called "value references “.
- When RDBMS is used. the developer needs to use more coding to do any operation on the database.
- In a complex database management system, the performance of the RDBMS is slow. This is because to read the data one needs to use the proprietary SQL syntax and it needs to pass through JDBC or ODBC to be used inside any programming language.
OODBMS:
- Data is stored as attributes of objects inside an application environment as persistent 0bjects.
- Data is updated by embedding the objects inside the OOAD compliant Languages like C++ and Java.
- Data is retrieved using QOL.
- The relationship is built using the Object ID references. Hence, these are called "object references".
- In the case of OODBMS, the code is embedded inside the language and hence, the code transformation is not required.
- In a complex requirement scenario use of the OODBMS increases the performance of the system. That is because when the data is read, it is already in the format that any OOAD compliant language can read it easily.
SIMILAR KEYWORDS:
What is the difference between RDBMS and OODBMS?The main difference between RDBMS and OODBMS
RDBMS and OODBMS are database management systems.'
