Open In App

Difference Between OODBMS and ORDBMS

Last Updated : 07 Mar, 2023
Improve
Improve
Like Article
Like
Save
Share
Report

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.

Like Article
Suggest improvement
Share your thoughts in the comments

Similar Reads