Re: Need help to understand difference, and contrast between Relational database model and the Object-Oriented model

From: Michael Kuznetsov <mvk37_at_hotmail.com>
Date: 30 Dec 2003 22:36:07 -0800
Message-ID: <a118d09d.0312302236.6da78b28_at_posting.google.com>


Hi Yensao,

Relational database model and the Object-Oriented model are kind of apple and oranges.

Relational model usually uses to design tables of relational database. Most common language for it is Entity-Relationship diagrams. That diagrams describes only simple static relations between thinks (entities).

Object-oriented model often uses UML that consist of 9 types of diagrams for describing static and dynamic behaviour of system. Most useful and powerful using of UML is design and documenting system written on object oriented languages like java or C++. It is possible to use UML to describe relational database but it looks clumsy.

In fact problem how to strictly much object-oriented and relational representation is a big unsolved problem in modern compute science. And now were created some big and difficult for using frameworks that convert objects to database (in fact implementation of one model to another). For example Oracle BC4J and TopLink. So both models are useful but describe very different parts of software systems.

Regards,

Michael
Brainbench MVP for Oracle Programming
http://www.brainbench.com

yensao20032000_at_yahoo.com.au (yensao) wrote in message news:<91e71e71.0312040939.2c90b9e5_at_posting.google.com>...
> Hi,
> I have a hard time to understand difference and similarities between
> Relational database model and the Object-Oriented model. Can somebody
> help me with this?
>
>
> Thank you in advance.
>
> Yensao
Received on Wed Dec 31 2003 - 07:36:07 CET

Original text of this message