Oracle Spatial User's Guide and Reference -- Contents

Title and Copyright Information

Send Us Your Comments

Preface

Intended Audience

Structure

New Features for Release 8.1.6

Features Released Separately

1 Spatial Concepts

1.1 What Is the Spatial Product?

1.2 Object-Relational and Relational Models

1.2.1 Benefits of the Object-Relational Model

1.2.2 Benefits of the Relational Model

1.3 Introduction to Spatial Data

1.4 Geometric Types for Relational and Object-Relational Models

1.7.1 Tessellation of a Layer During Indexing

1.7.2 Fixed Indexing

1.7.3 Hybrid Indexing

1.8 Spatial Relations and Filtering

1.9 Partitioned Point Data

Part I Object-Relational Model

Part II Relational Model

10 The Relational Schema

10.1 Database Structures for the Relational Implementation

11 Loading Spatial Data

11.1 Load Model

11.2 Load Process

11.2.1 Bulk Loading

11.2.2 Transactional Insert Using SQL

11.3 Index Creation

11.3.1 Choosing a Tessellation Algorithm

11.3.2 Spatial Indexing with Fixed-Size Tiles

11.3.3 Hybrid Spatial Indexing with Fixed-Size and Variable-Sized Tiles

12 Querying Spatial Data

12.1 Query Model

12.2 Spatial Index Data Structures

12.3 Spatial Query

12.3.1 Dynamic Query Window

12.3.2 Primary Filter Query

12.3.3 Secondary Filter Query

12.4 Spatial Join

13 Administrative Functions and Procedures

SDO_ADMIN.POPULATE_INDEX

SDO_ADMIN.POPULATE_INDEX_FIXED

SDO_ADMIN.POPULATE_INDEX_FIXED_POINTS

SDO_ADMIN.SDO_CODE_SIZE

SDO_ADMIN.SDO_VERSION

SDO_ADMIN.UPDATE_INDEX

SDO_ADMIN.UPDATE_INDEX_FIXED

SDO_ADMIN.VERIFY_LAYER

14 Tuning Functions and Procedures

SDO_TUNE.AVERAGE_MBR

SDO_TUNE.ESTIMATE_INDEX_PERFORMANCE

SDO_TUNE.ESTIMATE_TILING_LEVEL

SDO_TUNE.ESTIMATE_TILING_TIME

SDO_TUNE.EXTENT_OF

SDO_TUNE.HISTOGRAM_ANALYSIS

SDO_TUNE.MIX_INFO

15 Geometry Functions and Procedures

SDO_GEOM.RELATE

SDO_GEOM.VALIDATE_GEOMETRY

SDO_GEOM.VALIDATE_LAYER

16 Window Functions and Procedures

SDO_WINDOW.BUILD_WINDOW

SDO_WINDOW.BUILD_WINDOW_FIXED

SDO_WINDOW.CLEAN_WINDOW

SDO_WINDOW.CLEANUP_GID

SDO_WINDOW.CREATE_WINDOW_LAYER

A Tuning Tips and Sample SQL Scripts

A.1 Tuning Tips

A.1.1 Data Modeling

A.1.2 Understanding the Tiling Level

A.1.3 Using Hybrid Indexes (Object-Relational Model Only)

A.1.4 Database Sizing

A.1.5 Visualizing the Spatial Index (Drawing Tiles)

A.1.5.1 Drawing Tiles from the Object-Relational Model

A.1.5.2 Drawing Tiles from the Relational Model

A.1.6 Setting the SORT_AREA_SIZE Value

A.1.7 Tuning Point Data with the Relational Model

A.1.7.1 Efficient Queries for Relational Point Data

A.1.7.2 Efficient Schema for Relational Point Layers

A.1.7.3 Script for Using Table Partitioning with Relational Point Data

A.1.8 Tuning Spatial Join Queries Using the Relational Model

A.1.8.1 Using the NO_MERGE, INDEX, and USE_NL Hints

A.1.8.2 Spatial Join Queries with Point Layers

A.1.9 Using Customized Geometry Types in the Relational Model

A.1.10 Partitioning Spatial Data Using the Relational Model

A.1.11 Parallel Loading and Indexing of Spatial Data Using the Relational Model

A.2 Scripts for Spatial Indexing Using the Relational Model

A.2.1 cr_spatial_index.sql Script

A.2.2 crlayer.sql Script

A.3 Tools and Related Products

A.3.1 Oracle8i interMedia Locator

A.3.1.1 Geocoding Support

A.3.1.2 Compatibility with Spatial Objects

A.3.1.3 Sample Locator Code

A.3.2 Spatial Viewer on UNIX/Motif for Relational Model

A.3.2.1 Installation and Setup

A.3.2.2 Connecting to a Database and Viewing Geometries

A.3.2.3 Using the Sample Viewer

A.3.3 Spatial Visualizer on Windows NT for the Object-Relational Model

A.3.3.1 Compiling and Running the Sample Program

A.3.3.2 Usage Notes

B Installation, Compatibility, and Migration Issues

B.1 Introduction

B.2 Installation Details

B.2.1 Changing from 8.1 to 8.0 Compatibility Mode

B.3 Compatibility Details

B.4 Data Migration Issues

B.5 Migrating from Spatial Release 8.1.5 to 8.1.6

B.5.1 Data Migration

B.5.2 Compatibility Between Releases 8.1.5 and 8.1.6

C Generic Geocoding Interface

C.1 interMedia Locator Implementation: Benefits and Limitations

C.2 Generic Geocoding Client

C.3 Geocoder Metadata

C.3.1 Server Properties

C.3.2 Geocoding Input and Output Specification

C.3.2.1 Multiple Matches and Rejected Records

C.4 Metadata Helper Class

C.5 Single-Record and Interactive Geocoding

C.6 Java Geocoder Service Interface

C.7 Enabling Third-Party Geocoders