Oracle Spatial: Advanced

Course Fees: $2556.00 excl. GST
Printed Manual: $0.00 excl. GST
Course Duration: 2 days
Course Manual

Sorry, no course dates found

This course teaches the advanced features of Oracle Spatial. New features of Oracle Spatial 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.

Learn to:

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

This course counts towards the Hands-on course requirement for the Oracle Database 10g Administrator Certification. Only instructor-led inclass or instructor-led online formats of this course will meet the Certification Hands-on Requirement. Self Study CD-Rom and Knowledge Center courses are excellent study and reference tools but DO NOT meet the Hands-on Requirement for certification.
Technical Consultant
Oracle Spatial 10g: Fundamentals
  • Describe the basic changes between Oracle9i Spatial and Oracle Spatial 10g
  • Understand Transportable Tablespaces and Spatial Indexes
  • Describe Oracle Spatial GeoRaster Concepts
  • Understand the Oracle Spatial GeoRaster storage model
  • Describe Oracle Spatial Geocoder in the server Geocoding Architecture and GeoCoding Function
  • Describe Oracle Spatial Router and the Routing Architecture
  • Describe the Oracle Spatial Topology Data Model
  • Understand how to create and load and edit a Topology
  • Understand the Oracle Spatial Network Data Model and Network Concepts
  • Use the Network Data Model to perform graph analysis
  • Understand Oracle Spatial Analysis and Mining features
Oracle Spatial: Advanced: Introduction
Course Overview

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
Share a topology between Oracle users

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