What is the difference between the Relational and Object Spatial model?
Submitted by admin on Sun, 2004-08-08 12:37.
Oracle Spatial provides two mutually exclusive models for representing geometry:
Object-relational model - uses a table with single column of type
MDSYS.SDO_GEOMETRY and a single row per geometry instance.
Relational model - uses a table with a predefined set of columns of
type NUMBER and one or more rows for each geometry instance.
The object model provides more features. In Oracle8i, the Object model
didn't support replication, partitioning and distribution. From oracle9i there
is no benefits in choosing the relational model above the object model.
»
- Login to post comments

