Oracle Spatial 11g Essentials

Содержание

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