Oracle Spatial and Graph: Difference between revisions

Revision as of 20:13, 6 February 2016

Revision as of 22:43, 5 July 2016

Line 29:

The geospatial data features consist of:

* Aa schema - MDSYS - that prescribes the storage, syntax, and semantics of supported [[geometry|geometric]] [[data type]]s.<ref>

{{cite web

* A spatial indexing system.

| url = https://docs.oracle.com/cd/B19306_01/server.102/b14220/content.htm#BAJJIFJJ

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

| title = Oracle Database Concepts, 10g Release 2 (10.2)

* Functions and procedures for utility and [[database tuning|tuning]] operations.

| last1 = Cyran

* Vector Performance Acceleration for substantially faster querying and more efficient use of CPU, memory, and partitioning

| first1 = Michele

* Parametric Curves (NURBs) support for mathematically precise representation of free form curves that can be reproduced exactly for 2D and 3D data.

| author-link1 =

* 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]].

| year =2005

* A GeoRaster feature to store, index, query, analyze, and deliver GeoRaster data ([[raster image]] and gridded data and its associated [[metadata]]) with virtual mosaics, raster algebra operations, image processing, Java API, and GDAL-Based ETL Wizard.

| website = docs.oracle.com

*3-Dimensional data types and operators including [[triangulated irregular network|Triangulated Irregular Networks (TINs)]], [[Point cloud|Point Clouds]] and [[LiDAR]] data sets with Spatial R-tree indexing, SQL operators and analysis functions, and metadata for visualization.

| publisher = Oracle Corporation

* [[Geocoding]] that converts locations and addresses data into formal geographic coordinates from point addresses and address ranges, and supports reverse geocoding.

| access-date = 2016-07-05

* A [[routing]] engine that creates fastest or shortest routes with driving distances, times, directions and turn-specific geometries based on commercial and publicly available street network data, and restrictions and conditions for advanced routing, such as truck-specific routing.

| quote = Spatial consists of the following: [...] A schema (MDSYS) that prescribes the storage, syntax, and semantics of supported geometric datatypes [...]

* [[Open Geospatial Consortium]] compliant [[Web Service]]s for geocoding, routing, mapping, business directory, catalog, and geospatial feature transactions.

}}

</ref>

* Aa spatial indexing system.

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

* Functionsfunctions and procedures for utility and [[database tuning|tuning]] operations.

* Vectorvector Performanceperformance Accelerationacceleration for substantially faster querying and more efficient use of CPU, memory, and partitioning

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

* Aa [[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]].

* Aa GeoRaster feature to store, index, query, analyze, and deliver GeoRaster data ([[raster image]] and gridded data and its associated [[metadata]]) with virtual mosaics, raster algebra operations, image processing, Java API, and GDAL-Based ETL Wizard.

* 3-Dimensionaldimensional data types and operators including [[triangulated irregular network|Triangulated Irregular Networks (TINs)]], [[Point cloud|Point Clouds]] and [[LiDAR]] data sets with Spatial R-tree indexing, SQL operators and analysis functions, and metadata for visualization.

* [[Geocodinggeocoding]] that converts locations and addresses data into formal geographic coordinates from point addresses and address ranges, and supports reverse geocoding.

* Aa [[routing]] engine that creates fastest or shortest routes with driving distances, times, directions and turn-specific geometries based on commercial and publicly available street network data, and restrictions and conditions for advanced routing, such as truck-specific routing.

* [[Open Geospatial Consortium]] -compliant [[Web Service]]s for geocoding, routing, mapping, business directory, catalog, and geospatial feature transactions.

===Network Data Model===