Oracle Spatial: Essentials (D56709) – Outline

Detailed Course Outline

Introduction

• Oracle Database: Location Features
• Oracle Spatial: Spatial Data Management for Enterprise Applications
• Oracle Spatial Development History
• Oracle Spatial and Locator: art of the Oracle DBMS Kernel
• Oracle Spatial Object-Relational Model
• Review: Oracle’s Object-Relational Model
• Common Geographical Terms Used in the Course
• Oracle Spatial Documentation and Resources

Overview of Oracle Spatial Concepts

• Define Oracle Spatial
• Describe Geometric Primitive Types
• Describe the Spatial Data Model
• Coordinate Systems: Concepts
• Explain Spatial Indexing
• Describe the Optimized Query Model
• Define Linear Referencing System
• Define Geocoding and Routing

Creating Spatial Layers

• Describe the MDSYS Schema
• Spatial Native Data Type: SDO_GEOMETRY
• Define different types of geometry elements
• Construction of geometries by using the INSERT statement
• Manage Spatial metadata

Defining Collection Geometries

• Define Collection geometries: Multipoint, Multiline string, and Multipolygon
• Describe Oriented point
• SDO_GEOMETRY constructors and member methods

Associating Spatial Layers with Coordinate Systems

• Define Coordinate systems and their different types
• Geodetic coordinate system concepts
• Whole earth geometry model and tolerance
• Coordinate system transformations
• Units supported by Oracle Spatial

Loading Spatial Data

• Different ways of loading spatial data
• Loading of spatial data by using SQL*Loader
• Export and import utilities of the Data Pump technology
• Load data using transportable tablespace
• Load data using transactional insert
• Use the Java shapefile converter

Validating and Debugging Geometries

• Validation functions: SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXT and SDO_GEOM.VALIDATE_LAYER_WITH_CONTEXT
• Geometry debugging functions: SDO_UTIL.GETVERTICES, SDO_UTIL.RECTIFY_GEOMETRY, and SDO_UTIL.EXTRACT
• Strategy for Geometry Validation

Using the Oracle Application Server MapViewer

• Introduction to MapViewer
• Architecture of Oracle Application Server MapViewer
• Installation of Oracle Application Server MapViewer
• Use MapViewer demos
• Edit MapViewer Configuration File

Indexing Spatial Data

• Concepts of R-tree indexing
• CREATE INDEX and the R-tree parameters
• Analyze, drop, and alter operations on the spatial index
• Use the Spatial index dictionary views
• Estimate R-tree index size and the resources required

Querying Spatial Data

• Overview of the Spatial query model
• Overview of spatial operators, procedures, and functions
• Use the SDO_FILTER operator
• Define Spatial topological relationships
• Use the SDO_RELATE operator
• Use the SDO_GEOM.RELATE function

Using SDO_WITHIN_DISTANCE, SDO_NN, and SDO_JOIN Operators

• Spatial queries and operators
• Describe the SDO_WITHIN_DISTANCE operator
• Describe the SDO_NN operator
• Spatial join by using the SDO_JOIN operator

Analyzing Geometries by Using Spatial Operators and Functions

• Calculation of the area, length, and distance between geometries
• Describe Arc densification and buffering
• Use the Spatial Boolean functions
• Explicit transformations with spatial functions

Using Spatial Analysis, MBR, Utility, and Aggregate Functions

• Describe some of the Spatial analysis functions
• Describe some of the Spatial MBR functions
• Describe some of the Spatial utility functions
• Describe some of the Spatial aggregate functions
• Conversion between SDO_GEOMETRY and Geography Markup Language (GML)

Defining Maps by Using the Map Builder Tool

• Introduction to Map Builder
• Export and import styles
• Use of Map Builder to administer style, theme, and map definitions
• Use the Sample mapclient.jsp
• Define a Sample XML request with elements
• Open Geospatial Consortium (OGC) Web Map Service (WMS) and Oracle Workspace Manager support

Leveraging Oracle Maps: The Map Cache and JavaScript API

• Oracle Maps concepts
• Oracle Maps demo setup
• Maps and Faces demo
• More Oracle Maps demos

Creating a User-Defined Coordinate System

• Coordinate systems concepts: Ellipsoids, Datums, and projections
• Geodetic or projected coordinate systems
• Define OGC WKT schema and EPSG
• Creation of a user-defined coordinate system
• Local coordinate system

Implementing a Linear Referencing System

• Linear Referencing System (LRS) concepts
• Define LRS geometries
• Overview of LRS functions
• Implementation of an LRS

Managing Spatial Indexes

• Oracle Spatial index partitioning
• Partition spatial data based on location
• Define function-based indexes
• Use transportable tablespaces
• Embedded spatial geometry

Geocoding Address Data

• Geocoding concepts
• Oracle Spatial geocoding functions
• SDO_KEYWORDARRAY, SDO_GEO_ADDR, and SDO_ADDR_ARRAY types
• Examples using geocoding functions
• Geocoding service

Using the Spatial Routing Engine

• Oracle Spatial Routing architecture
• Route request and response
• Sample RouteServer JSP