Oracle8i Spatial User's Guide and Reference
Release 8.1.5

A67295-01

Library

Product

Contents

Prev

Index

A  B  C  D  E  F  G  H  I  J  K  L  M  N  O  P  Q  R  S  T  U  V  W  X  Y  Z 


A

administrative procedures, 13-1
ALTER INDEX, 5-2
REBUILD, 5-5
RENAME TO, 5-8
ALTER_HIGH_WATER_MARK, C-5
altering partitions, C-3
altpart.sql, C-3
ANYINTERACT, 7-4, 15-3
arcs, A-13
AREA, 7-2
area, 7-2, Glossary-1
attribute, Glossary-1
AVERAGE_MBR, 6-2, 14-2

B

boundary, Glossary-1
bounded data, C-21
bounded value, C-14
buffer area, 7-6
BUILD_WINDOW, 16-2
BUILD_WINDOW_FIXED, 16-4
bulk loading, 3-1, 11-2

C

Cartesian, Glossary-1
circle, 2-5, A-13
CLEAN_WINDOW, 16-6
CLEANUP_GID, 16-7
consistency check, 7-11, 15-5
CONTAINS, 7-5, 15-3, Glossary-1
control file, 11-2
coordinate, Glossary-2
coordinate system, Glossary-2
COVEREDBY, 7-5, 15-3
COVERS, 7-5, 15-4, Glossary-2
cr_spatial_index.sql, A-15
CREATE INDEX, 5-9
CREATE_WINDOW_LAYER, 16-8
creating layer tables, A-16
crlayer.sql, A-16
customized geometry types, A-13

D

data, Glossary-2
data dictionary, 2-12, C-23, Glossary-7
data model, 1-4, A-2
DATE data type, C-17, C-22
decompose, Glossary-2
difference, 7-7
dimensional, Glossary-2
disjoint, 7-5, 15-4, Glossary-2
displaying geometries, A-18, A-19
distance, 7-15
DROP INDEX, 5-13
DROP_PARTITION_INFO, C-6
dropping partitions, C-3
drppart.sql, C-3
dynamic query window, 4-3, 12-4

E

element, 1-5
ENCLOSES, C-15
encoding dimensions, C-20
EQUAL, 7-5, 15-4, C-15, Glossary-2
error messages, xix
ESTIMATE_INDEX_PERFORMANCE, 6-3, 14-3
ESTIMATE_TILING_LEVEL, 6-5, 14-5
ESTIMATE_TILING_TIME, 6-7, 14-8
extent, 6-8, 14-9, Glossary-2
EXTENT_OF, 6-8, 14-9
extracting a dimension, C-19

F

feature, Glossary-2
filter, 12-6
fixed indexing, 1-9
fixed-size tiles, 3-10, 11-7, 13-5, 13-14

G

geocoding, A-16
Geographical Information System, Glossary-3
geometric primitive, 1-3
geometry types, 1-3
custom, A-13
object-relational, 2-2
relational, 10-3
georeferenced, Glossary-3
GIS, 1-2, Glossary-3
grants, C-4, C-9
grid, Glossary-3

H

HHCODE, Glossary-3
high water mark, C-5, Glossary-3
HISTOGRAM_ANALYSIS, 6-9, 14-10
hole in a polygon, Glossary-3
homogeneous, Glossary-3
hybrid indexing, 1-14
hyperspatial, Glossary-4

I

index, 13-3, 13-5, 13-12, 13-14, Glossary-4
index creation, 3-9, 11-6
in parallel, A-14
inserting spatial data, 11-4
INSIDE, 7-5, 15-4, C-15
interaction, 7-4, 15-3
interMedia Locator, A-16
intersection, 7-8

K

key, Glossary-4
keyword, Glossary-4

L

latitude, Glossary-4
layer, 1-6, A-16
validating, 7-13
LENGTH, 7-3
line, 2-5, Glossary-4
length, 7-3
line data, 1-5
loading process, 3-1, 11-2
in parallel, A-14
location, 1-2
longitude, Glossary-4

M

migration
OGIS, 8-5, 8-6
to Oracle7, 8-2
to Oracle8, 8-3
minimum bounding rectangle, 6-2, 6-8, 14-2, 14-9
MIX_INFO, 6-11, 14-12

O

object-relational model
schema, 2-1
operators
SDO_FILTER, 9-2
SDO_RELATE, 9-4
SDO_WITHIN_DISTANCE, 9-7
OUTSIDE, C-15
OVERLAP, C-15
OVERLAPBDYDISJOINT, 7-5, 15-4
OVERLAPBDYINTERSECT, 7-5, 15-4

P

parallel load, A-14
partition, C-7, Glossary-4, Glossary-5
partition key, C-1
partitioned table, C-1, C-3, C-6, C-7, C-10, Glossary-5
partitioned tables, 1-20, A-13
plotting tiles, A-4
PL/SQL, C-13
point data, 1-5, 13-8, A-8
polygon, 2-5, Glossary-5
area of, 7-2
polygon data, 1-5
POPULATE_INDEX, 13-3
POPULATE_INDEX_FIXED, 13-5
POPULATE_INDEX_FIXED_POINTS, 13-8
primary filter, 12-6
primitive, 1-3
PROPAGATE_GRANTS, C-9
proximity, Glossary-5

Q

query, 1-6, Glossary-5
query window, 4-3, 12-4, Glossary-5

R

RDBMS, Glossary-5, Glossary-6
rectangle, 2-5
recursion, Glossary-5
region, Glossary-5
REGISTER_PARTITION_INFO, C-10
RELATE, 7-4, 15-2
relational model
schema, 10-1
REPARTITION, C-11
resolution, Glossary-6

S

sample program, A-18, A-19
scale, Glossary-6
schema, 10-1
object-relational model, 2-1
relational model, 10-1
SD*Converter, Glossary-6
SD*Loader, Glossary-7
SDO_BUFFER, 7-6
SDO_BVALUETODIM, C-14
SDO_CODE_SIZE, 13-10
SDO_COMPARE, C-15
SDO_DATETODIM, C-17
SDO_DECODE, C-19
SDO_ENCODE, C-20
SDO_FILTER operator, 9-2
SDO_POLY_DIFFERENCE, 7-7
SDO_POLY_INTERSECTION, 7-8
SDO_POLY_UNION, 7-9
SDO_POLY_XOR, 7-10
SDO_RELATE operator, 9-4
SDO_TO_BVALUE, C-21
SDO_TO_DATE, C-22
SDO_VERSION, 13-11
SDO_WITHIN_DISTANCE operator, 9-7
sdogrant.sql, C-4
secondary filter, 12-7
server partitioning, C-1
SLF, Glossary-7
sort, Glossary-6
spatial data model, Glossary-6
spatial data structures, Glossary-7
object-relational model, 2-1
relational model, 10-1
spatial database, Glossary-6
sizing, A-3
spatial index, 3-9, 11-6, 13-12, 13-14
performance, 6-3, 14-3
spatial indexing
fixed, 1-9
hybrid, 1-14
spatial join, 4-8, 12-8, A-10
Spatial Load Format, Glossary-7
spatial query, 4-3, 12-4, Glossary-7
spatiotemporal, Glossary-7
SQL script, A-15, C-3
SQL*Loader, 3-1, 11-2

T

table partitioning, 1-20, C-1
tessellation, 1-9, 11-6, 13-3, 13-5, 13-12, 13-14, Glossary-7
tile, 1-8, 4-1, 12-1
tiling, 6-5, 13-14, 14-5, A-2, Glossary-7
TOUCH, 7-5, 15-4, Glossary-7
transactional insert, 3-3, 11-4
two-tier query, 1-6, 4-1, 12-1

U

union, 7-9
UPDATE_INDEX, 13-12
UPDATE_INDEX_FIXED, 13-14

V

VALIDATE_GEOMETRY, 7-11, 15-5
VALIDATE_LAYER, 7-13
VERIFY_LAYER, 13-16
VERIFY_PARTITIONS, C-12
visualizing geometries, A-18, A-19
visualizing tiles, A-4, A-19

W

WITHIN_DISTANCE, 7-15


Prev
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents