Oracle Spatial

Oracle Spatial
Oracle Spatial
Developer(s) Oracle Corporation
Stable release 11g Release 2
Operating system Cross-platform
Type GIS
License Proprietary
Website http://www.oracle.com/technology/products/spatial/index.html

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

Components

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[1], 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).
  • Data types and operators for 3-Dimensional objects including Triangulated Irregular Networks (TINs), Point Clouds and LiDAR data sets.
  • A Geocoder to convert locations and addresses data into formal geographic coordinates.
  • A Routing engine to create routes based on commercial and publicly available street network data.
  • OpenGeospatial Consortium compliant Web Services.

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

Oracle Spatial also includes Semantic Database features including an RDF triple store, ontology management, inferencing, the Web Ontology Language (OWL), and SPARQL query language.

Availability

Spatial is an option for Oracle Enterprise Edition, and must be licensed separately. It is not included in the Standard Edition and Standard Edition One. However, the latter two editions allow the use of a subset of Spatial (called Oracle Locator) at no extra cost. The functions allowed in Locator are specified in an appendix of the Oracle Spatial manual [2].

A companion visualization component and web map server, Oracle Fusion Middleware MapViewer, is available as a feature of Oracle WebLogic Server.

History

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.

Additional reading

  • Euro Beinat, Albert Godfrind & Ravikanth V. Kothuri. Pro Oracle Spatial. Apress (2004) ISBN 1-59059-383-9
  • Euro Beinat, Albert Godfrind & Ravikanth V. Kothuri. Pro Oracle Spatial for Oracle Database 11g. Apress (2007) ISBN 1-59059-899-7

References

  1. ^ ,http://download.oracle.com/docs/cd/B28359_01/appdev.111/b28400/sdo_index_query.htm#SPATL606
  2. ^ Oracle® Spatial Developer's Guide 11g Release 2, Spatial-Related Features Supported for Locator

See also

  • OGR – The OGR Simple Feature Library is an open source interface to Oracle Spatial data

External links


Wikimedia Foundation. 2010.

Игры ⚽ Нужно решить контрольную?

Look at other dictionaries:

  • Oracle (DBMS) — Oracle Datenbank Basisdaten Entwickler: Oracle Aktuelle Version: 11g (10. Juli 2007) …   Deutsch Wikipedia

  • Oracle (Datenbanksystem) — Oracle Entwickler Oracle Aktuelle Version 11g Release 2 (1. September 2009) Betriebssystem …   Deutsch Wikipedia

  • Oracle Database — Oracle Datenbank Basisdaten Entwickler: Oracle Aktuelle Version: 11g (10. Juli 2007) …   Deutsch Wikipedia

  • Spatial — (von lat. spatium „Raum“) bezeichnet im Kontext eines Dateimanagers eine Ansicht zur Datei Verwaltung (Dateimanager), bei der ein Ordner immer durch ein Fenster repräsentiert wird, dessen Größe und Platzierung auf dem Bildschirm vom Dateimanager… …   Deutsch Wikipedia

  • Oracle Database — Developer(s) Oracle Corporation Development status Active Written in …   Wikipedia

  • Spatial ETL — tools provide the data processing functionality of traditional Extract, Transform, Load (ETL) software, but with a primary focus on the ability to manage spatial data (which may also be called geographic, map or location data). Extract and… …   Wikipedia

  • Oracle Data Guard — The software which Oracle Corporation markets as Oracle Data Guard forms an extension to the Oracle RDBMS. It aids in establishing and maintaining secondary standby databases as alternative/supplementary repositories to production primary… …   Wikipedia

  • Spatial database — A spatial database is a database that is optimized to store and query data related to objects in space, including points, lines and polygons. While typical databases can understand various numeric and character types of data, additional… …   Wikipedia

  • Oracle Data Mining — (ODM) is an option of Oracle Corporation s Relational Database Management System (RDBMS) Enterprise Edition (EE). It contains several data mining and data analysis algorithms for classification, prediction, regression, classification,… …   Wikipedia

  • Oracle (base de donnees) — Oracle Database Pour les articles homonymes, voir oracle. Oracle …   Wikipédia en Français

Share the article and excerpts

Direct link
Do a right-click on the link above
and select “Copy Link”