цена: | 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
GeoRaster
- 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
По вашему запросу ничего не найдено. Попробуйте изменить условия поиска.
Оставить отзыв
Об этом экзамене отзывов пока нет. Будьте первым.