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.

Key Features

• 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

Book Description

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

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.