Oracle8 Spatial Cartridge Oracle8 Spatial Cartridge User's Guide and Reference
Release 8.0.5

A53264-03

Library

Product

Next

Contents

Title and Copyright Information

Contents

Send Us Your Comments

Preface

1 Spatial Cartridge Concepts

1.1 Introduction to Spatial Data
1.2 Geometric Types
1.3 Data Model
1.3.1 Element
1.3.2 Geometry
1.3.3 Layer
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.1 Load Model
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.1 Overview
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.CLEANUP_GID
SDO_WINDOW.CREATE_WINDOW_LAYER

9 Partitioned Point Data Functions

SDO_BVALUETODIM
SDO_COMPARE
SDO_DATETODIM
SDO_DECODE
SDO_ENCODE
SDO_TO_BVALUE
SDO_TO_DATE

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



Next
Oracle
Copyright © 1998 Oracle Corporation.

All Rights Reserved.

Library

Product