Applying and Extending Oracle Spatial

This guide takes you straight into the attributes of Oracle Spatial and teaches you to extend, apply, and combine them with other Oracle and open source technologies. A vital manual for solving everyday problems.

Applying and Extending Oracle Spatial

Starting
Simon Greener, Siva Ravada

This guide takes you straight into the attributes of Oracle Spatial and teaches you to extend, apply, and combine them with other Oracle and open source technologies. A vital manual for solving everyday problems.
$10.00
$59.99
RRP $35.99
RRP $59.99
eBook
Print + eBook
$12.99 p/month

Get Access

Get Unlimited Access to every Packt eBook and Video course

Enjoy full and instant access to over 3000 books and videos – you’ll find everything you need to stay ahead of the curve and make sure you can always get the job done.

+ Collection
Free Sample

Book Details

ISBN 139781849686365
Paperback568 pages

About This Book

  • Understand how to develop Oracle Spatial data models and applications that use PL/SQL and Java to solve common problems using practical, hands-on examples
  • Design a data model for spatial applications
  • Use standard database technologies for managing Spatial data
  • Learn how to combine spatial and non-spatial data in the database
  • Get to grips with how to use Oracle Spatial's standards compliant geometry data types to develop cross-vendor database solutions to common problems

Who This Book Is For

This book is for existing users of Oracle and Oracle Spatial and so assumes you have a basic knowledge of Oracle in terms of understanding the SDO_GEOMETRY type, creating tables, indexes, and views, executing basic to moderately complex queries, and some idea of PL/SQL programming of triggers and stored procedures.

Table of Contents

Chapter 1: Defining a Data Model for Spatial Data Storage
Defining a sample schema
Implementing spatial constraints in the database
Constraints with asynchronous triggers
Summary
Chapter 2: 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
Chapter 3: 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
Chapter 4: 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
Chapter 5: 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
Chapter 6: 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
Chapter 7: 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
Chapter 8: Using and Imitating Linear Referencing Functions
Understanding linear referencing and measures
Linear referencing functions to be developed
Summary
Chapter 9: Raster Analysis with GeoRaster
Working with GeoRaster
Loading data into GeoRaster
Working with GeoRaster
Summary
Chapter 10: 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
Chapter 11: 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

What You Will Learn

  • Design a data model for a spatial application
  • „Build and use database triggers that manage data validation and other tasks
  • „Use Oracle's materialized view, replication, and PL/SQL technologies with a spatial database
  • „Understand and use Oracle's raster data management technology to implement solutions within a range of applications
  • „Explore advanced queuing for managing spatial data processing
  • „Apply linear referencing programming to solve business problems
  • „Discover Oracle's OGC and SQLMM-compliant geometry types when implementing solutions capable of cross-vendor database deployment
  • „Use partitioning to manage large spatial datasets in the database
  • „Load spatial data (raster and vector) from different data sources in the database

In Detail

Spatial applications should be developed in the same way that users develop other database applications: by starting with an integrated data model in which the SDO_GEOMETRY objects are just another attribute describing entities and by using as many of the database features as possible for managing the data. If a task can be done using a database feature like replication, then it should be done using the standard replication technology instead of inventing a new procedure for replicating spatial data. Sometimes solving a business problem using a PL/SQL function can be more powerful, accessible, and easier to use than trying to use external software. Because Oracle Spatial's offerings are standards compliant, this book shows you how Oracle Spatial technology can be used to build cross-vendor database solutions.

Applying and Extending Oracle Spatial shows you the clever things that can be done not just with Oracle Spatial on its own, but in combination with other database technologies. This is a great resource book that will convince you to purchase other Oracle technology books on non-spatial specialist technologies because you will finally see that "spatial is not special: it is a small, fun, and clever part of a much larger whole".

Authors

Table of Contents

Chapter 1: Defining a Data Model for Spatial Data Storage
Defining a sample schema
Implementing spatial constraints in the database
Constraints with asynchronous triggers
Summary
Chapter 2: 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
Chapter 3: 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
Chapter 4: 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
Chapter 5: 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
Chapter 6: 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
Chapter 7: 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
Chapter 8: Using and Imitating Linear Referencing Functions
Understanding linear referencing and measures
Linear referencing functions to be developed
Summary
Chapter 9: Raster Analysis with GeoRaster
Working with GeoRaster
Loading data into GeoRaster
Working with GeoRaster
Summary
Chapter 10: 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
Chapter 11: 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

Book Details

ISBN 139781849686365
Paperback568 pages
Read More