Glen,
I liked your detailed explaination.I am in the process of designing a
databse to work with java components and persistent layer.Thiking of using
Oracle's object option for this .Do you know any url or document which I can
use for supporting my object architecture concept .
Thanks for Help
Ajay
- Original Message -----
From: "Eric D. Pierce" <PierceED_at_csus.edu>
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
Sent: Tuesday, November 14, 2000 3:52 PM
Subject: (Fwd) RE: object tables
>
> ------- Forwarded message follows -------
> Date sent: Fri, 03 Nov 2000 07:06:23 -0800
> To: Multiple recipients of list ORACLE-L
<ORACLE-L_at_fatcity.com>
>
> Sean / Ed,
>
> I have worked some with object tables and have found them to be better in
> most cases. For normal select, update, etc. operations, they work the
same
> as ordinary tables. I am assuming you are referring to the ability to REF
a
> row in an object table. A lot of it comes down to design. The three most
> important things to remember about developing object-relational schemas is
> design, design, design. There is little room for error. If you want to
> change the base type of something, you have to drop and recreate the
> objects. This is really a pain with tables. I think that versioning is
due
> with 8.2. Something to remember is that you can still implement normal
> relational referential integrity between an object table and other tables.
> You just need to design the referential columns into the type. Where I
have
> seen the biggest payoff with object tables is in java with web apps.
>
> This is a high-level description of a simple demonstration I used to
present
> some of the benefits of using Oracle's object-relational features to some
> java developers.
>
> I have a contact table that is an object table created off of my
> contact_type object. I then create a contact_ref_type that is a REF of
> contact_type. Next is a contact_ref_nt_type that is a nested table type
of
> the reference type. I then create a customer table that contains a column
> called contacts that is of the nested table type. In java, I then can
> populate a customer object that contains a list of oracle.sql.REF contact
> elements. While iterating through the list, I can use the getValue()
> function and return the contact object without ever having to join to the
> contact table. Theoretically, you can take this model and make it as
> complex as you want and provide the capability to navigate through your
> entire database with only one select against one table. That makes object
> tables an incredibly powerful asset to an application design.
>
> Dealing with and manipulating the data in an object-relational schema
> requires a slight learning curve with PL/SQL and SQL. However, I believe
it
> offers a panacea of benefits to application design.
>
> Hope this helps,
> Glen
>
>
> -----Original Message-----
> Sent: Friday, November 03, 2000 5:10 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi Folks,
>
> Ed, I must have been reading your mind as I was creating this post when
> digest arrived!. I've also got the same curiosity as Ed. Whilst
> recognition of objects in Oracle, make developers life easier I'm curious
> too about performance. I suspect Oracle jumped on the Object backwagon
and
> provide the functionality but I wonder if there is a genuine practical
> application in use out there. Anyone seen any papers on this subject?. I
> believe Oracle does not support Inheritance for Objects, can anyone
confirm
> this to me please.
>
> Sean :)
>
> ###### ###### ###### ######
> # # # # # # # # Rookie
> #### # # ###### ###### Data
> # # # # # # # # Base
> # # ####### ###### # # Adminstrator
> -------------------------------- ------------
> Organon (Ireland) Ltd.
> E-mail: sean.oneill_at_organon.ie [subscribed: Digest Mode]
>
> Visit: http://www.egroups.com/group/Oracle-OCP-DBA
>
> The only man who never makes a mistake is the man who never does anything.
> - Theodore Roosevelt
>
>
> >------------------------------------------------------------
> >
> > From: "Shevtsov, Eduard" < E S h e v t s o v @ f l a g s h i p . r u >
> > Date: Thu, 2 Nov 2000 11:04:06 +0300
> > Subject: object tables
> >
> >Hello List
> >
> >Can anyone share experience of working with object tables? I'm interested
> in
> >your opinions. Are they fast enough? Is there some performance
degradation
> >of retrieving data from object tables vs rel. tables ?
> >
> >
> >Thanks in advance
> >
> >Ed
> ..
>
> ------- End of forwarded message -------
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Eric D. Pierce
> INET: PierceED_at_csus.edu
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
Received on Wed Nov 15 2000 - 09:56:18 CST
