Seminar Details

Oracle Spatial and Graph Essentials (D84584)

ETC
D84584
Hersteller-ID:
Prüfungs ID:
Dauer: 5 Tage
Preis: € 4.270.- exkl.MwST
Wissensgarantie: hier nicht automatisch anwendbar – bitte kontaktieren Sie Ihren Betreuer für Details
This course extensively covers the concepts and usage of the native data types, functions, and operators available in Oracle Database for spatial data.
Using the Map visualization component, students learn how to render maps and view geospatial data managed by Oracle Spatial and Graph. They are also introduced to basics of geocoding and routing concepts but the focus is more on introducing the students to basic analysis of spatial data.

This course does not cover Graph analysis.
Alle Details einblenden

Zielgruppe

  • Application Developers
  • Database Administrators
  • Technical Consultant
  • PL/SQL Developer

Vorkenntnisse

Suggested Prerequisite
  • Familiarity with Oracle SQL Developer and SQL*Plus
  • Good working knowledge of the SQL and PL/SQL
  • Familiarity with mathematical geometry concepts
  • Familiarity with Object relational data model

Schwerpunkte

Introduction
  • Oracle Location Technologies
  • Geometries Along Axis
  • Oracle Spatial and Graph and Oracle Locator: Implementation
  • Using Varying Arrays
  • Oracle Spatial and Graph Object-Relational Model
  • Oracle Spatial: Spatial Data Management for Enterprise Applications

Overview of Oracle Spatial and Graph Concepts
  • Spatial and Graph Data Model
  • Coordinate Systems: Concepts
  • Spatial and Graph Query
  • Linear Referencing System (LRS)
  • Geometric Primitive Types
  • Spatial and Graph Indexing
  • R-Tree: Generating Minimum Bounding Rectangles (MBR)
  • Types of Location Data

Creating Spatial Layers
  • Rules for Inserting Geometries in Spatial Layers
  • MDSYS Schema
  • Constructing Geometries
  • Spatial and Graph Native Data Type: SDO_GEOMETRY
  • Spatial and Graph Metadata
  • Geometry Objects

Defining Collection Geometries
  • Constructors for SDO_GEOMETRY with the WKT exampl
  • SDO_GEOMETRY Constructors
  • Rules for an Oriented Point
  • Oriented Point
  • Collection
  • SDO_ELEM_INFO Triplet Values

Associating Spatial Layers with Coordinate Systems
  • CS_SRS Table
  • Coordinate Systems in Oracle Spatial
  • Geodesic for Antipodal Points
  • Geodetic Optimized Rectangles
  • Whole Earth Geometry Model
  • Coordinate Systems
  • Polygons in a Geodetic Coordinate System
  • Common Coordinate Systems

Loading Spatial and Graph Data
  • Loading Spatial Data
  • Transactional Inserts
  • Bulk-Loading Data with SQL*Loader
  • Using Transportable Tablespaces
  • Data Pump Export and Import Utilities
  • Shapefile Converter
  • Limitations of Using the SDO_GEOMETRY Constructor in the INSERT statement
  • Log Output from Java Shapefile Converter

Validating and Debugging Geometries
  • VALIDATE_LAYER_WITH_CONTEXT Procedure
  • VALIDATE_GEOMETRY_WITH_CONTEXT Function with an Example
  • Validating Geometries and Functions
  • Modifying Geometries in PL/SQL
  • Geometry Debugging Functions

Using Oracle Spatial and Graph Map Visualization Component
  • Installation of Oracle Spatial and Graph Map Visualization Component
  • Debugging
  • Architecture of Oracle Spatial and Graph Map Visualization Component
  • MapVisualizer Demos
  • Introduction to MapViewer

Indexing Spatial Data
  • How Geometries Are Indexed with R-Trees
  • Analyzing Spatial and Graph Tables
  • R-Tree Index Sizing: Usage Notes and WORK_TABLESPACE
  • R-Tree Indexing
  • Spatial Index Dictionary Views

Querying Spatial Data
  • Spatial and Graph Operators
  • Spatial and Graph Topological Relationships
  • Relationship Operators
  • Using the ORDERED Optimizer Hint
  • Spatial and Graph Query Model
  • Spatial and Graph Procedures and Functions
  • Implicit Coordinate System Transformations
  • Primary and Secondary Filters

Using SDO_WITHIN_DISTANCE, SDO_NN, and SDO_JOIN Operators
  • Describe the SDO_WITHIN_DISTANCE operator
  • Describe the SDO_NN operator
  • Spatial Vector Acceleration
  • Spatial and Graph Operators
  • Spatial join by using the SDO_JOIN operator
  • Parallel with Spatial and Graph Operators and CREATE TABLE AS SELECT

Analyzing Geometries by Using Spatial Operators and Functions
  • Explicit Transformation with Spatial Functions
  • Spatial and Graph Boolean Functions
  • Arc Densification
  • Calculating the Distance Between Geometries
  • Calculating the Area and Length

Using Spatial Analysis, MBR, Utility, and Aggregate Functions
  • Java: Converting Geometries to and from GML
  • SDO_GEOM.SDO_MBR Function
  • GeoJSON and JSON
  • Using the DETERMINISTIC Keyword
  • Spatial Aggregate Functions
  • Functions that Return SDO_GEOMETRY and CREATE TABLE AS SELECT
  • SDO_UTIL Functions
  • Geography Markup Language (GML)

Defining Maps by Using the Map Builder Tool
  • USER_SDO_STYLES
  • MapVisualizer
  • MapVisualizer APIs
  • USER_SDO_MAPS
  • MapVisualizer Caches Style, Theme, and Map Definitions
  • Oracle Workspace Manager Support
  • USER_SDO_THEMES
  • OGC Web Map Service (WMS) Support

Leveraging Oracle Maps: The Map Cache and JavaScript API
  • Map Cache
  • Oracle Maps interactive demos
  • Oracle Maps

Implementing a Linear Referencing System
  • Associating Measure Values Along a Geometry
  • Overview of LRS Functions
  • LRS Terms and Concepts
  • Defining LRS Structures
  • Creating an LRS Geometry
  • Linear Referencing System: Transportation Application
  • Linear Referencing System Concepts
  • LRS Support for Collections

Managing Spatial Indexes
  • Spatial Index Partitioning Parameters
  • Oracle Spatial Index Partitioning
  • Oracle Table Partitioning and Oracle Spatial
  • Embedded Spatial Geometry
  • Transportable-Tablespace Support for Spatial Indexes
  • Spatial Partition Pruning
  • Combining Nonspatial and Spatial Partitioning
  • Function-Based Indexes

Geocoding Address Data
  • SDO_KEYWORDARRAY, SDO_GEO_ADDR, and SDO_ADDR_ARRAY types
  • Oracle Spatial Geocoding Functions
  • Geocoding Concepts
  • Geocoding service

Using the Spatial Routing Engine
  • Oracle Spatial Routing Architecture
  • Route request and response
  • Sample RouteServer JSP
  • Routing Engine Request
Alle Details ausblenden

Termin Anfragen

    Durch Angabe Ihrer E-Mail-Adresse und Anklicken des Buttons „Newsletter abonnieren“ erklären Sie sich damit einverstanden, dass ETC Ihnen regelmäßig Informationen zu IT Seminaren und weiteren Trainings- und Weiterbildungsthemen zusendet. Die Einwilligung kann jederzeit bei ETC widerrufen werden.

Ihre Fragen zum Seminar

CHAT mit Experten ODER Rückruf anfordern

Kein passender Termin dabei? Mehr als 5 Personen? Firmentermin gewünscht?

Rufen sie uns an +43/1/533 17 77 - 99

Bewertungen

Bisher keine Bewertungen