(原) Oracle Spatial: Spatial Concepts

Oracle Spatial: Spatial Concepts
1 Oracle Spatial 是什嗎？
    提供SQL schema 和 functions 以方便儲存、取回、更新和查詢空間特性的集合。
    MDSYS提供了地理資料的類型
2 Object-Relational Model
    SDO_GEOMETRY
    支援arcs, circles, compound polygons, compound line strings, and optimized rectangles
3 Spatial Data
    例如交通圖
4 Geometry Types
    Points、point clusters
    Line strings
    n-point polygons
    Arc line strings
    Arc polygons
    Compound polygons
    Compound line strings
    Circles
    Optimized rectangles
5 Data Model
    elements, geometries, layers 所組成的等級結構。
    element: points, line strings, polygons
    Geometry:  An example of a geometry might describe the buildable land in a town.
    Layer: A layer is a collection of geometries having the same attribute set.
    Coordinate System: Cartesian coordinates, Geodetic coordinates, Projected coordinates, Local coordinates
    Tolerance: Tolerance is used to associate a level of precision with spatial data.
6 Query Model
    兩級過濾。Primary filter, secondary filter.
7 Indexing of Spatial Data
    R-tree index
8 Spatial Relationships and Filtering
    SDO_RELATE: 評價拓撲標準 nine-intersection model between points, lines, and polygons (interior, a boundary, and an exterior.)
    SDO_WITHIN_DISTANCE: 兩個空間對象是否在一個距離範圍內。
    SDO_NN: 離某個空間對象最近的一個對象
9 Spatial Operators, Procedures, Functions
    Spatial operators: such as SDO_FILTER and SDO_RELATE
    Spatial procedures and functions: SDO_GEOM, SDO_CS, and SDO_LRS.
10 Spatial Aggregate Functions
    SDO_AGGR_MBR
    SDO_AGGR_UNION
11 Geocoding
    一個從地址表中轉換到標準地址、位置等的過程。
12 Spatial Java Application Programming Interface
    oracle.spatial.geometry
    oracle.spatial.network
    oracle.spatial.topo
    oracle.spatial.util
13 MDDATA Schema

14 Performance and Tuning Information
    http://www.oracle.com/technology/products/spatial/
15 Open Geospatial Consortium (OGC) Conformance
    Features Specification 1.1.1
    SQL92
16 Spatial Release (Version) Number
    SELECT SDO_VERSION FROM DUAL;
17 Spatial Application Hardware Requirement Considerations

18 Spatial Error Messages
    Oracle Database Error Messages
19 Spatial Examples
    readgeom.c and readgeom.h
    writegeom.c and writegeom.h