Index

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

---

Numerics

8.1.6

migrating to, 8-2

new features, xviii

---

A

administrative procedures, 13-1

ALL_SDO_GEOM_METADATA view, 2-17

ALL_SDO_INDEX_METADATA view, 2-19

ALTER INDEX, 5-2

REBUILD, 5-5

RENAME TO, 5-8

ANYINTERACT, 7-5, 15-3

arcs, A-13

area, 7-7

average minimum bounding rectangle, 6-2

AVERAGE_MBR, 6-2, 14-2

---

B

batch geocoding, C-4

bounding rectangle

minimum, 6-14

buffer area, 7-9

BUILD_WINDOW, 16-2

BUILD_WINDOW_FIXED, 16-4

bulk loading, 3-1, 11-2

---

C

center of gravity (centroid), 7-11

centroid, 7-11

circle, 2-11, A-13

CLEAN_WINDOW, 16-6

CLEANUP_GID, 16-7

compound element, 2-9

consistency check, 7-41, 15-5

CONTAINS, 7-5, 15-3

control file, 11-2

convex hull, 7-13

Coordinate Systems (separately released feature), xix

COVEREDBY, 7-5, 15-3

COVERS, 7-5, 15-4

cr_spatial_index.sql, A-16

CREATE INDEX, 5-9

CREATE_WINDOW_LAYER, 16-8

creating layer tables, A-17

crlayer.sql, A-17

customized geometry types, A-13

---

D

data model, 1-6, A-1

DBA_SDO_GEOM_METADATA view, 2-17

DBA_SDO_INDEX_METADATA view, 2-19

difference, 7-27

dimension (in SDO_GTYPE), 2-7

disjoint, 7-5, 15-4

displaying geometries, A-18, A-20

distance, 7-45

DROP INDEX, 5-13

dynamic query window, 4-3, 12-4

---

E

ELEM_INFO (SDO_ELEM_INFO), 2-8

element, 1-6

EQUAL, 7-5, 15-4

error messages, xx

ESTIMATE_INDEX_PERFORMANCE, 6-4, 14-3

ESTIMATE_TILING_LEVEL, 6-7, 14-5

ESTIMATE_TILING_TIME, 6-9, 14-8

ESTIMATE_TOTAL_NUMTILES, 6-11

ETYPE (SDO_ETYPE), 2-8

example

creating, indexing, and querying spatial data, 2-1

extent, 14-9

EXTENT_OF, 6-14, 14-9

exterior polygon rings, 2-7, 2-9, 2-13, 2-14

---

F

filter, 12-6

fixed indexing, 1-12

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

FROM_815_TO_81x, 8-2

---

G

generic geocoding interface, C-1

GEOCODE_SCHEMA_PROPERTY_TYPE, C-6

GEOCODE_SERVER_PROPERTY_TYPE, C-5

GEOCODE_TABLE_COLUMN_TYPE, C-6

GEOCODE_TASK_METADATA, C-4

GEOCODER_HTTP package, C-10

geocoding

generic interface, C-1

geocoding support

interMedia Locator, A-17, C-2

GeoImage feature, xix

geometric primitive, 1-4

geometry types, 1-4

custom, A-13

object-relational, 2-6

relational, 10-3

GIS, 1-3

GTYPE (SDO_GTYPE), 2-6

---

H

HISTOGRAM_ANALYSIS, 6-16, 14-10

hybrid indexing, 1-16

---

I

index, 13-3, 13-5, 13-12, 13-14

index creation, 3-9, 11-6

cross-schema, 3-14

in parallel, A-14

inserting spatial data, 11-4

INSIDE, 7-6, 15-4

INTEPRETATION (SDO_INTERPRETATION), 2-9

interaction, 7-5, 15-3

interior polygon rings, 2-7, 2-9, 2-13, 2-14

interMedia Locator, A-17, C-2

intersection, 7-29

---

J

Java Virtual Machine, C-2

JVM (Java Virtual Machine), C-2

---

L

layer, 1-7, A-17

validating, 7-43

length (SDO_LENGTH), 7-23

line, 2-11

length, 7-23

line data, 1-7

Linear Referencing System capability, xix

loading process, 3-1, 11-2

in parallel, A-14

location, 1-3

Locator (interMedia), A-17, C-2

long transactions (Version Management), xix

LRS (Linear Referencing System), xix

---

M

MDSYS schema, 1-1

migration

OGIS, 8-8, 8-9

to Oracle 7.3.4, 8-3

to Oracle 8.1.5, 8-5

to Oracle 8.1.6, 8-2

minimum bounding rectangle, 6-2, 6-14, 14-2, 14-9

average, 6-2

MIX_INFO, 6-18, 14-12

multimatch table, C-9

multiple matches, C-9

multi-polygon, 2-14

---

N

nearest neighbor (SDO_NN), 9-4

new features for release 8.1.6, xviii

---

O

object-relational model

schema, 2-1

OGIS_METADATA_FROM, 8-8

OGIS_METADATA_TO, 8-9

operators

cross-schema invocation, 4-9

SDO_FILTER, 9-2

SDO_NN, 9-4

SDO_RELATE, 9-6

SDO_WITHIN_DISTANCE, 9-9

Oracle Technology Network (OTN), xix

oracle.spatial.geocoder.Metadata, C-9

OVERLAPBDYDISJOINT, 7-6, 15-4

OVERLAPBDYINTERSECT, 7-6, 15-4

---

P

parallel load, A-14

partitioned tables, 1-22, A-14

plotting tiles, A-5

point data, 1-7, 13-8, A-9

point on surface of polygon, 7-25

polygon

area of, 7-7

centroid, 7-11

exterior and interior rings, 2-7, 2-9, 2-13, 2-14

point on surface, 7-25

polygon collection, 2-14

polygon data, 1-7

POPULATE_INDEX, 13-3

POPULATE_INDEX_FIXED, 13-5

POPULATE_INDEX_FIXED_POINTS, 13-8

primary filter, 12-6

primitive, 1-4

---

Q

query, 1-8

query window, 4-3, 12-4

---

R

rectangle, 2-11

minimum bounding, 6-14

rejected records, C-9

RELATE, 7-4, 15-2

relational model

schema, 10-1

R-tree indexes, xix

---

S

sample program, A-18, A-20

schema, 10-1

creating index on table in another schema, 3-14

invoking operators on table in another schema, 4-9

object-relational model, 2-1

relational model, 10-1

SDO_AREA, 7-7

SDO_BUFFER, 7-9

SDO_CENTROID, 7-11

SDO_CODE, 2-21

SDO_CODE_SIZE, 13-10

SDO_CONVEXHULL, 7-13

SDO_DIFFERENCE, 7-15

SDO_DISTANCE, 7-18

SDO_ELEM_INFO, 2-8

SDO_ETYPE, 2-8

SDO_FILTER operator, 9-2

SDO_GEOMETRY object type, 2-6

SDO_GROUPCODE, 2-21

SDO_GTYPE, 2-6

SDO_INDEX_TABLE, 2-21

SDO_INTERPRETATION, 2-9

SDO_INTERSECTION, 7-20

SDO_LENGTH, 7-23

SDO_NN operator, 9-4

SDO_ORDINATES, 2-12

SDO_POINT, 2-8

SDO_POINTONSURFACE, 7-25

SDO_POLY_DIFFERENCE, 7-27

SDO_POLY_INTERSECTION, 7-29

SDO_POLY_UNION, 7-31

SDO_POLY_XOR, 7-33

SDO_RELATE operator, 9-6

SDO_ROWID, 2-21

SDO_SRID, 2-8

SDO_STARTING_OFFSET, 2-8

SDO_STATUS, 2-21

SDO_UNION, 7-35

SDO_VERSION, 13-11

SDO_WITHIN_DISTANCE operator, 9-9

SDO_XOR, 7-38

secondary filter, 12-7

simple element, 2-8

spatial data structures

object-relational model, 2-1

relational model, 10-1

spatial database

sizing, A-4

spatial index, 3-9, 11-6, 13-12, 13-14

performance, 6-4, 14-3

spatial indexing

fixed, 1-12

hybrid, 1-16

spatial join, 4-8, 12-8, A-11

spatial query, 4-3, 12-4

SQL script, A-15

SQL*Loader, 3-1, 11-2

SRID (SDO_SRID), 2-8

---

T

table partitioning, 1-22

tessellation, 1-11, 11-6

tile, 1-10, 4-1, 12-1

tiling, 6-7, 13-14, 14-5, A-2

TO_734, 8-3

TO_81x, 8-5

tolerance, 1-7

TOUCH, 7-6, 15-4

transactional insert, 3-3, 11-4

two-tier query, 1-8, 4-1, 12-1

---

U

union, 7-31

UPDATE_INDEX, 13-12

UPDATE_INDEX_FIXED, 13-14

USER_SDO_GEOM_METADATA view, 2-17

USER_SDO_INDEX_METADATA view, 2-19

---

V

VALIDATE_GEOMETRY, 7-41, 15-5

VALIDATE_LAYER, 7-43

VERIFY_LAYER, 13-16

Version Management, xix

visualizing geometries, A-18, A-20

visualizing tiles, A-5, A-20

---

W

WITHIN_DISTANCE, 7-45