Migrating Relational Model to Object-Relational Model

[William Yeo]

Hi,

Can someone direct me to appropriate tutorial/examples in migrating spatial
relational model (ver 8.0) to object-relatonal model (ver 9.2).

I have the following tables in the relational model:

ROADS
ROADS_SDODIM
ROADS_SDOGEOM
ROADS_SDOINDEX
ROADS_SDOLAYER

What tables would I need to create in the object-relational model?

Can someone advice me on how to use this function sdo_migrate.to_current?


Thanks in advance!

[MarkN]

Oracle has a O/R in v9.2? Is that the database itself or an external tool
(I know they have this). As for getting OO help here, especially O/R help,
well good luck.

I would try to help (I do OOP/OOD and O/R) but I haven't used 9.2 and am
not sure exactly what you are asking.

"William Yeo" <william@starvisionit.com> wrote:
>
>Hi,
>
>Can someone direct me to appropriate tutorial/examples in migrating spatial
>relational model (ver 8.0) to object-relatonal model (ver 9.2).
>
>I have the following tables in the relational model:
>
>ROADS
>ROADS_SDODIM
>ROADS_SDOGEOM
>ROADS_SDOINDEX
>ROADS_SDOLAYER
>
>What tables would I need to create in the object-relational model?
>
>Can someone advice me on how to use this function sdo_migrate.to_current?
>
>
>Thanks in advance!
>

[William]

"MarkN" <m@n.com> wrote:
>
>Oracle has a O/R in v9.2? Is that the database itself or an external tool
>(I know they have this). As for getting OO help here, especially O/R help,
>well good luck.
>
>I would try to help (I do OOP/OOD and O/R) but I haven't used 9.2 and am
>not sure exactly what you are asking.
>

Hi Mark,

Oracle spatial 9.0.1 is the last release that they will support relational
geometry model. Starting from 9.2 it will only support object-relational
geometry model. Therefore, there is a need to convert my old data to usable
data for 9i release 2.

In the older version, data about geometry is spread across multiple columns
and tables. Now, they only use 1 object type/column for these information.
The object type is mdsys.sdo_geometry. Any help from anyone would be appreciated.
Please give me more details instead of saying "just write a function to convert
the data". Thanks in advance!