Oracle Spatial 10g: Fundamentals :: 10GDB-SPATIAL-FUND

This course teaches students how to model and create tables with spatial data, index spatial data, and discusses how to spatially enable applications. Students learn about Oracle's native data type for spatial data (SDO_GEOMETRY) and the geometric primitives it supports. Additionally, students learn how to load spatial data into Oracle database with various Oracle utilities, how to appropriately create spatial indexes for optimal performance, and how to query spatial data and perform spatial analysis with spatial operators, functions, and procedures. Additional topics include Oracle Spatial's Geocoder, Oracle Spatial's Linear Referencing System (LRS), coordinate systems support in Oracle Spatial and publishing maps to the web with Oracle Application Server MapViewer.

Learn to:

	Model and load data into Oracle Spatial
	Implement spatial queries
	Index and tune spatial data
	Perform spatial analysis
	Validate spatial data

course content details

	Introduction to Oracle Spatial

Course organization

	Oracle Spatial Concepts

	Supported geometric primitive types
	Oracle spatial data model
	Spatial Layers
	Spatial query model
	Concept of Spatial Indexing
	Spatial queries
	Linear referencing systems
	Geocoding

	Creating Spatial Layers

	Schema associated with all spatial layers, types, functions, and procedures
	Storage of spatial data using the Oracle Spatial object model
	Table creation with a spatial layer
	Loading metadata view with a spatial layer

	Overview of Coordinate Systems

	Coordinate systems
	Differences between georeferenced and nongeoreferenced data
	Geodetic coordinate system
	Projected coordinate system
	Coordinate system association with a spatial layer
	Adding coordinate system information to an existing spatial layer

	Loading Spatial Data

	Methods for loading spatial data
	SQL*Loader control file creation for bulk loading of spatial data
	Dump file imports containing spatial data
	Shapefile converter tool to load an ESRI shapefile into Oracle Spatial format
	Validity of individual geometries or an entire layer
	Migration tool to change format of spatial data from single-digit to four-digit

	Introduction to Oracle Application Server MapViewer

	MapViewer
	MapViewer Components
	OC4J install and configure with MapViewer
	Sample JSP to publish a map to web

	Indexing Spatial Data

	Spatial indexing concepts
	Generating an R-tree spatial index
	Estimating size of R-tree index

	Spatial Queries

	Spatial window queries
	Oracle spatial query model
	Spatial operators and functions
	Spatial operators and functions to perform spatial queries
	SDO_JOIN operator for spatial corss-product
	Topological relationships used by spatial operators and functions
	Oracle Locator 10g functionality

	Spatial Analysis

	Advanced spatial functions for complex analysis
	Length, area, and distance calculations
	Buffers around geometries
	Spatial boolean operations
	Spatial analysis functions
	Spatial utility functions
	Spatial aggregate functions
	Convert between SDO_GEOMETRY and GML

	Oracle Application Server MapViewer Advanced Concepts

	Whole Earth geometry model
	Implement coordinate systems transformations
	Creating user-defined coordinate systems
	Local coordinate systems

	Linear Referencing System (LRS)

	LRS concepts
	Functions available in LRS
	Linear referencing implementation in Oracle Spatial

	Oracle Spatial Geocoding

	Geocoding concepts
	Oracle Spatial Geocoding architecture
	Geocoding Metadata concepts
	Geocoding Reference Data concept
	Geocoding schema objects
	Geocoding functions