Oracle Spatial 10g: Advanced

Course Overview

This course teaches the advanced features of Oracle Spatial. New features of Oracle Spatial 10g that simplify spatial queries, application development, and deployment are also covered. This course covers the advanced Spatial indexing features, including local partitioned spatial indexes, function based spatial indexes, and spatial indexes on embedded spatial objects within objects. Other topics teach how to use Oracle Spatial GeoRaster, Oracle Spatial's open solution for storing digital imagery and grid data in the database, as well as how to display raster data with Oracle Application Server MapViewer. This course explains how to use Oracle Spatial's Geocoder to return location information based on address data, and Oracle Spatial's Router to generate driving directions between locations.

Additionally, one learns how Oracle Spatial Topology Data Model stores topology information in the database, as well as the Oracle Spatial Network Data Model, which stores network information in the database for graph analysis. This course also covers Spatial Analysis and Mining and Oracle Workspace Manager.

Audience

• Technical Consultant

Skills Gained

Learn to:

• Use MapViewer to publish raster (and vector) data on the web
• Create a topology
• Perform graph analysis

Prerequisites

• Oracle Spatial 10g: Fundamentals NEW

Course Outline

Advanced Spatial Indexing

• Create partitioned spatial indexes
• Discuss spatial partitioning of data
• Export and import transportable tablespaces that include spatial indexes
• Create function-based indexes
• Embed and index spatial objects within objects

Oracle Spatial GeoRaster

• Describe what raster data is
• Explain Oracle Spatial GeoRaster concepts
• Discuss Oracle Spatial GeoRaster storage
• Load GeoRaster data
• View GeoRaster data using MapViewer

Oracle Spatial Geocoding

• Explain geocoding concepts
• Describe the Oracle Spatial Geocoding architecture
• Describe Geocoding Metadata concepts
• Detail Geocoding Reference Data concepts
• Discuss Geocoding Schema Objects
• Use geocoding functions

Oracle Spatial Routing Engine

• Explain the Oracle Spatial Routing architecture
• Describe how to formulate route requests
• Describe the route response
• Use the sample RouteServer JSP

Oracle Spatial Topology Data Model

• Describe the Oracle Spatial Topology Data Model
• Create a topology
• Load topology primitives
• Explain the topology feature model
• Describe topology caches
• Explain topology hierarchies
• Discuss Spatial queries and topology

Oracle Spatial Network Data Model

• Explain network concepts
• Discuss the Oracle Spatial Network Data Model
• Describe node, link, and path tables
• Detail the network metadata
• Include geometry data in a network
• List the types of analysis done in the Oracle Spatial Network Data Model
• Identify network constraints

Spatial Analysis and Mining

• Neighborhood Analysis
• Spatial Binning
• Spatial Clustering