Oracle Spatial

From Wikipedia, the free encyclopedia

Oracle Spatial forms a separately-licensed option component of the Oracle Database. Oracle Spatial aids users in managing geographic and location-data in a native type within an Oracle database, potentially supporting a wide range of applications — from automated mapping/facilities-management and geographic information systems (GIS), to wireless location services and location-enabled e-business.

Contents

Oracle Spatial provides a SQL schema (named by default "MDSYS", where "MD" stands for "Multi Dimensional") and functions that facilitate the storage, retrieval, update, and query of collections of spatial features in an Oracle database. Oracle Spatial consists of:

  • A schema that prescribes the storage, syntax, and semantics of supported geometric data types.
  • A spatial indexing system.
  • Operators, functions, and procedures for performing area-of-interest queries, spatial join queries, and other spatial analysis operations.
  • Functions and procedures for utility and tuning operations.
  • A topology data model for working with data about nodes, edges, and faces in a topology.
  • A network data model for representing capabilities or objects (modeled as nodes and links) in a network.
  • A GeoRaster feature to store, index, query, analyze, and deliver GeoRaster data (raster image and gridded data and its associated metadata).

The spatial component of a spatial feature consists of the geometric representation of its shape in some coordinate space — referred to as its "geometry".

As of Oracle version 10.2, potential users can elect to license Oracle Spatial with Oracle Enterprise Edition. Oracle Personal Edition bundles Oracle Spatial for no extra charge.

Oracle Spatial does not run with Oracle Standard Edition, with Oracle Standard Edition One or with Oracle Express Edition (XE) although a version of Spatial, with reduced functionality, named Locator is provided with these editions.

The Oracle RDBMS first incorporated spatial-data capability with a modification to Oracle 4 made by scientists working with the Canadian Hydrographic Service (CHS). A joint development team of CHS and Oracle personnel subsequently redesigned the Oracle kernel, resulting in the "Spatial Data Option" or "SDO" for Oracle 7. (The SDO_ prefix continues in use within Oracle Spatial implementations.) The spatial indexing system for SDO involved an adaptation of Riemannian hypercube data-structures, invoking a helical spiral through 3-dimensional space, which allows n-size of features. This also permitted a highly efficient compression of the resulting data, suitable for the petabyte-size data repositories that CHS and other major corporate users required, and also improving search and retrieval times. The "helical hyperspatial code", or HHCode, as developed by CHS and implemented by Oracle Spatial, comprises a form of space filling curve.

Since Oracle 8, Oracle Corporation marketing has dubbed the spatial extension simply "Oracle Spatial". The primary spatial indexing system no longer uses the HHCode, but a standard r-tree index.

  • Euro Beinat, Albert Godfrind & Ravikanth V. Kothuri. Pro Oracle Spatial. Apress (2004) ISBN 1-59059-383-9

Retrieved from "http://en.wikipedia.org../../../o/r/a/Oracle_Spatial_d849.html"
Advanced Search
Included Web Search Engines


Safe Search

close

Top Matching Results

Occasionally Search.com will highlight specialized results that are based on the context of your query. Examples of specialized results include specific links to news, images, or video.

Top Matching Results may highlight information from other Search.com pages, content from the CNET Network of sites, or third party content. The listings are based purely on relevance. Search.com does not receive payment for listings in this section but our partners that provide this data may get paid for listing these products.

Sponsored Links

This section contains paid listings which have been purchased by companies that want to have their sites appear for specific search terms and related content. These listings are administered, sorted and maintained by a third party and are not endorsed by Search.com.

Search Results

Search.com sends your search query to several search engines at one time and integrates the results into one list which has been sorted by relevance using Search.com's proprietary algorithm. You can customize the list of search engines included in your metasearch from the preferences.

The search engines that are used in your metasearch may allow companies to pay to have their Web sites included within the results. To view the Paid Inclusion policy for a specific search engine, please visit their Web site. Search.com does not accept payment or share revenue with any search engine partner for listings in this section.