Oracle8<i>i</i> Spatial -- Index

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

BUILD_WINDOW_FIXED, 16-4

bulk loading, 3-1, 11-2

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

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

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

feature, Glossary-2

filter, 12-6

fixed indexing, 1-9

fixed-size tiles, 3-10, 11-7, 13-5, 13-14

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

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

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

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

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

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

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

query, 1-6, Glossary-5

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

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

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_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

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

union, 7-9

UPDATE_INDEX, 13-12

UPDATE_INDEX_FIXED, 13-14

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

WITHIN_DISTANCE, 7-15