Oracle Spatial and Graph

Oracle Spatial and Graph
Developer(s) Oracle Corporation
Stable release
12c Release 1
Development status Active
Operating system Cross-platform
Available in English
Type GIS and Graph Database
License Proprietary
Website Official website

Oracle Spatial and Graph, formerly Oracle Spatial, forms a separately-licensed option component of the Oracle Database. The spatial features in Oracle Spatial and Graph aid 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 (AM/FM/GIS), to wireless location services and location-enabled e-business. The graph features in Oracle Spatial and Graph include Oracle Network Data Model (NDM) graphs used in traditional network applications in major transportation, telcos, utilities and energy organizations and RDF semantic graphs used in social networks and social interactions and in linking disparate data sets to address requirements from the research, health sciences, finance, media and intelligence communities.

Components

The geospatial feature of Oracle Spatial and Graph provides a SQL schema and functions that facilitate the storage, retrieval, update, and query of collections of spatial features in an Oracle database. (The spatial component of a spatial feature consists of the geometric representation of its shape in some coordinate space — referred to as its "geometry".)

Geospatial data features

The Oracle Spatial geospatial data features consist of:

Network Data Model

The Network Data Model feature is a property graph model used to model and analyze physical and logical networks used in industries such as transportation, logistics, and utilities. Its features include:

RDF semantic

The RDF Semantic Graph feature supports the World Wide Web Consortium (W3C) RDF standards. It provides RDF data management, querying and inferencing that are commonly used in a variety of applications ranging from semantic data integration to social network analysis and linked open data applications. Its features include:

Availability

Oracle Spatial and Graph is an option for Oracle Enterprise Edition, and must be licensed separately. It is not included in Oracle Standard Edition or Oracle Standard Edition One. However, the latter two editions allow the use of a subset of spatial features (called Oracle Locator[3]) at no extra cost. An appendix of the Oracle Spatial and Graph Developer's Guide specifies the functions allowed in Locator.

Oracle Corporation makes a companion visualization component and web map server, Oracle Fusion Middleware MapViewer, 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.

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

Since July, 2012, the option has been named Oracle Spatial and Graph to highlight the graph database capabilities in the product - Network Data Model graph introduced with Oracle Database 10g Release 1 and RDF Semantic Graph introduced with Oracle Database 10g Release 2.

Additional reading

See also

References

Oracle Documentation Library http://www.oracle.com/pls/db121/portal.portal_db?selected=7&frame= See:

Notes

  1. ↑ Greener, Simon Gerard; Ravada, Siva (2013). "1. Defining a Data Model for Spatial Data Storage". Applying and Extending Oracle Spatial. Birmingham: Packt Publishing Ltd. ISBN 9781849686372. Retrieved 2017-05-19. Oracle Spatial mainly consists of the following: [...] A schema (MDSYS derived from Multi-Dimensional System) that defines the storage, syntax, and semantics of the supported geometric (both vector and raster) data types [...]
  2. ↑ Cyran, Michele (2005). "Oracle Database Concepts, 10g Release 2 (10.2)". docs.oracle.com. Oracle Corporation. Retrieved 2016-07-05. Spatial consists of the following: [...] A schema (MDSYS) that prescribes the storage, syntax, and semantics of supported geometric datatypes [...]
  3. ↑ Westra, Erik (2013) [2010]. Python Geospatial Development (2 ed.). Packt Publishing Ltd. ISBN 9781782161530. Retrieved 2015-02-16. A subset of the Oracle Spatial functionality, called Oracle Locator, is available for the Standard edition of the Oracle database. Oracle Locator does not support common operations such as unions and buffers, intersections, area and length calculations. It also excludes support for more advanced features such as linear referencing systems, spatial analysis functions, geocoding, and raster format data.
This article is issued from Wikipedia. The text is licensed under Creative Commons - Attribution - Sharealike. Additional terms may apply for the media files.