Thursday, February 11, 2010

Oracle Locator vs Spatial

Oracle Locator Oracle Spatial

Free  included in oracle 10G onwards
What Can Oracle Locator Do for You?
Query nearest neighbor and other spatial relationships between geometries
Perform location queries on relational information not stored in Oracle Spatial geometry
Support long transactions
Store and index vector geometries in the database
Enhance application performance
http://www.oracle.com/technology/products/spatial/pdf/10gr2_collateral/locator_twp_10gr2.pd
    Additional option on top of oracle database
      What Can Oracle Spatial Do for You?
      Everything that Oracle Locator does, and:
      Perform length and area calculations on geometries
      Generate new geometries such as buffers and unions
      Perform coordinate systems transformations, for individual geometries or entire layers
      Store linear measure information
      http://www.oracle.com/technology/products/spatial/pdf/10gr2_collateral/spatial_twp_10gr2.pdf

      1 comment:

      GregoryRobinson said...

      This comparison between Oracle Locator and Spatial is really helpful for understanding how databases handle location and geometry data. Was searching for primary education dissertation topics but stumbled on this post. Nom loss! Learned something new.