خانه
اخبار
معرفی دوره‌ها
تقویم آموزشی
مراحل ثبت نام
درباره ما
تماس با ما
  
 
معرفی دوره‌ها
Database Administration | Application Development | Business Intelligence | JDeveloper | Application Server | Designer | SOA

Oracle Spatial 10g: Fundamentals and Advanced


What you will learn:

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 and teaches the advanced features of Oracle Spatial. New features of Oracle Spatial 10g that simplify spatial queries, application development, and deployment are also covered. This course covers the advanced Spatial indexing features, including local partitioned spatial indexes, function based spatial indexes, and spatial indexes on embedded spatial objects within objects. Other topics teach how to use Oracle Spatial GeoRaster, Oracle Spatial's open solution for storing digital imagery and grid data in the database, as well as how to display raster data with Oracle Application Server MapViewer. This course explains how to use Oracle Spatial's Geocoder to return location information based on address data, and Oracle Spatial's Router to generate driving directions between locations.

Additionally, one learns how Oracle Spatial Topology Data Model stores topology information in the database, as well as the Oracle Spatial Network Data Model, which stores network information in the database for graph analysis. This course also covers Spatial Analysis and Mining and Oracle Workspace Manager.

This course counts towards the Hands-on course requirement for the Oracle Database 10g Administrator Certification. Only instructor-led inclass or instructor-led online formats of this course will meet the Certification Hands-on Requirement. Self Study CD-Rom and Knowledge Center courses are excellent study and reference tools but DO NOT meet the Hands-on Requirement for certification.

Learn To:
  • Model and load data into Oracle Spatial
  • Implement spatial queries
  • Index and tune spatial data
  • Perform spatial analysis
  • Validate spatial data
  • Use MapViewer to publish raster (and vector) data on the web
  • Create a topology
  • Perform graph analysis

Audience:

  • Technical Consultant

Prerequisites:

Suggested Prerequisites:

  • DBA experience
  • Understanding of PL/SQL

Course Objectives:

  • Describe SDO_GEOMETRY, the native data type for spatial data in Oracle
  • Describe the geometric primitives supported by SDO_GEOMETRY
  • Understand coordinate systems in Oracle Spatial
  • Model and Load data into Oracle Spatial
  • Validate spatial data, and debug/fix invalid geometries
  • Index and tune spatial data
  • Describe the Oracle Spatial query model
  • Implement spatial queries with SQL using spatial operators
  • Perform spatial analysis with spatial functions and procedures
  • Geocode address data with Oracle Spatial's Geocoder
  • Use Oracle Spatial's linear referencing capabilities
  • Publish maps to the web with Oracle Application Server MapViewer
  • Describe the basic changes between Oracle9i Spatial and Oracle Spatial 10g
  • Understand Transportable Tablespaces and Spatial Indexes
  • Describe Oracle Spatial GeoRaster Concepts
  • Understand the Oracle Spatial GeoRaster storage model
  • Describe Oracle Spatial Geocoder in the server Geocoding Architecture and GeoCoding Function
  • Describe Oracle Spatial Router and the Routing Architecture
  • Describe the Oracle Spatial Topology Data Model
  • Understand how to create and load and edit a Topology
  • Understand the Oracle Spatial Network Data Model and Network Concepts
  • Use the Network Data Model to perform graph analysis
  • Understand Oracle Spatial Analysis and Mining features

Course Topics:

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

  • MapViewer associated metadata
  • Map Definition tool to define a map
  • Publish maps to web

Advanced Coordinate System 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

Oracle Spatial 10g: Advanced: Introduction

  • Course Overview

Advanced Spatial Indexing

  • Create partitioned spatial indexes
  • Discuss spatial partitioning of data
  • Export and import transportable tablespaces that include spatial indexes
  • Create function-based indexes
  • Embed and index spatial objects within objects

Oracle Spatial GeoRaster

  • Describe what raster data is
  • Explain Oracle Spatial GeoRaster concepts
  • Discuss Oracle Spatial GeoRaster storage
  • Load GeoRaster data
  • View GeoRaster data using MapViewer

Oracle Spatial Geocoding

  • Explain geocoding concepts
  • Describe the Oracle Spatial Geocoding architecture
  • Describe Geocoding Metadata concepts
  • Detail Geocoding Reference Data concepts
  • Discuss Geocoding Schema Objects
  • Use geocoding functions

Oracle Spatial Routing Engine

  • Explain the Oracle Spatial Routing architecture
  • Describe how to formulate route requests
  • Describe the route response
  • Use the sample RouteServer JSP

Oracle Spatial Topology Data Model

  • Describe the Oracle Spatial Topology Data Model
  • Create a topology
  • Load topology primitives
  • Explain the topology feature model
  • Describe topology caches
  • Explain topology hierarchies
  • Discuss Spatial queries and topology
  • Share a topology between Oracle users

Oracle Spatial Network Data Model

  • Explain network concepts
  • Discuss the Oracle Spatial Network Data Model
  • Describe node, link, and path tables
  • Detail the network metadata
  • Include geometry data in a network
  • List the types of analysis done in the Oracle Spatial Network Data Model
  • Identify network constraints

Spatial Analysis and Mining

  • Neighborhood Analysis
  • Spatial Binning
  • Spatial Clustering


عصر آموزش پناپند -  1391