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:
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 Handling 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.
Attention reader! Don’t stop learning now. Get hold of all the important CS Theory concepts for SDE interviews with the CS Theory Course at a student-friendly price and become industry ready.