Re: Creating a table based on a Class or Object - Need modeling tool

Information on Oracle Objects can be found in the "Oracle8: Pl/SQL Programming" book by Scott Urman (Oracle Press) in Chapter 11. This information can also be found in the book "Oracle8i: Pl/SQL Advanced Programming" in either chapter 11 or chapter 12. There is a topic classified under the section, Objects in the Database (page 417) which explains Persistence vs. Transient Objects, Row Objects and Column Objects. This section will give you a brief understanding of object being stored within the database (persistence) and objects being stored in a PL/SQL block.

Your new Oracle database designer is referring to either, Row Objects or Column Objects. I assume that he is talking about Row Objects since that deals with inserting into one table or object table. Once you establish an understand of this topic and methodology, you can make a better decision as to the technology that you could/should/would use.

As far as a tool that will perform the construction of a persistence models, you can use UML. I have found a white paper under this topic called "Persistence Modeling in the UML" by Scott Ambler (Ambysoft Inc.) at http://www.ambysoft.com/umlPersistenceModel.PDF. This article can also be found in SDMagazine. You can also find some information about Persistence modeling at Rational's website (http://www.rational.com).

I hope that this information helps.

Kevin

"Don Chambers" <dchamber_at_mindspring.com> wrote in message news:8fnrpscmsh8sju4d328tib2ndknf797o34_at_4ax.com...
> We have a new Oracle database designer who has told me about a new way
> to create the database.
>
> He says we can create an Oracle class (object) and then base a table
> on this object. This would allow use to pass a class to a stored
> procedure and then easily insert it (with `Insert into table as
> class`).
>
> I have never used such a design and we don't seem to be able to find a
> modeling tool to design this. I currently use ERWin and it will not
> support this feature. We have also tried Designer 2000 (v.6) which
> supports basing a table on a class but does not allow table
> relationships to be designed (if basing the table on a class).
>
> Does anyone know of a design tool that will alow use to model this
> design?
>
> Have you ever used such a design? What are its benefits/drawbacks?
>
> My only reason for wanting this design at this time is so that I do
> not need to pass so many paramaters (about 15) to a stored procedure.
> How do you handle creating stored procedures for inserting into a
> single table that has 15 columns? Thats a lot of parameters to pass.
>
> I tend to think I should not use the class/table design because I am
> not that familiar with it and I cannot find a tool to model it.
>
> Thanks,
> Don
> chambers_at_inquiregroup.com
Received on Sun Aug 20 2000 - 15:27:07 CEST