Difference between RDBMS and OODBMS
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 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.|