Re: Re: Wrapping all tables with packages and scalability

From: Nuno Souto <dbvision_at_optusnet.com.au>
Date: Tue, 4 May 2004 02:29:25 +1000
Message-ID: <007201c4312b$e0778320$9b00a8c0@dcs001>

Original Message ----- From: <ryan.gaffuri_at_cox.net>

> can't you just do a procedure call and return a ref cursor, then pass a
parameter list?

Of course you can! And it is as efficient and scalable as you can get it anywhere. It's just that these folks can't think of anything else outside the square peg they were given to start with.

> also, paul dorsey wrote an article on using an object view layer on top of
your relational datamodel in odtug last year. anyone read it? anyone have comments? I haven't gotten to it yet.

Yes. It is very much in line with the stuff that Cameron O'Rourke wrote about years ago. It works and works darn good. Without the slightest performance or scalability concern. Of course if you try to implement it with Oracle Release 7 or 8i, you MAY have a problem or two... IME, if you wanna play with this stuff you MUST use 9i. It's the first release where you can nest object types and create true hierarchical structures to perform a good OO-relational mapping. 8i won't allow you to do more than one single level of object type. One of the (many) problems we had.

Cheers
Nuno Souto
in sunny Sydney, Australia
dbvision_at_optusnet.com.au

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Mon May 03 2004 - 11:29:20 CDT