Oracle8i Spatial

Oracle8i Spatial User's Guide and Reference
Release 8.1.5
A67295-01

Library

Product

Index

Title and Copyright Information

Send Us Your Comments

Preface

1 Spatial Concepts

1.1 What Is the Spatial Product?

1.2 Introduction to Spatial Data

1.3 Geometric Types for Relational and Object-Relational Models

1.6.1 Tessellation of a Layer During Indexing

1.6.2 Fixed Indexing

1.6.3 Hybrid Indexing

1.7 Spatial Relations and Filtering

1.8 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_GEOM

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 Selecting a Spatial Model

A.1.1 Benefits of the Object-Relational Model

A.1.2 Benefits of the Relational Model

A.2 Tuning Tips

A.2.1 Data Modeling

A.2.2 Understanding the Tiling Level

A.2.3 Database Sizing

A.2.4 Visualizing the Spatial Index (Drawing Tiles)

A.2.4.1 Drawing Tiles from the Object-Relational Model

A.2.4.2 Drawing Tiles from the Relational Model

A.2.5 Performing Secondary Filter Queries and the Redo Log

A.2.6 Tuning Point Data with the Relational Model

A.2.6.1 Efficient Queries for Relational Point Data

A.2.6.2 Efficient Schema for Relational Point Layers

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

A.2.7 Tuning Spatial Join Queries Using the Relational Model

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

A.2.7.2 Spatial Join Queries with Point Layers

A.2.8 Using Customized Geometry Types in the Relational Model

A.2.9 Partitioning Spatial Data Using the Relational Model

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

A.3 Scripts for Spatial Indexing Using the Relational Model

A.3.1 cr_spatial_index.sql Script

A.3.2 crlayer.sql Script

A.4 Tools and Related Products

A.4.1 Oracle8i interMedia Locator

A.4.1.1 Geocoding Support

A.4.1.2 Compatibility with Spatial Objects

A.4.1.3 Sample Locator Code

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

A.4.2.1 Installation and Setup

A.4.2.2 Connecting to a Database and Viewing Geometries

A.4.2.3 Using the Sample Viewer

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

A.4.3.1 Compiling and Running the Sample Program

A.4.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

C Partitioning Legacy Point Data

Glossary

Library

Product

Index

Contents