PacktLib: Applying and Extending Oracle Spatial

Applying and Extending Oracle Spatial

Credits

About the Authors

About the Reviewers

www.PacktPub.com

Preface

Defining a Data Model for Spatial Data Storage

Defining a sample schema

Implementing spatial constraints in the database

Constraints with asynchronous triggers

Summary

Importing and Exporting Spatial Data

Extract, transform, and load (ETL) tools

Storage resolution versus resolution used by functions

Creating spatial autocorrelation via clustering

Geometry validation and methods to clean imported data

Coordinate system transformation techniques

Spatial indexing

Exporting formats – GML, WKT, and GeoJSON

Summary

Using Database Features in Spatial Applications

Using row-level and statement-level triggers

Understanding materialized views

Logging changes independently of applications

Flashback queries

AWR reports

Database replay

Workspace Manager

SecureFiles compression

Summary

Replicating Geometries

Introducing different types of replication

Replicating data with materialized views

Streams based replication

Physical and logical standby database

OLTP and OLAP databases

Summary

Partitioning of Data Using Spatial Keys

Introduction to partitioning

Partitioning of spatial tables

Spatial partitioning of tables

Space curve based partitioning

Parallel queries and partitioning

High performance loading

Summary

Implementing New Functions

Background to programming SDO_GEOMETRY

Examining an SDO_GEOMETRY's dimensionality

Understanding and using SDO_ORDINATES

Understanding and using SDO_ELEM_INFO

Extracting and filtering SDO_GEOMETRY elements

Vectorizing geometries with linestrings

Packaging or encapsulation functions

Packaging summary

Summary

Editing, Transforming, and Constructing Geometries

Inserting, modifying, and deleting coordinates

Extending a linestring

Translating, rotating, scaling, and reflecting

Splitting linestring geometries – ST_Split

Moving/shifting lines parallel to the original object

Buffering one side of a linestring – ST_OneSidedBuffer

Tiling a vector geometry – ST_Tile

Adjusting coordinate dimensions

Summary

Using and Imitating Linear Referencing Functions

Understanding linear referencing and measures

Linear referencing functions to be developed

Summary

Raster Analysis with GeoRaster

Working with GeoRaster

Loading data into GeoRaster

Working with GeoRaster

Summary

Integrating Java Technologies with Oracle Spatial

Why Java and Oracle Spatial?

Sourcing available Java spatial technologies

Downloading the JTS source code

Creating Java Stored Procedures

Packaging – source code versus .jar file

Functions for processing two geometries

Processing a collection of geometries

A collection of useful functions

Performance of Java-based SQL processing

Summary

SQL/MM – A Basis for Cross-platform, Inter-operable, and Reusable SQL

Cross-platform representation

Geometry type implementation matrix

Constructing cross-database SQL

Programming for cross-database deployment

Summary

Table Comparing Simple Feature Access/SQL and SQL/MM–Spatial

Use of TREAT and IS OF TYPE with ST_GEOMETRY

Use of TREAT and IS OF TYPE with ST_GEOMETRY

Use of TREAT and IS OF TYPE with ST_GEOMETRY

Index