Oracle7 Spatial Data Option User's Guide and Reference Go to Product Documentation Library
Library
Go to books for this product
Product


Title

Table of Contents

Preface

1 Spatial Data Option 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 Loading 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 Partitioned 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.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 Hints

A.1 Sample SQL Scripts
A.1.1 altpart.sql Script
A.1.2 cr_spatial_index.sql Script
A.1.3 crlayer.sql Script
A.1.4 drppart.sql Script
A.1.5 sdogrant.sql Script
A.2 Tuning Tips and Tricks
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.5 Efficient Queries for Point Data
A.2.6 Efficient Queries for Line and Polygon Data
A.2.7 Using Customized Geometry Types

B Data Dictionary

C Messages and Codes

Glossary


Oracle Corporation
Copyright © 1997 Oracle Corporation
500 Oracle Parkway, Redwood City, CA 94065


Go to Product Documentation Library
Library
Go to books for this product
Product