Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Object Oriented Database Vs object Relational Database

I wonder how Object Oriented data modeling is different from Object Relational data modeling?

Is it something like the pluses of both object oriented and relational data modeling were clubbed to achieve object relational data modeling?

cheers

like image 655
Arnkrishn Avatar asked Apr 16 '09 16:04

Arnkrishn


People also ask

What is the difference between relational model and object-oriented model?

In relational systems, relations between entities are implemented using foreign key / primary key references. In object-oriented systems, relations are usually explicitly implemented through attributes.

What is the difference between OODBMS and ORDBMS?

The difference between RDBMS and OODBMS is that RDBMS is a Database Management System that is based on the relational model while OODBMS is a Database Management System that supports the creating and modeling of data as objects. In brief, RDBMS uses the relational model while OODBMS uses object-oriented model.

Why is relational database better than object database?

Unlike the relational model, where relationships are not explicitly defined between tables, object-oriented models have several ways of specifying relationships between objects directly in the database structure, and these relationships are not implied by the object's contents (values).


1 Answers

Object-Relational data modeling supports some object-oriented concepts, while still supporting some relational concepts:

  • Inheritance -- one table can have an IS-A relationship with another table. Likewise custom data types support inheritance.
  • Distinction between a class and an object (instance of a class) that goes beyond simply the distinction between a table and a row.
  • Custom or complex data types.
  • Relational query language.
  • Referential integrity.

Object-Oriented data modeling is just persistence for objects:

  • Greater support for complex objects.
  • No query language -- you just retrieve individual objects like some giant key/value store.
  • No relational referential integrity -- though you may have one object contain a reference to another object.
like image 100
Bill Karwin Avatar answered Oct 07 '22 19:10

Bill Karwin