What is Oracle Spatial?
Oracle Spatial forms a separately-licensed option component of the Oracle Database. Oracle “Spatial” is the Oracle Database Server capability to store all sorts of “Location” data. 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.
Why is spatial so cool?
It is fairly easy to “location-enable” your own data by just adding a “spatial” column to your table and add location related data and you are set to show your data in a map (admittedly you have to define a spatial index and wire it to the spatial functions by inserting the table name into the spatial_metadata_view).
Oracle Spatial 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, 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).
The spatial component of a spatial feature consists of the geometric representation of its shape in some coordinate spaces referred to as its “geometry”.
Licensing of Oracle Spatial:
Spatial is an option for Oracle Enterprise Edition, and must be licensed separately. It is not included in the Standard Edition. 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.
How Oracle Spatial evolved:
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.
How we can view Oracle Spatial Geometry:
Map Viewer serves for the display of maps with navigation and other functionality, but we need display the maps, layers, styles, etc. so for that purpose Oracle provides for a tool called Map Builder:
It looks like:
GeoRaptorr is a very useful extension of SQL Developer for viewing and maintaining (metadata, spatial indexes) spatial data:
It looks like:
Here BestSolver will discuss about how to create Oracle Spatial features, How to create an index on spatial table, How to create point features, How to create a line features and how to create polygon features and many more.