Difference Between OODBMS and ORDBMS
Last Updated :
07 Mar, 2023
Pre-requisites: Data Models in DBMS
A Data Model in Database Management System (DBMS), is the concept of tools that are developed to summarize the description of the database.
OODBMS
The object-oriented database system is an extension of an object-oriented programming language that includes DBMS functions such as persistent objects, integrity constraints, failure recovery, transaction management, and query processing. These systems feature object description language (ODL) for database structure creation and object query language (OQL) for database querying. Some examples of OODBMS are ObjectStore, Objectivity/DB, GemStone, db4o, Giga Base, and Zope object database.
ORDBMS
An object-relational database system is a relational database system that has been extended to incorporate object-oriented characteristics. Database schemas and the query language natively support objects, classes, and inheritance. Furthermore, it permits data model expansion with new data types and procedures, exactly like pure relational systems. Oracle, DB2, Informix, PostgreSQL (UC Berkeley research project), etc. are some of the ORDBMSs.
Difference between OODBMS and ORDBMS:
OODBMS |
ORDBMS |
It stands for Object Oriented Database Management System. |
It stands for Object Relational Database Management System. |
Object-oriented databases, like Object Oriented Programming,
represent data in the form of objects and classes.
|
An object-relational database is one that is based on both the
relational and object-oriented database models.
|
OODBMSs support ODL/OQL. |
ORDBMS adds object-oriented functionalities to SQL. |
Every object-oriented system has a different set of constraints
that it can accommodate.
|
Keys, entity integrity, and referential integrity are constraints of
an object-oriented database.
|
The efficiency of query processing is low. |
Processing of queries is quite effective. |
Share your thoughts in the comments
Please Login to comment...