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. |
GeeksforGeeks has prepared a complete interview preparation course with premium videos, theory, practice problems, TA support and many more features. Please refer Placement 100 for details
Recommended Posts:
- Difference between RDBMS and DBMS
- Difference between RDBMS and HBase
- Difference between RDBMS and Hive
- Difference Between RDBMS and Hadoop
- Difference between RDBMS and MongoDB
- Difference between ER Model and RDBMS
- RDBMS Full Form
- Difference between PNG and GIF
- Difference between CRT and LCD
- Difference between JSP and ASP
- Difference between H.323 and SIP
- Difference between IoT and M2M
- Difference between LED and LCD
- Difference between C and C#
- Difference Between SMO and SEO
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.
