Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ORDBMS references ?

Re: ORDBMS references ?

From: Riad <rsouissi_at_yahoo.com>
Date: Sun, 03 Dec 2000 14:11:15 GMT
Message-ID: <90dka2$uh$1@nnrp1.deja.com>

Hello,

Thanks for your answer. I took a look at your post. Well, typically, that's these kind of real experiences I am looking for. I am very surprised that no book has been dedicated to that.

I am also surprised that you think performance won't be that superior. Think of it, rather than doing jointures all the time, REF is a pseudo direct link to the row we are looking for (or ARRAY of REF for a reference to multiple rows). I cannot imagine that this won't increase performance dramatically.

Typically, for a complaex business model (say of a bank, a billing system, CRM, ERP, etc), there are a lot of "relations" that would benefit from that. Usually, the user application or the middle-tier application accesses the data using only the defined business relations (like customer to contracts, contract to parameters, etc). So the link could be precomputed and stored, logical ROWID could do the job, but REF is much better because it has an OO feature...

Well, in fact, I am about to embark on a complex three-tier project. It would be very sad and a waste of time to start working with OO feature of Oracle to find out finally that it sucks or immature and not handy to manipulate (I found no tool so far to visually manipulate Objects data for Oracle 8i, TOAD does manipulate structures, but not the data)...

Would appreciate your comments and from others as well...

Best regards
Riad

In article <90199q$gbi$1_at_nnrp1.deja.com>,   Matthew Fuller <matthewlf_at_my-deja.com> wrote:
>
> Riad,
>
> Is the documentation you are referring to "Oracle8i Application
> Developer's Guide - Object-Relational Features Release 2 (8.1.6)"?
>
> If not, check it out... I think it will help. It's available on OTN.
>
> Also, check out this thread. It's a message I posted a couple of
 weeks
> ago with some replies.
>
> http://www.deja.com/viewthread.xp?
> AN=690468580&group=comp.databases.oracle.server
>
> HTH.
>
> Matt.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sun Dec 03 2000 - 08:11:15 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US