Difference between RDBMS and OODBMS

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 Orientedl Database Management System.
Way of storing data Stores data in Entities, defined as tables hold specific information. Stores data as Objects.
Data Complexity Handles comparitively 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 Handeling RDBMS stores only data. Stores data as well as methods to use it.
Main Objective Data Independece 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.



My Personal Notes arrow_drop_up

Check out this Author's contributed articles.

If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to contribute@geeksforgeeks.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.

Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.




Article Tags :
Practice Tags :


2


Please write to us at contribute@geeksforgeeks.org to report any issue with the above content.