Open In App
Related Articles

Difference between RDBMS and OODBMS

Like Article
Save Article
Report issue

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 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:  

Long FormStands for Relational Database Management System.Stands for Object Oriented Database Management System.
Way of storing dataStores data in Entities, defined as tables hold specific information.Stores data as Objects.
Data ComplexityHandles comparatively simpler data.Handles larger and complex data than RDBMS.
GroupingEntity 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 HandlingRDBMS stores only data.Stores data as well as methods to use it.
Main ObjectiveData Independence from application program.Data Encapsulation.
KeyA 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 RetrievalSQL (Structured Query Language)Object Query Language (OQL)
ScalabilityRDBMS has Limited scalability due to rigid schemaOODBMS has Highly scalable due to flexible schema
Concurrency ControlRDBMS has Fine-grained lockingOODBMS has Optimistic concurrency control
Data RelationshipsIn RDBMS Relational data is stored in tables and linked via foreign keysIn OODBMS faster for complex object-oriented queries
PerformanceRDBMS is Efficient for complex queries involving multiple tablesOODBMS is Faster for complex object-oriented queries
FlexibilityRDBMS has Limited flexibility due to fixed schemaOODBMS has highly flexible due to object-oriented nature
Data PersistenceIn RDBMS  Data is stored in tables on diskIn OODBMS Data is stored in objects in memory or on disk
ExamplesMySQL, Oracle, SQL Serverdb4o, Versant, Objectivity/DB

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