цена: 13000 руб.
Для юридических лиц: 13000 руб.

Чтобы забронировать место авторизуйтесь на сайте или пройдите регистрацию.

Oracle Spatial 11g Essentials

Код: 1Z0-595
продолжительность: 120 минут
Язык обучения: English
Тестовая система: Pearson VUE
Филиал: Москва


Exam Topics:

Oracle Spatial Concepts and Data Structures

  • Describe the data types, data models, coordinate systems, indexing structure, query model, and types of spatial queries
  • Describe the Oracle Spatial schema and how spatial data is represented in the database
  • Explain spatial metadata structures and views
  • Explain coordinate systems and unit support, including Oracle data structures

Loading and Validating Spatial Data

  • Load spatial data from text files using SQL Loader and external tables
  • Load spatial data from GIS files using Oracle Map Builder, Oracle shapefile loader and GDAL/OGR
  • Perform transactional inserts
  • Describe data validation and correction routines in Oracle Spatial
  • Use export and import utilities to move spatial data between databases
  • Move spatial data between databases by using transportable tablespaces

Indexing Spatial Data

  • Explain R-tree indexing concepts, how R-tree indexes are built, and index structures
  • Create indexes, set index parameters, and create indexes in parallel
  • Describe index metadata and find index size

Performing Spatial Queries

  • Explain the differences between spatial operators and spatial functions
  • Write queries to determine spatial relationships and return geometries using SDO_RELATE and SDO_FILTER operators
  • Write queries returning results within a specific distance and nearest neighbors
  • Write queries finding correlations between two spatial layers
  • Write queries combining spatial and non-spatial criteria

Performing Spatial Processing

  • Perform area, length, and distance calculations using spatial functions
  • Create buffers, combine geometries, and derive geometries
  • Use spatial aggregate functions
  • Describe the functions for arc densification and coordinate transformation
  • Use spatial utility functions
  • Describe the functions for conversion from/to OGC formats
  • Generate GML documents from spatial objects
  • Modify geometries using PL/SQL
  • Use the Java API to work with geometries

Oracle Fusion Middleware MapViewer

  • Explain the use of Oracle Fusion Middleware MapViewer
  • Describe the architecture of MapViewer
  • Install, configure, and administer MapViewer using OC4J and WebLogic Server
  • Define maps using styles, themes, and maps
  • Define and manage tile caches
  • Build applications using the Oracle Maps tutorial
  • Integrate external data
  • Define and access OGC Web Mapping Service and Web Feature Services

Geocoding, Routing, Spatial Analysis and Mining

  • Describe geocoding concepts, process, and functionality provided in Oracle Spatial
  • Describe the geocoding data model
  • Describe geocoding functions and structure of address results
  • Explain point addressing, structured address geocoding, and reverse geocoding
  • Install, configure, and use geocoding services with the XML API
  • Describe where to obtain data to use with the geocoding and routing engines
  • Describe the capabilities and architecture of the routing engine
  • Describe the routing engine tables
  • Install and configure the routing engine
  • Formulate XML route requests and describe the structure of route responses
  • Explain the concept of network partitioning
  • Partition the network used by the routing engine
  • Describe the uses and capabilities of the spatial analysis and mining functions

Web Services

  • Describe the four major Open Geospatial Consortium standards for spatial web services and the services they enable
  • Describe the architecture, configuration steps, and example queries for Web Mapping Service for Oracle Database
  • Describe the architecture, configuration steps, and example queries for Oracle Database for Web Feature Service
  • Use WMS/WFS themes in MapViewer applications
  • Describe the architecture, configuration steps, and example queries for Oracle Database for Open Location Services
  • Describe the architecture, configuration steps, and example queries for Oracle Database for Catalog Service
  • Explain the Oracle licensing requirements

Advanced Indexing (Partitioning, Parallelism, Function-Based Indexes)

  • Explain the concept of table and index partitioning
  • Describe the benefits of partitioning for spatial tables
  • Partition a spatial index using range partitioning
  • Partition spatial data based on location
  • Explain why spatial queries achieve performance benefits from partitioned indexes
  • Create indexes in parallel
  • Explain where parallel query is supported
  • Describe a spatial function-based index
  • Create a spatial function-based index

Using Linear Referencing and Network and Topology Models

  • Explain linear referencing concepts, use cases, and data structures
  • Convert geometries to LRS structures and use the main dynamic segmentation, point, and validation functions
  • Describe network modeling concepts, use cases, and data structures
  • Define, load, and manage networks in the Oracle Spatial network data model using the PL/SQL API
  • Explain the concept of load-on-demand and network partitioning
  • Describe network analysis functions available with the load-on-demand Java API for analysis
  • Use the network tutorial to build an application using network analysis
  • Describe topology data model concepts, advantages, use cases, and storage model
  • Define and load topologies, define features, and perform topology queries and editing using the PL/SQL and Java APIs


  • Describe raster data concepts
  • Describe the Oracle Spatial GeoRaster storage model, including logical and physical structures
  • Explain the compression techniques available and their benefits
  • Load, export, use, and manage rasters in Oracle Spatial GeoRaster
  • Use the open source GDAL/OGR library and tools to load and export rasters between other data formats and GeoRaster
  • View/manage raster data by using the features of the GeoRaster viewing tool
  • Describe the GeoRaster functions for managing and manipulating rasters, and the Java API features and functions
  • Describe available 3rd party and open source GeoRaster processing and analysis tools available
  • Use MapViewer to display rasters and overlay them with vectors

Managing 3D and Lidar Data

  • Describe 3D data concepts, objects/models supported by Oracle Spatial, coordinate systems, and data structures for modeling surfaces/solids
  • Explain the 3D operations available, and how to transform 2D data to 3D
  • Convert data into CityGML and KML for publishing and viewing, load CityGMLdata, and query 3D data using SQL
  • Describe point clouds and their storage model
  • Load point clouds and describe point cloud processing functions
  • Describe triangulated irregular network (TIN) concepts and storage model, and available functions for data management/extraction/conversion

Performance and Tuning / Exadata

  • Describe key tips on spatial indexing
  • Optimize your spatial queries
  • Explain best practices of the usage of spatial operators
  • Explain best practices of the usage of spatial functions
  • Describe how to best define your spatial data model
  • Describe best practices for spatial metadata, tolerance and coordinate systems usage
  • Explain best practices for spatial data loading and validation
  • Describe key spatial application considerations
  • Explain how to optimize Spatial on Exadata
  • Explain how Oracle Spatial is architected to exploit the processing power, bandwidth and parallelism of Exadata
  • Explain how Oracle Spatial on Exadata can ingest massive amounts of data from sensors, weather data, satellites and other streams

Workspace Manager

  • Explain Workspace Manager concepts, features, and architecture
  • Describe the concepts of versioning on a table and create, merge, refresh tables
  • Describe the concepts of administering privileges and locking, and detecting and resolving conflicts
  • Describe some 3rd party GIS tools that use Workspace Manager

По вашему запросу ничего не найдено. Попробуйте изменить условия поиска.

Оставить отзыв
Об этом экзамене отзывов пока нет. Будьте первым.