Oracle 11g Essentials
Proposed Day Wise Module Coverage Schedule
Course Duration 5 Day

Day 1

Using Spatial Information in Various Industries
Sources of Spatial Data
Managing and Analyzing Spatial Data
Storing Spatial Data in a Database
Spatial Analysis
Benefits of Oracle Spatial

Technology and Architecture Overview
Getting Started with Oracle Spatial
Data Model: Storing Spatial Data
Location-Enabling
Query and Analysis
Visualizing Spatial Data
Advanced Spatial Engine
Oracle Spatial Technology Products
Locator
Spatial Option
What to Expect in an Oracle Spatial Install
Installing Oracle Spatial in the Database
Upgrades
Understanding a Spatial Install
Checking the Version of a Spatial Install

Adding Location Information to Tables
Application-Specific Data
Geographic Data
Metadata for Spatial Tables
Dictionary View for Spatial Metadata
Populating Spatial Metadata for Your Application
Additional Information for Visualization and Network Analysis

Types of Spatial Geometries in Oracle
Points
Line Strings
Polygons and Surfaces
Solids
Collections
Logical Implementation of SDO_GEOMETRY
Spatial Data in SQL/MM and OGC
SDO_GEOMETRY Type, Attributes, and Values
SDO_GTYPE Attribute
SDO_SRID Attribute
SDO_POINT Attribute
SDO_ELEM_INFO and SDO_ORDINATES Attributes
Simple Two-Dimensional Geometry Examples
Point
Line String: Connected by Straight Lines
Line String: Connected by Arcs
Polygon: Ring (Boundary) Connected by Straight Lines
Polygon: Ring (Boundary) Connected by Arcs
Rectangle Polygon
Circle Polygon
Complex Two-Dimensional Geometry Examples
Constructing Complex Geometries
SDO_ELEM_INFO for Compound Elements
SDO_ELEM_INFO for Voided Polygon Element
Compound Line String Example
Compound Polygon Example
Polygon with a Void
Collections
Three-Dimensional Examples
Three-Dimensional Points, Lines, and Polygons
Composite Surfaces
Simple Solid
Composite Solid
Collections

Inserting Data into an SDO_GEOMETRY Column
Loading and Converting Spatial Data
Loading from Text Files Using SQL*Loader
Transporting Spatial Data Between Oracle Databases
Loading from External Formats
Converting Between SDO_GEOMETRY and WKT/WKB
Converting SDO_GEOMETRY Data in GML
Extruding a Two-Dimensional Geometry to Three Dimensions
Validating Spatial Data
Validation Functions
Validation Criteria
Composite Solids
Collections
Debugging Spatial Data
REMOVE_DUPLICATE_VERTICES
EXTRACT
APPEND
GETNUMELEM, GETNUMVERTICES, and GETVERTICES
EXTRACT3D

What Is Geocoding?
Architecture of the Oracle Geocoder
Parsing the Input Address
Searching for the Address
Computing the Spatial Coordinates
Setting Up the Reference Data for the Geocoder
Parameter Tables
Data Tables
Using Geocoder Functions
GEOCODE_AS_GEOMETRY
GEOCODE
GEOCODE_ALL
Geocoding Using Structured Addresses
GEOCODE_ADDR
GEOCODE_ADDR_ALL
Reverse Geocoding
REVERSE_GEOCODE
Geocoding Business Data
Adding the Spatial Column
Geocoding the Addresses: The “Naive” Approach
Address Verification and Correction
Automatic Geocoding
The Geocoding Server
Architecture
Installation and Configuration
Using the Geocoder: XML Queries and Responses

Manipulating Geometries Using PL/SQL
VARRAY Manipulation Primer
Reading and Writing SDO_GEOMETRY Objects
Creating New Geometries
Extracting Information from Geometries
Modifying Existing Geometries
Using Standard Notations: WKT, WKB, GML
Using ESRI Shapefiles

Spatial Indexes
Inserting Metadata for a Spatial Layer Prior to Indexing
Creating a Spatial Index
Spatial Indexing Concepts
Spatial Index Parameters
Spatial Operators
Syntax of Spatial Operators
Semantics of Spatial Operators
Evaluation of Spatial Operators
A Closer Look at Spatial Operators
SDO_WITHIN_DISTANCE Operator
SDO_NN Operator
Operators for Spatial Interactions (Relationships)
Hints for Spatial Operators
Advanced Spatial Index Features
Function-Based Spatial Indexes
Local Partitioned Spatial Indexes
Parallel Indexing
Online Index Rebuilds
Spatial Joins
Three-Dimensional Analysis

Buffering Functions
Relationship Analysis Functions
SDO_DISTANCE
SDO_CLOSEST_POINTS
RELATE
Geometry Combination Functions
SDO_INTERSECTION
SDO_UNION
SDO_DIFFERENCE
SDO_XOR
Geometric Analysis Functions
Area, Length, and Volume Functions
MBR Functions
Miscellaneous Geometric Analysis Functions
Aggregate Functions
Aggregate MBR Function
Other Aggregate Functions

General Network Modeling Concepts
Examples of Networks
Oracle Network Data Model
Data Structures: The Network Tables

Node Table
Link Table
Path Table
Path Link Table
Network Metadata
Defining Networks

“Automatic” Network Definition
“Manual” Network Definition
Defining Multiple Networks on the Same Tables
Dropping a Network
Creating Spatial Indexes on Network Tables
Getting Information About a Network
Verifying Network Connectivity
Example Network
Analyzing and Managing Networks Using the Java API(Introduction)
Analyzing Networks Using the PL/SQL API
Using a Memory Object
Analyzing Networks
Creating and Updating Networks
Using Network Constraints
The Network Editor
Starting the Editor
Using the Loaded Network
Example Data: The Streets of San Francisco

Architecture
Installation and Configuration
Data Structures
Example Data: The Streets of San Francisco
Partitioning
Using the Router: XML Queries and Responses
Routing Requests
Routing Options
Pregeocoded Start and End Locations
Geographic Start and End Locations

Why Use Maps in Location-Enabled Applications?
Overview of MapViewer and Oracle Maps
Oracle MapViewer
Oracle Maps
Getting Started
Load the Sample Data
Location-Enable the Application Data
Load the Geographical Data
Load Maps, Themes, Style, and Map Cache Definitions for MapViewer
Define a Data Source
Install Example Applications
Configuring MapViewer
Using the Administration Console
Configuration Parameters
Defining Maps
Using Map Builder
Using Styles
Using Themes
Using Maps
Defining Map Caches
The USER_SDO_CACHED_MAPS View
Managing Caches Using the MapViewer Console
Creating a New Map Cache
Creating Map Caches Using SQL
Cache Data Structures
Exporting Cache Definitions
Purging and Refreshing Cache Contents
Using External Data Sources

Overview of MapViewer’s APIs
XML, Java, JSPs, and PL/SQL(Introduction)
JavaScript and Ajax: Oracle Maps(Introduction)
Choosing an API
Anatomy of a Map Request
What: The Information That Should Appear on the Map
Where: The Geographical Area to Be Covered by the Map
How: The Format and Size of the Resulting Map
Interacting with Maps
Controlling the Level of Detail: Zoom In and Zoom Out
Controlling the Area Shown on the Map: Pan and Recenter
Identify

Concepts and Definitions
Measure
Linear Referenced Segments
Direction
Shape Points
Offset
Typical Application
Creating Linear Referenced Geometries
SDO_GTYPE in LRS Geometries
Constructing LRS Geometries
Metadata
Spatial Indexes and Spatial Operators on LRS Geometries
Dynamic Segmentation Operations
Clip a Segment
Locate a Point
Project a Point
Intersecting LRS Segments with Standard Geometries
Validation of LRS Segments

Sharing Boundaries
Benefits of the Topology Data Model
Storing a Topology Data Model in Oracle
Operating on a Topology in Oracle
Creating a Topology
Populating a Topology
Associating a Feature Layer with a Topology
Inserting, Updating, and Populating Feature Layers
Updating Topological Elements
Querying for Topological Relationships

The SDO_GEORASTER Data Type
Storage for SDO_GEORASTER Data
Metadata in SDO_GEORASTER Data
Populating SDO_GEORASTER Columns
Manipulating Raster Objects
Generating Pyramids
Subsetting
Georeferencing