1/16

Contents

List of Examples

List of Figures

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

Changes in This Release for Oracle Spatial and Graph Topology Data Model and Network Data Model Graph Developer's Guide

• Changes in Oracle Database 12c Release 1 (12.1)

Part I Topology Data Model

1 Topology Data Model Overview

• 1.1 Main Steps in Using Topology Data
  • 1.1.1 Using a Topology Built from Topology Data
  • 1.1.2 Using a Topology Built from Spatial Geometries
• 1.2 Topology Data Model Concepts
  • 1.2.1 Tolerance in the Topology Data Model
• 1.3 Topology Geometries and Layers
  • 1.3.1 Features
  • 1.3.2 Collection Layers
• 1.4 Topology Geometry Layer Hierarchy
• 1.5 Topology Data Model Tables
  • 1.5.1 Edge Information Table
  • 1.5.2 Node Information Table
  • 1.5.3 Face Information Table
  • 1.5.4 Relationship Information Table
  • 1.5.5 History Information Table
• 1.6 Topology Data Types
  • 1.6.1 SDO_TOPO_GEOMETRY Type
  • 1.6.2 SDO_TOPO_GEOMETRY Constructors
    • 1.6.2.1 Constructors for Insert Operations: Specifying Topological Elements
    • 1.6.2.2 Constructors for Insert Operations: Specifying Lower-Level Features
    • 1.6.2.3 Constructors for Update Operations: Specifying Topological Elements
    • 1.6.2.4 Constructors for Update Operations: Specifying Lower-Level Features
  • 1.6.3 GET_GEOMETRY Member Function
  • 1.6.4 GET_TGL_OBJECTS Member Function
  • 1.6.5 GET_TOPO_ELEMENTS Member Function
  • 1.6.6 SDO_LIST_TYPE Type
  • 1.6.7 SDO_EDGE_ARRAY and SDO_NUMBER_ARRAY Types
• 1.7 Topology Metadata Views
  • 1.7.1 xxx_SDO_TOPO_INFO Views
  • 1.7.2 xxx_SDO_TOPO_METADATA Views
• 1.8 Topology Application Programming Interface
  • 1.8.1 Topology Operators
  • 1.8.2 Topology Data Model Java Interface
• 1.9 Exporting and Importing Topology Data
• 1.10 Cross-Schema Topology Usage and Editing
  • 1.10.1 Cross-Schema Topology Usage
  • 1.10.2 Cross-Schema Topology Editing
• 1.11 Function-Based Indexes Not Supported
• 1.12 Topology Examples (PL/SQL)
  • 1.12.1 Topology Built from Topology Data
  • 1.12.2 Topology Built from Spatial Geometries
• 1.13 README File for Spatial and Graph and Related Features

2 Editing Topologies

• 2.1 Approaches for Editing Topology Data
  • 2.1.1 TopoMap Objects
  • 2.1.2 Specifying the Editing Approach with the Topology Parameter
  • 2.1.3 Using GET_xxx Topology Functions
  • 2.1.4 Process for Editing Using Cache Explicitly (PL/SQL API)
  • 2.1.5 Process for Editing Using the Java API
  • 2.1.6 Error Handling for Topology Editing
    • 2.1.6.1 Input Parameter Errors
    • 2.1.6.2 All Exceptions
• 2.2 Performing Operations on Nodes
  • 2.2.1 Adding a Node
  • 2.2.2 Moving a Node
    • 2.2.2.1 Additional Examples of Allowed and Disallowed Node Moves
  • 2.2.3 Removing a Node
  • 2.2.4 Removing Obsolete Nodes
• 2.3 Performing Operations on Edges
  • 2.3.1 Adding an Edge
  • 2.3.2 Moving an Edge
  • 2.3.3 Removing an Edge
  • 2.3.4 Updating an Edge

3 SDO_TOPO Package Subprograms

• SDO_TOPO.ADD_TOPO_GEOMETRY_LAYER
• SDO_TOPO.CREATE_TOPOLOGY
• SDO_TOPO.DELETE_TOPO_GEOMETRY_LAYER
• SDO_TOPO.DROP_TOPOLOGY
• SDO_TOPO.GET_FACE_BOUNDARY
• SDO_TOPO.GET_TOPO_OBJECTS
• SDO_TOPO.INITIALIZE_AFTER_IMPORT
• SDO_TOPO.INITIALIZE_METADATA
• SDO_TOPO.PREPARE_FOR_EXPORT
• SDO_TOPO.RELATE

4 SDO_TOPO_MAP Package Subprograms

• SDO_TOPO_MAP.ADD_EDGE
• SDO_TOPO_MAP.ADD_ISOLATED_NODE
• SDO_TOPO_MAP.ADD_LINEAR_GEOMETRY
• SDO_TOPO_MAP.ADD_LOOP
• SDO_TOPO_MAP.ADD_NODE
• SDO_TOPO_MAP.ADD_POINT_GEOMETRY
• SDO_TOPO_MAP.ADD_POLYGON_GEOMETRY
• SDO_TOPO_MAP.CHANGE_EDGE_COORDS
• SDO_TOPO_MAP.CLEAR_TOPO_MAP
• SDO_TOPO_MAP.COMMIT_TOPO_MAP
• SDO_TOPO_MAP.CREATE_EDGE_INDEX
• SDO_TOPO_MAP.CREATE_FACE_INDEX
• SDO_TOPO_MAP.CREATE_FEATURE
• SDO_TOPO_MAP.CREATE_TOPO_MAP
• SDO_TOPO_MAP.DROP_TOPO_MAP
• SDO_TOPO_MAP.GET_CONTAINING_FACE
• SDO_TOPO_MAP.GET_EDGE_ADDITIONS
• SDO_TOPO_MAP.GET_EDGE_CHANGES
• SDO_TOPO_MAP.GET_EDGE_COORDS
• SDO_TOPO_MAP.GET_EDGE_DELETIONS
• SDO_TOPO_MAP.GET_EDGE_NODES
• SDO_TOPO_MAP.GET_FACE_ADDITIONS
• SDO_TOPO_MAP.GET_FACE_CHANGES
• SDO_TOPO_MAP.GET_FACE_BOUNDARY
• SDO_TOPO_MAP.GET_FACE_DELETIONS
• SDO_TOPO_MAP.GET_NEAREST_EDGE
• SDO_TOPO_MAP.GET_NEAREST_EDGE_IN_CACHE
• SDO_TOPO_MAP.GET_NEAREST_NODE
• SDO_TOPO_MAP.GET_NEAREST_NODE_IN_CACHE
• SDO_TOPO_MAP.GET_NODE_ADDITIONS
• SDO_TOPO_MAP.GET_NODE_CHANGES
• SDO_TOPO_MAP.GET_NODE_COORD
• SDO_TOPO_MAP.GET_NODE_DELETIONS
• SDO_TOPO_MAP.GET_NODE_FACE_STAR
• SDO_TOPO_MAP.GET_NODE_STAR
• SDO_TOPO_MAP.GET_TOPO_NAME
• SDO_TOPO_MAP.GET_TOPO_TRANSACTION_ID
• SDO_TOPO_MAP.LIST_TOPO_MAPS
• SDO_TOPO_MAP.LOAD_TOPO_MAP
• SDO_TOPO_MAP.MOVE_EDGE
• SDO_TOPO_MAP.MOVE_ISOLATED_NODE
• SDO_TOPO_MAP.MOVE_NODE
• SDO_TOPO_MAP.REMOVE_EDGE
• SDO_TOPO_MAP.REMOVE_NODE
• SDO_TOPO_MAP.REMOVE_OBSOLETE_NODES
• SDO_TOPO_MAP.ROLLBACK_TOPO_MAP
• SDO_TOPO_MAP.SEARCH_EDGE_RTREE_TOPO_MAP
• SDO_TOPO_MAP.SEARCH_FACE_RTREE_TOPO_MAP
• SDO_TOPO_MAP.SET_MAX_MEMORY_SIZE
• SDO_TOPO_MAP.UPDATE_TOPO_MAP
• SDO_TOPO_MAP.VALIDATE_TOPO_MAP
• SDO_TOPO_MAP.VALIDATE_TOPOLOGY

Part II Network Data Model

5 Network Data Model Graph Overview

• 5.1 Introduction to Network Modeling
• 5.2 Main Steps in Using the Network Data Model Graph
  • 5.2.1 Letting Spatial Perform Most Operations
  • 5.2.2 Performing the Operations Yourself
• 5.3 Network Data Model Graph Concepts
  • 5.3.1 Subpaths
  • 5.3.2 Features and Feature Layers
• 5.4 Network Applications
  • 5.4.1 Road Network Example
  • 5.4.2 Subway (Train) Network Example
  • 5.4.3 Multimodal Network and Temporal Examples
  • 5.4.4 Utility Network Example
  • 5.4.5 Biochemical Network Example
• 5.5 Network Hierarchy
• 5.6 Network User Data
  • 5.6.1 User-Defined Data Example (PL/SQL and Java)
  • 5.6.2 User-Defined Data Example (Custom User Data I/O Implementation)
    • 5.6.2.1 Implementation of writeUserData method of LODUserDataIO
    • 5.6.2.2 Implementation of readUserData method of LODUserDataIO
• 5.7 Feature Modeling
  • 5.7.1 Data Types Used for Feature Modeling
• 5.8 Network Constraints
• 5.9 Network Analysis Using Load on Demand
  • 5.9.1 Partitioning a Network
  • 5.9.2 Generating Partition BLOBs
  • 5.9.3 Configuring the Partition Cache
  • 5.9.4 Analyzing the Network
  • 5.9.5 Using Link Levels for Priority Modeling
  • 5.9.6 Precomputed Analysis Results
• 5.10 Network Data Model Graph Tables
  • 5.10.1 Network Layer Tables
    • 5.10.1.1 Node Table
    • 5.10.1.2 Link Table
    • 5.10.1.3 Path Table
    • 5.10.1.4 Path-Link Table
    • 5.10.1.5 Subpath Table
    • 5.10.1.6 Partition Table
    • 5.10.1.7 Partition BLOB Table
    • 5.10.1.8 Connected Component Table
    • 5.10.1.9 Node Hierarchy Table (Optional)
    • 5.10.1.10 Node Level Table (Optional)
  • 5.10.2 Feature Layer Tables
    • 5.10.2.1 Feature Table
    • 5.10.2.2 Feature Element Relationships Table
    • 5.10.2.3 Feature Hierarchy Table
• 5.11 Network Data Model Graph Metadata Views
  • 5.11.1 xxx_SDO_NETWORK_METADATA Views
  • 5.11.2 xxx_SDO_NETWORK_CONSTRAINTS Views
  • 5.11.3 xxx_SDO_NETWORK_USER_DATA Views
  • 5.11.4 xxx_SDO_NETWORK_FEATURE Views
• 5.12 Network Data Model Graph Application Programming Interface
  • 5.12.1 Network Data Model Graph PL/SQL Interface
  • 5.12.2 Network Data Model Graph Java Interface
    • 5.12.2.1 Network Metadata and Data Management
    • 5.12.2.2 Network Analysis Using the Load on Demand Approach
  • 5.12.3 Network Data Model Graph XML Interface
    • 5.12.3.1 User-Specified Implementations
• 5.13 Cross-Schema Network Access
  • 5.13.1 Cross-Schema Access by Specifying Owner in Network Metadata
  • 5.13.2 Cross-Schema Access by Using Views
• 5.14 Network Examples
  • 5.14.1 Simple Spatial (SDO) Network Example (PL/SQL)
  • 5.14.2 Simple Logical Network Example (PL/SQL)
  • 5.14.3 Spatial (LRS) Network Example (PL/SQL)
  • 5.14.4 Logical Hierarchical Network Example (PL/SQL)
  • 5.14.5 Partitioning and Load on Demand Analysis Examples (PL/SQL, XML, and Java)
  • 5.14.6 User-Defined Data Examples (PL/SQL and Java)
• 5.15 Network Data Model Graph Tutorial and Other Resources
• 5.16 README File for Spatial and Graph and Related Features

6 SDO_NET Package Subprograms

• SDO_NET.ADD_CHILD_FEATURE
• SDO_NET.ADD_CHILD_FEATURES
• SDO_NET.ADD_FEATURE
• SDO_NET.ADD_FEATURE_ELEMENT
• SDO_NET.ADD_FEATURE_ELEMENTS
• SDO_NET.ADD_FEATURE_LAYER
• SDO_NET.COMPUTE_PATH_GEOMETRY
• SDO_NET.COPY_NETWORK
• SDO_NET.CREATE_LINK_TABLE
• SDO_NET.CREATE_LOGICAL_NETWORK
• SDO_NET.CREATE_LRS_NETWORK
• SDO_NET.CREATE_LRS_TABLE
• SDO_NET.CREATE_NODE_TABLE
• SDO_NET.CREATE_PARTITION_TABLE
• SDO_NET.CREATE_PATH_LINK_TABLE
• SDO_NET.CREATE_PATH_TABLE
• SDO_NET.CREATE_SDO_NETWORK
• SDO_NET.CREATE_SUBPATH_TABLE
• SDO_NET.CREATE_TOPO_NETWORK
• SDO_NET.DELETE_CHILD_FEATURES
• SDO_NET.DELETE_CHILD_FEATURES_AT
• SDO_NET.DELETE_DANGLING_FEATURES
• SDO_NET.DELETE_DANGLING_LINKS
• SDO_NET.DELETE_DANGLING_NODES
• SDO_NET.DELETE_FEATURE_ELEMENTS
• SDO_NET.DELETE_FEATURE_ELEMENTS_AT
• SDO_NET.DELETE_FEATURES
• SDO_NET.DELETE_LINK
• SDO_NET.DELETE_NODE
• SDO_NET.DELETE_PATH
• SDO_NET.DELETE_PHANTOM_FEATURES
• SDO_NET.DELETE_SUBPATH
• SDO_NET.DEREGISTER_CONSTRAINT
• SDO_NET.DROP_FEATURE_LAYER
• SDO_NET.DROP_NETWORK
• SDO_NET.FIND_CONNECTED_COMPONENTS
• SDO_NET.GENERATE_NODE_LEVELS
• SDO_NET.GENERATE_PARTITION_BLOB
• SDO_NET.GENERATE_PARTITION_BLOBS
• SDO_NET.GET_CHILD_FEATURE_IDS
• SDO_NET.GET_CHILD_LINKS
• SDO_NET.GET_CHILD_NODES
• SDO_NET.GET_DANGLING_FEATURES
• SDO_NET.GET_DANGLING_LINKS
• SDO_NET.GET_DANGLING_NODES
• SDO_NET.GET_FEATURE_ELEMENTS
• SDO_NET.GET_FEATURE_LAYER_ID
• SDO_NET.GET_FEATURES_ON_LINKS
• SDO_NET.GET_FEATURES_ON_NODES
• SDO_NET.GET_GEOMETRY_TYPE
• SDO_NET.GET_IN_LINKS
• SDO_NET.GET_INVALID_LINKS
• SDO_NET.GET_INVALID_NODES
• SDO_NET.GET_INVALID_PATHS
• SDO_NET.GET_ISOLATED_NODES
• SDO_NET.GET_LINK_COST_COLUMN
• SDO_NET.GET_LINK_DIRECTION
• SDO_NET.GET_LINK_GEOM_COLUMN
• SDO_NET.GET_LINK_GEOMETRY
• SDO_NET.GET_LINK_TABLE_NAME
• SDO_NET.GET_LINKS_IN_PATH
• SDO_NET.GET_LRS_GEOM_COLUMN
• SDO_NET.GET_LRS_LINK_GEOMETRY
• SDO_NET.GET_LRS_NODE_GEOMETRY
• SDO_NET.GET_LRS_TABLE_NAME
• SDO_NET.GET_NETWORK_TYPE
• SDO_NET.GET_NO_OF_HIERARCHY_LEVELS
• SDO_NET.GET_NO_OF_LINKS
• SDO_NET.GET_NO_OF_NODES
• SDO_NET.GET_NODE_DEGREE
• SDO_NET.GET_NODE_GEOM_COLUMN
• SDO_NET.GET_NODE_GEOMETRY
• SDO_NET.GET_NODE_IN_DEGREE
• SDO_NET.GET_NODE_OUT_DEGREE
• SDO_NET.GET_NODE_TABLE_NAME
• SDO_NET.GET_OUT_LINKS
• SDO_NET.GET_PARENT_FEATURE_IDS
• SDO_NET.GET_PARTITION_SIZE
• SDO_NET.GET_PATH_GEOM_COLUMN
• SDO_NET.GET_PATH_TABLE_NAME
• SDO_NET.GET_PERCENTAGE
• SDO_NET.GET_PHANTOM_FEATURES
• SDO_NET.GET_PT
• SDO_NET.IS_HIERARCHICAL
• SDO_NET.IS_LINK_IN_PATH
• SDO_NET.IS_LOGICAL
• SDO_NET.IS_NODE_IN_PATH
• SDO_NET.IS_SPATIAL
• SDO_NET.LOAD_CONFIG
• SDO_NET.LOGICAL_PARTITION
• SDO_NET.LOGICAL_POWERLAW_PARTITION
• SDO_NET.LRS_GEOMETRY_NETWORK
• SDO_NET.NETWORK_EXISTS
• SDO_NET.POST_XML
• SDO_NET.REGISTER_CONSTRAINT
• SDO_NET.SDO_GEOMETRY_NETWORK
• SDO_NET.SET_LOGGING_LEVEL
• SDO_NET.SET_MAX_JAVA_HEAP_SIZE
• SDO_NET.SPATIAL_PARTITION
• SDO_NET.TOPO_GEOMETRY_NETWORK
• SDO_NET.UPDATE_FEATURE
• SDO_NET.UPDATE_FEATURE_ELEMENT
• SDO_NET.VALIDATE_LINK_SCHEMA
• SDO_NET.VALIDATE_LRS_SCHEMA
• SDO_NET.VALIDATE_NETWORK
• SDO_NET.VALIDATE_NODE_SCHEMA
• SDO_NET.VALIDATE_PARTITION_SCHEMA
• SDO_NET.VALIDATE_PATH_SCHEMA
• SDO_NET.VALIDATE_SUBPATH_SCHEMA

Index