Object Relational newbie

Hello,

I've a question about the Oracle Object Relational Modell, I worked on version 7.4.3 and now I try to implement some Objects- Tables. As I develop in C++ it is not to heavy to me to understanmd this modell, but there is one thing I'm not sure if it's possible with Oracle Server (9i).

The problem is this:
For example:

I've a product- table:

Product ProductName ProductType
XYZ Namexyz X-Type

Every Product has various properties. But the properties are depending on the Product- Type.
For example Product type X has 10 Properties, Proudcttype Y has 5 properties.

My Idear is to do something like this.

Prodtype_X_Propertes
{

    Property 1 int;
    property 2 varchar(2);
.
.

  .
}

Prodtype_Y_Propertes
{

    Property 1 float;
    property 2 number(5,2);
.
.

  .
}

And in the Producttable I want to have a reference dependig on the producttype.  (Should be like a void pointer)

Product ProductName ProductType Property

XYZ           Namexyz           X-Type        Ref_to_Prodtype_X_Properties
abc            nameAbc           Y-Type        Ref_to_Propdtype_Y_Properties

So my question is, if this is possible?

or, how it could be solved?

Thanks Steffen Received on Mon Mar 04 2002 - 07:00:30 CST