Oracle8 Spatial Cartridge User's Guide and Reference
Release 8.0.4
A53264-02

Contents

Title and Copyright Information

Send Us Your Comments

Preface

1 Spatial Cartridge Concepts

1.1 Introduction to Spatial Data

1.2 Geometric Types

1.4 Database Structures

1.5 Indexing Methods

1.5.1 Tessellation of a Layer

1.5.2 Fixed-Size Tile Spatial Indexing

1.5.3 Variable-Sized Tile Spatial Indexing

1.6 Partitioned Point Data

2 Loading Spatial Data

2.2 Load Process

2.2.1 Bulk Loading

2.2.2 Transactional Insert Using SQL

2.2.3 Transactional Insert Using Spatial Geometry Functions

2.3 Index Creation

2.3.1 Choosing a Tessellation Algorithm

2.3.2 Spatial Indexing with Fixed-Size Tiles

2.3.3 Spatial Indexing with Variable-Sized Tiles

3 Querying Spatial Data

3.1 Query Model

3.2 Spatial Data Model

3.3 Spatial Query

3.3.1 Dynamic Query Window

3.3.2 Primary Filter

3.3.3 Secondary Filter

3.4 Spatial Join

4 Partitioning Point Data

4.2 Partitioning Process

4.3 Function Details

5 Administrative Procedures

SDO_ADMIN.POPULATE_INDEX

SDO_ADMIN.POPULATE_INDEX_FIXED

SDO_ADMIN.SDO_CODE_SIZE

SDO_ADMIN.UPDATE_INDEX

SDO_ADMIN.UPDATE_INDEX_FIXED

SDO_ADMIN.VERIFY_LAYER

Partitioned Point Data Procedures

SDO_ADMIN.ALTER_HIGH_WATER_MARK

SDO_ADMIN.DROP_PARTITION_INFO

SDO_ADMIN.PARTITION

SDO_ADMIN.PROPAGATE_GRANTS

SDO_ADMIN.REGISTER_PARTITION_INFO

SDO_ADMIN.REPARTITION

SDO_ADMIN.VERIFY_PARTITIONS

6 Tuning Functions

SDO_TUNE.ESTIMATE_TILING_LEVEL

SDO_TUNE.EXTENT_OF

7 Geometry Functions

SDO_GEOM.ADD_NODES

SDO_GEOM.INIT_ELEMENT

SDO_GEOM.INTERACT

SDO_GEOM.RELATE

SDO_GEOM.VALIDATE_GEOMETRY

8 Window Functions

SDO_WINDOW.BUILD_WINDOW

SDO_WINDOW.BUILD_WINDOW_FIXED

SDO_WINDOW.CLEAN_WINDOW

SDO_WINDOW.CREATE_WINDOW_LAYER

9 Partitioned Point Data Functions

SDO_BVALUETODIM

A Sample SQL Scripts and Tuning Tips

A.1 Sample SQL Scripts

A.1.1 Scripts for Spatial Indexing

A.1.1.1 cr_spatial_index.sql Script

A.1.1.2 crlayer.sql Script

A.1.2 Scripts for Partitioned Point Data

A.1.2.1 altpart.sql Script

A.1.2.2 drppart.sql Script

A.1.2.3 sdogrant.sql Script

A.2 Tuning Tips

A.2.1 Data Modeling

A.2.2 Understanding the Tiling Level

A.2.3 Database Sizing

A.2.4 Tuning Point Data

A.2.4.1 Efficient Queries for Point Data

A.2.4.2 Efficient Schema for Point Layers

A.2.5 Tuning Spatial Join Queries

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

A.2.5.2 Spatial Join Queries with Point Layers

A.2.6 Using Customized Geometry Types

A.2.7 Performing Secondary Filter Queries and the Redo Log

A.2.8 Visualizing the Spatial Index (Drawing Tiles)

B Data Dictionary

C Messages and Codes

Glossary

Copyright © 1997 Oracle Corporation.
All Rights Reserved.