Difference between RDBMS and ORDBMS

Difference between RDBMS and ORDBMS

Sl no. RDBMS ORDBMS
1- It is also known as Relational Database Management System. It is also known as Object – Relational Database Management System.
2- It is based on Relational Data Model. It is based on Object Data Model (ODM).
3- It is dominant model. It is gaining popularity.
4- RDBMS support a small, fixed collection of data types (eg. Integers, dates, strings ) which has proven adequate for traditional application domains such as administrative data processing ORDBMS is based on Object-Oriented Database systems and Relational Database systems and are aimed at application domains where complex objects play a central role.
5-
Supports Structured Query Language( SQL).
 Supports Object Query Language (OQL).
6-
RDBMS products :
  • IBM’s DB2
  • Informix
  • Oracle
  • Sybase
  • Microsoft’s Access
  • Fox Base
  • Paradox
  • Tandem
  • Teradata
Object-oriented model products:
  • Objectstore
  • Versant
Object-relational model products: Used in DBMS products from
  • IBM
  • Informix
  • Objectstore
  • Oracle
  • Versant
  • Others
7- Supports Standard data types and additional data type.
Supports standard data type and new richer data type.
The new richer data types supported are:
  • User-defined data types that supports image, voice and video footage and these must be stored in the database.
  • Inheritance data types to inherit the commonality between different types (eg.  To inherit some features of image objects while defining compressed image objects and low-resolution image objects.
8- ORDBMS is an attempt to extend relational database systems to provide a bridge between the relational and object-oriented paradigms.

Posted on by
Score
Views