Open In App

Difference between RDBMS and OODBMS

Improve
Improve
Like Article
Like
Save
Share
Report

RDBMS: 
RDBMS stands for Relational Database Management System. It is a database management system based on the relational model i.e. the data and relationships are represented by a collection of inter-related tables. It is a DBMS that enables the user to create, update, administer and interact with a relational database. RDBMS is the basis for SQL, and for all modern database systems like MS SQL Server, IBM DB2, Oracle, MySQL, and Microsoft Access. 

OODBMS: 
OODBMS stands for Object-Oriented Database Management System. It is a DBMS where data is represented in the form of objects, as used in object-oriented programming. OODB implements object-oriented concepts such as classes of objects, object identity, polymorphism, encapsulation, and inheritance. An object-oriented database stores complex data as compared to relational database. Some examples of OODBMS are Versant Object Database, Objectivity/DB, ObjectStore, Caché and ZODB. 

Difference Between RDBMS and OODBMS:  

BASIS RDBMS OODBMS
Long Form Stands for Relational Database Management System. Stands for Object Oriented Database Management System.
Way of storing data Stores data in Entities, defined as tables hold specific information. Stores data as Objects.
Data Complexity Handles comparatively simpler data. Handles larger and complex data than RDBMS.
Grouping Entity type refers to the collection of entity that share a common definition. Class describes a group of objects that have common relationships, behaviors, and also have similar properties.
Data Handling RDBMS stores only data. Stores data as well as methods to use it.
Main Objective Data Independence from application program. Data Encapsulation.
Key A Primary key distinctively identifies an object in a table.. An object identifier (OID) is an unambiguous, long-term name for any type of object or entity.
Data Retrieval SQL (Structured Query Language) Object Query Language (OQL)
Scalability RDBMS has Limited scalability due to rigid schema OODBMS has Highly scalable due to flexible schema
Concurrency Control RDBMS has Fine-grained locking OODBMS has Optimistic concurrency control
Data Relationships In RDBMS Relational data is stored in tables and linked via foreign keys In OODBMS faster for complex object-oriented queries
Performance RDBMS is Efficient for complex queries involving multiple tables OODBMS is Faster for complex object-oriented queries
Flexibility RDBMS has Limited flexibility due to fixed schema OODBMS has highly flexible due to object-oriented nature
Data Persistence In RDBMS  Data is stored in tables on disk In OODBMS Data is stored in objects in memory or on disk
Examples MySQL, Oracle, SQL Server db4o, Versant, Objectivity/DB

Last Updated : 06 Apr, 2023
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads