Oracle7 Spatial Data Option User's Guide and Reference

Oracle7 Spatial Data Option User's Guide and Reference

Oracle7 Spatial Data Option User's Guide and Reference

1 Spatial Data Concepts

1.1 Introduction to Spatial Data

1.2 Geometric Types

: 1.3.1 Element
: 1.3.2 Geometry
: 1.3.3 Layer

1.4 Database Structures

1.5 Indexing Method

1.6 Partitioned Point Data

2 Loading Spatial Data

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 Indexing With Fixed-Size Tiles

3 Querying Spatial Data

3.1 Query Model

3.2 Spatial Data Model

3.3 Spatial Query

: 3.3.1 Primary Filter
: 3.3.2 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.ALTER_HIGH_WATER_MARK
: SDO_ADMIN.DROP_PARTITION_INFO
: SDO_ADMIN.PARTITION
: SDO_ADMIN.POPULATE_INDEX
: SDO_ADMIN.POPULATE_INDEX_FIXED
: SDO_ADMIN.PROPAGATE_GRANTS
: SDO_ADMIN.REGISTER_PARTITION_INFO
: SDO_ADMIN.REPARTITION
: SDO_ADMIN.SDO_CODE_SIZE
: SDO_ADMIN.UPDATE_INDEX
: SDO_ADMIN.UPDATE_INDEX_FIXED
: SDO_ADMIN.VERIFY_LAYER
: SDO_ADMIN.VERIFY_PARTITIONS

6 Geometry Functions

: SDO_GEOM.ADD_NODES
: SDO_GEOM.INIT_ELEMENT
: SDO_GEOM.INTERACT
: SDO_GEOM.RELATE
: SDO_GEOM.VALIDATE_GEOMETRY

7 Window Functions

: SDO_WINDOW.BUILD_WINDOW
: SDO_WINDOW.BUILD_WINDOW_FIXED
: SDO_WINDOW.CLEAN_WINDOW
: SDO_WINDOW.CREATE_WINDOW_LAYER

8 Partitioned Point Data Functions

: SDO_BVALUETODIM
: SDO_COMPARE
: SDO_DATETODIM
: SDO_DECODE
: SDO_ENCODE
: SDO_TO_BVALUE
: SDO_TO_DATE

A Sample SQL Scripts

: A.1 altpart.sql Script
: A.2 crlayer.sql Script
: A.3 droppart.sql Script
: A.4 sdogrant.sql Script

B Data Dictionary

C Messages and Codes

D Last Supported Releases

: D.1 SD*SQL Kernel Functions
: D.2 SD*SQL Packages

E Unsupported Functions

Glossary

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