Oracle Spatial: Essentials Quick Start

The course covers the concepts and usage of the native data types, functions and operators available in Oracle Spatial for implementing geospatial applications and location-based services.

Using the Oracle Application Server MapViewer, students learn how to render maps and view geospatial data managed by Oracle Spatial or Locator.
Demonstrations and hands-on practice reinforce the fundamental concepts.

Learn to:

• Run spatial queries to perform spatial analysis
• Use MapViewer and the Map Builder tool to render maps
• Load geometries into spatial layers
• Create spatial layers by using the SDO_GEOMETRY data type
• Employ spatial operators and functions to generate and access 2D geometries

Audience

• PL/SQL Developer
• Application Developers
• Technical Consultant
• Technical Administrator

Course Topics 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

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)

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

Course Objectives

• Enhance and tune spatial indexes for better performance
• Describe the linear referencing system
• Describe Oracle Spatial geocoding and routing concepts
• Describe the Oracle Spatial data and query models
• Create spatial layers by using the SDO_GEOMETRY data type
• Load geometries into spatial layers
• Employ spatial operators and functions to generate and access 2D geometries
• Describe the various types of coordinate systems
• Run spatial queries to perform spatial analysis