Migrating Relational Model to Object-Relational Model


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: Migrating Relational Model to Object-Relational Model

Hybrid View

  1. #1
    William Yeo Guest

    Migrating Relational Model to Object-Relational Model


    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!


  2. #2
    MarkN Guest

    Re: Migrating Relational Model to Object-Relational Model


    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!
    >



  3. #3
    William Guest

    Re: Migrating Relational Model to Object-Relational Model


    "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!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center