| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> (Fwd) RE: (Fwd) RE: (Fwd) RE: object tables
Joe Hudicka and I wrote an Oracle Press book on the functionality about a
year (or gosh was it 2 years??) ago.
"Oracle 8 Database design using UML object modeling"
At the time, I thought it was a bit limited in functionality and a bit ahead of its time. .... it still is.
When 9i (8.2 in a box) comes out we will have the first Obj support that looks promising. I would wait for that, but for now, you can play around with the features, but under NO circumstances should you commit a project to using this new archetecture.
Paul Dorsey
Dulcian, Inc.
-----Original Message-----
Pierce
Sent: Wednesday, November 15, 2000 2:38 PM
To: Multiple recipients of list ODTUG-DEV2K-L
Does anyone have any info on finding out more about object table database design issues?
--- Please include the following addresses in any response to the list: (Ajay K) ajay_at_tems.com (Shaw, Glen) Glen.Shaw_at_BellSouth.com ------- Forwarded message follows ------- Date sent: Wed, 15 Nov 2000 10:46:13 -0800 To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Ajay, There is a wealth of general information on technet (http://technet.oracle.com). Unfortunately, I have not found a great deal of design-related information. Much of my design experience has been related to business scenarios and trial and error. I think someone pointed out on this list that not many people use this functionality, yet. Those that I have seen using it are doing so with caution. Sorry I can't be of more help, Glen -----Original Message----- Sent: Wednesday, November 15, 2000 12:56 PM To: Multiple recipients of list ORACLE-L 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 ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Tuesday, November 14, 2000 3:52 PMReceived on Wed Nov 15 2000 - 16:18:03 CST
>
> ------- 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: Ajay K INET: ajay_at_tems.com -- -- Author: Shaw, Glen INET: Glen.Shaw_at_BellSouth.com ------- End of forwarded message ------- -- ODTUG 2000 was a great success! Visit our website at www.odtug.com for photos, highlights and presentation handouts. And plan now for ODTUG 2001 (June 24 to 28) at the Sheraton Hotel and Marina in San Diego, CA. -- 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 ODTUG-DEV2K-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- ODTUG 2000 was a great success! Visit our website at www.odtug.com for photos, highlights and presentation handouts. And plan now for ODTUG 2001 (June 24 to 28) at the Sheraton Hotel and Marina in San Diego, CA. -- Author: Paul Dorsey INET: pdorsey_at_dulcian.com 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 ODTUG-DEV2K-L
 |
 |