Oracle Spatial and Graph: Difference between revisions

Revision as of 14:37, 5 March 2020

Latest revision as of 10:01, 29 July 2025

(9 intermediate revisions by 9 users not shown)

Line 1:

{{Short description|Component of the Oracle Database}}

{{Infobox Softwaresoftware

| name = Oracle Spatial and Graph

| logo =

Line 8 ⟶ 9:

| released =

| latest release version = 19c Release 1

| latest release date =January, 2019

| latest preview version =

| latest preview date =

Line 14 ⟶ 15:

| platform =

| language = English

| status = Active

| genre = [[GIS]] and [[Graph Database]]

| license = [[Proprietary software|Proprietary]]

| website = {{official website|http://www.oracle.com/technetwork/database-options/spatialandgraph/overview/index.html}}

}}

'''Oracle Spatial and Graph''', formerly Oracle Spatial, formsis a separately-licensedfree 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 [[Transport network|transportation]], telcos, utilities and energy organizations and [[resource description framework|RDF]] semantic graphs used in [[social network]]s and social interactions and in linking disparate data sets to address requirements from the research, health sciences, finance, media and intelligence communities.

==Components==

Line 51:

| last1 = Cyran

| first1 = Michele

| author-link1 =

| year =2005

| website = docs.oracle.com

Line 62 ⟶ 61:

* operators, functions, and procedures for performing [[area-of-interest]] queries, spatial join queries, and other [[spatial analysis]] operations

* functions and procedures for utility and [[database tuning|tuning]] operations

* vector performance acceleration for substantially faster querying and more efficient use of CPU, memory, and partitioning{{cncitation needed|date=May 2017}}

* support for parametric curves ([[Non-uniform rational B-spline|NURBS]]) for mathematically precise representation of free-form curves that can be reproduced exactly for 2D and 3D data

* a [[topology]] [[data model]] for working with data about [[Vertex (graph theory)|node]]s, [[Edge (graph theory)|edge]]s, and [[face (geometry)|face]]s in a [[topology]]

Line 84 ⟶ 83:

The RDF [[Semantic Web|Semantic]] Graph feature supports the World Wide Web Consortium (W3C) [[Resource Description Framework|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:

* An RDF [[triple store]] and [[ontology (information science)|ontology]] management with automatic partitioning and data compression.

* Proven scalability to over 54 billion [[Semantic triple|triples]] (LUBM 200K benchmark) with scalability to the 8 petabyte limit of Oracle Database.

* High performance bulk loading with Oracle Database parallel and direct path loading and loading through Jena.

Line 97 ⟶ 96:

* Integration with Network Data Model graph analytics for shortest path, nearest neighbors, within cost, and reachability.

* Integration with Oracle Advanced Analytics features: Oracle Data Mining for exploiting [[predictive analytics]] and pattern discovery and Oracle R Enterprise for statistical computing and charting visualization of graph data.

* Semantic indexing for [[text mining]] and entity analytics integrated with popular natural language processors.

* Integration with leading commercial and open source tools for querying, visualization, and ontology management.

<br />

==Availability==

Line 107 ⟶ 105:

|last1= Westra

|first1= Erik

|origyearorig-year= 2010

|title= Python Geospatial Development

|url= https://books.google.com/books?id=bk4HMqpzCQgC

Line 114 ⟶ 112:

|publication-date= 2013

|isbn= 9781782161530

|accessdateaccess-date= 2015-02-16

|quote= 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.

}}

</ref>) at no extra cost. An appendix of the ''Oracle Spatial and Graph Developer's Guide'' specifies the functions allowed in Locator.

<br />

==History==

Line 140 ⟶ 136:

== References ==

Oracle Documentation Library httphttps://www.oracle.com/plsdatabase/db121technologies/portaloraclecertificationenvironment-docs-library.portal_db?selected=7&frame=html See:

* Spatial and Graph Developer's Guide

* Spatial and Graph GeoRaster Developer's Guide