Re: Guidelines for using Oracle 9i Object Relational Features

From: Peter Sylvester <peters_nospam_please_at_mitre.org>
Date: Tue, 14 Jan 2003 12:00:18 -0500
Message-ID: <b01fn3$p5b$1@newslocal.mitre.org>

I would tend to stay away from the OO features in the database, unless you really need them. I did some prototyping work under 8i that used OO extensions, found that you couldn't change type definitions whithout recreating the whole database. Also end up having to use some rather proprietary and ugly SQL extensions.

On the other hand, supposedly they've added some "alter type" capability in 9i, and the 9i XML extensions make heavy use of OO structures for structured XML storage...

--Peter

S.T.Arun wrote:
> Hi,
>
> I would like to know if there is anyone who has used Oracle's Object
> relational Features in a live project. If so, I would like to have
> some guidelines on do's and don'ts, the problem faced, solutions to
> them (if they exist!!). Most important of all the performance
> comparision between using ORDBMS and RDBMS.
>
> We are to propose the usage of Oracle 9i Database with OO
> implementation using Pro*C/C++ and Java. Any help in this regard
> would be great.
>
> Thanks in advance.
>
> Regards
> Arun
Received on Tue Jan 14 2003 - 11:00:18 CST