Re: Oracle Object Oriented Model. Any hints?

Galen Boyer <galenboyer_at_hotpop.com> wrote in message news:<ulm6p9czc.fsf_at_hotpop.com>...
> On 29 Aug 2002, afilonov_at_yahoo.com wrote:
>
> > OO model inconsistent with relational model.
>
> Is there a quick OO concept that you find isn't represented in
> relational modeling? The only thing I can come up with is inheritance,
> but objects don't inherit, classes do.

Incapsulation. In relational model data has NOTHING to do with code.

Did you read my post? I thought I explained. Database rows (tuples) by definition can't have any compound columns (elements). By the way, there is interesting implementation of inheritance in PostgreSQL, which is quite consistent with relational model.

>
> I'm just looking for something that just isn't represented in relational
> but is in OO.

My opinion, which might be quite wrong: Relational model is a perfect model for database management. It is data oriented, compact, mathematically sound. OO model is OK for development of big programming projects and code libraries. However, it's (almost) useless for data management. Reason: it's code oriented.

I'm not going to respond to any other posts in this thread for the following reasons:
1. Discussion, if continued, should necessary include theoretical definitions of relational model and set math. comp.databases.oracle is not the place for such discussion (my opinion, questionable). Anyway, it's hard to assume that all posters are familiar with theory.

2. I think that original post was perfectly answered by S. Bakker. Received on Fri Aug 30 2002 - 10:31:17 CDT