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