Oracle - Difference between the Relational and Object Spatial model posted by
Babu Kunwar
Difference between the Relational and Object Spatial model
Spatial supports the object-relational model for representing geometries.
-
The fundamental assumption of the relational model is that all data is
represented as mathematical n-ary relations, an n-ary relation being a subset
of the Cartesian product of n domains. Where as The object-relational
implementation of Oracle Spatial consists of a set of object data types, an
index method type, and operators on these types.
-
Data are operated upon by means of a relational calculus or relational
algebra, these being equivalent in expressive power. In the Spatial
object-relational model, a single SDO_GEOMETRY object replaces the rows and
columns in a
_SDOGEOM table of
the relational model. The geometric description of a spatial
object is stored in a single row, in a single column of object
type SDO_GEOMETRY in a user-defined table.
-
The relational model of data permits the database designer to create a
consistent, logical representation of information. Consistency is achieved by
including declared constraints in the database design, which is usually
referred to as the logical schema. Relational object model allows developers to
integrate databases with their data types and methods. Also allows developers
to integrate object-oriented features into it.
-
The relational model does not support inheritance or references. Realtional
obeject model comes with inheritance or references support.
-
The relational model does not support obejct oriented concept but relation
object model is based on object oriented concept.
|
