Oracle Spatial and Graph: Difference between revisions

Revision as of 01:28, 19 May 2017

Revision as of 02:30, 19 May 2017

Line 27:

===Geospatial data features===

The Oracle Spatial geospatial data features consist of:

* a schema - MDSYS -(as thatin prescribes the storage, syntax, and semantics of supported [[geometry|geometric]] [[data"multi-dimensional type]]ssystem"<ref>

{{cite book

| last1 = Greener

| first1 = Simon Gerard

| last2 = Ravada

| first2 = Siva

| chapter = 1. Defining a Data Model for Spatial Data Storage

| title = Applying and Extending Oracle Spatial

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

| ___location = Birmingham

| publisher = Packt Publishing Ltd

| publication-date = 2013

| isbn = 9781849686372

| access-date = 2017-05-19

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

}}

</ref>) - that prescribes the storage, syntax, and semantics of supported [[geometry|geometric]] [[data type]]s<ref>

{{cite web

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

Line 43 ⟶ 59:

}}

</ref>

* 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 [[database tuning|tuning]] operations

* vector performance acceleration for substantially faster querying and more efficient use of CPU, memory, and partitioning{{cn}}

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

* 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

* 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

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

* 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

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

===Network Data Model===