1/16

Contents

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)
  • New Features
    • Feature Modeling in the Network Data Model
    • Multimodal Network and Temporal Modeling Support
    • New part_size_tolerance Parameter for SDO_NET.LOGICAL_POWERLAW_PARTITION
  • Java in-Memory API and SDO_NET_MEM Package Desupported
  • Other Changes
• Changes in Oracle Database 12c Release 2 (12.2)
  • Network Feature Editing (NFE)

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

• 3.1 SDO_TOPO.ADD_TOPO_GEOMETRY_LAYER
• 3.2 SDO_TOPO.CREATE_TOPOLOGY
• 3.3 SDO_TOPO.DELETE_TOPO_GEOMETRY_LAYER
• 3.4 SDO_TOPO.DROP_TOPOLOGY
• 3.5 SDO_TOPO.GET_FACE_BOUNDARY
• 3.6 SDO_TOPO.GET_TOPO_OBJECTS
• 3.7 SDO_TOPO.INITIALIZE_AFTER_IMPORT
• 3.8 SDO_TOPO.INITIALIZE_METADATA
• 3.9 SDO_TOPO.PREPARE_FOR_EXPORT
• 3.10 SDO_TOPO.RELATE

4 SDO_TOPO_MAP Package Subprograms

• 4.1 SDO_TOPO_MAP.ADD_EDGE
• 4.2 SDO_TOPO_MAP.ADD_ISOLATED_NODE
• 4.3 SDO_TOPO_MAP.ADD_LINEAR_GEOMETRY
• 4.4 SDO_TOPO_MAP.ADD_LOOP
• 4.5 SDO_TOPO_MAP.ADD_NODE
• 4.6 SDO_TOPO_MAP.ADD_POINT_GEOMETRY
• 4.7 SDO_TOPO_MAP.ADD_POLYGON_GEOMETRY
• 4.8 SDO_TOPO_MAP.CHANGE_EDGE_COORDS
• 4.9 SDO_TOPO_MAP.CLEAR_TOPO_MAP
• 4.10 SDO_TOPO_MAP.COMMIT_TOPO_MAP
• 4.11 SDO_TOPO_MAP.CREATE_EDGE_INDEX
• 4.12 SDO_TOPO_MAP.CREATE_FACE_INDEX
• 4.13 SDO_TOPO_MAP.CREATE_FEATURE
• 4.14 SDO_TOPO_MAP.CREATE_TOPO_MAP
• 4.15 SDO_TOPO_MAP.DROP_TOPO_MAP
• 4.16 SDO_TOPO_MAP.GET_CONTAINING_FACE
• 4.17 SDO_TOPO_MAP.GET_EDGE_ADDITIONS
• 4.18 SDO_TOPO_MAP.GET_EDGE_CHANGES
• 4.19 SDO_TOPO_MAP.GET_EDGE_COORDS
• 4.20 SDO_TOPO_MAP.GET_EDGE_DELETIONS
• 4.21 SDO_TOPO_MAP.GET_EDGE_NODES
• 4.22 SDO_TOPO_MAP.GET_FACE_ADDITIONS
• 4.23 SDO_TOPO_MAP.GET_FACE_CHANGES
• 4.24 SDO_TOPO_MAP.GET_FACE_BOUNDARY
• 4.25 SDO_TOPO_MAP.GET_FACE_DELETIONS
• 4.26 SDO_TOPO_MAP.GET_NEAREST_EDGE
• 4.27 SDO_TOPO_MAP.GET_NEAREST_EDGE_IN_CACHE
• 4.28 SDO_TOPO_MAP.GET_NEAREST_NODE
• 4.29 SDO_TOPO_MAP.GET_NEAREST_NODE_IN_CACHE
• 4.30 SDO_TOPO_MAP.GET_NODE_ADDITIONS
• 4.31 SDO_TOPO_MAP.GET_NODE_CHANGES
• 4.32 SDO_TOPO_MAP.GET_NODE_COORD
• 4.33 SDO_TOPO_MAP.GET_NODE_DELETIONS
• 4.34 SDO_TOPO_MAP.GET_NODE_FACE_STAR
• 4.35 SDO_TOPO_MAP.GET_NODE_STAR
• 4.36 SDO_TOPO_MAP.GET_TOPO_NAME
• 4.37 SDO_TOPO_MAP.GET_TOPO_TRANSACTION_ID
• 4.38 SDO_TOPO_MAP.LIST_TOPO_MAPS
• 4.39 SDO_TOPO_MAP.LOAD_TOPO_MAP
• 4.40 SDO_TOPO_MAP.MOVE_EDGE
• 4.41 SDO_TOPO_MAP.MOVE_ISOLATED_NODE
• 4.42 SDO_TOPO_MAP.MOVE_NODE
• 4.43 SDO_TOPO_MAP.REMOVE_EDGE
• 4.44 SDO_TOPO_MAP.REMOVE_NODE
• 4.45 SDO_TOPO_MAP.REMOVE_OBSOLETE_NODES
• 4.46 SDO_TOPO_MAP.ROLLBACK_TOPO_MAP
• 4.47 SDO_TOPO_MAP.SEARCH_EDGE_RTREE_TOPO_MAP
• 4.48 SDO_TOPO_MAP.SEARCH_FACE_RTREE_TOPO_MAP
• 4.49 SDO_TOPO_MAP.SET_MAX_MEMORY_SIZE
• 4.50 SDO_TOPO_MAP.UPDATE_TOPO_MAP
• 4.51 SDO_TOPO_MAP.VALIDATE_TOPO_MAP
• 4.52 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 Feature Modeling Using Network Feature Editing (NFE)
  • 5.8.1 Creation Modes for NFE Models
  • 5.8.2 NFE Feature Classes
  • 5.8.3 NFE Rules
  • 5.8.4 Data Types Used for NFE Connectivity Rules
• 5.9 Network Constraints
• 5.10 Network Analysis Using Load on Demand
  • 5.10.1 Partitioning a Network
  • 5.10.2 Generating Partition BLOBs
  • 5.10.3 Configuring the Partition Cache
  • 5.10.4 Analyzing the Network
  • 5.10.5 Using Link Levels for Priority Modeling
  • 5.10.6 Precomputed Analysis Results
• 5.11 Network Data Model Graph Tables
  • 5.11.1 Network Layer Tables
    • 5.11.1.1 Node Table
    • 5.11.1.2 Link Table
    • 5.11.1.3 Path Table
    • 5.11.1.4 Path-Link Table
    • 5.11.1.5 Subpath Table
    • 5.11.1.6 Partition Table
    • 5.11.1.7 Partition BLOB Table
    • 5.11.1.8 Connected Component Table
    • 5.11.1.9 Node Hierarchy Table (Optional)
    • 5.11.1.10 Node Level Table (Optional)
  • 5.11.2 Feature Layer Tables
    • 5.11.2.1 Feature Table
    • 5.11.2.2 Feature Element Relationships Table
    • 5.11.2.3 Feature Hierarchy Table
  • 5.11.3 Network Feature Editing (NFE) Model Tables
    • 5.11.3.1 Automatically Created Points Default Attributes Table
    • 5.11.3.2 Connectivity Line-Line Rules Table
    • 5.11.3.3 Connectivity Line-Point Rules Table
    • 5.11.3.4 Feature Class Table
    • 5.11.3.5 Feature Class Attributes Constraints Table
    • 5.11.3.6 Feature Class Default Predefined Connected Points Table
    • 5.11.3.7 Feature Class Relationship Table
    • 5.11.3.8 Feature Rule Relationship Table
    • 5.11.3.9 Feature User Data Table
    • 5.11.3.10 Feature User Data Catalog Table
    • 5.11.3.11 Feature User Data Catalog Values Table
    • 5.11.3.12 Point Cardinality Rules Table
    • 5.11.3.13 Rule Decision Handlers Table
    • 5.11.3.14 Rule Instance Table
• 5.12 Network Data Model Graph and Network Feature Editing (NFE) Model Metadata Views
  • 5.12.1 xxx_SDO_NETWORK_METADATA Views
  • 5.12.2 xxx_SDO_NETWORK_CONSTRAINTS Views
  • 5.12.3 xxx_SDO_NETWORK_USER_DATA Views
  • 5.12.4 xxx_SDO_NETWORK_FEATURE Views
  • 5.12.5 xxx_SDO_NFE_MODEL_FTLAYER_REL Views
  • 5.12.6 xxx_SDO_NFE_MODEL_METADATA Views
  • 5.12.7 xxx_SDO_NFE_MODEL_WORKSPACE Views
• 5.13 Network Data Model Graph Application Programming Interface
  • 5.13.1 Network Data Model Graph PL/SQL Interface
  • 5.13.2 Network Data Model Graph Java Interface
    • 5.13.2.1 Network Metadata and Data Management
    • 5.13.2.2 Network Analysis Using the Load on Demand Approach
  • 5.13.3 Network Data Model Graph XML Interface
    • 5.13.3.1 User-Specified Implementations
• 5.14 Cross-Schema Network Access
  • 5.14.1 Cross-Schema Access by Specifying Owner in Network Metadata
  • 5.14.2 Cross-Schema Access by Using Views
• 5.15 Network Examples
  • 5.15.1 Simple Spatial (SDO) Network Example (PL/SQL)
  • 5.15.2 Simple Logical Network Example (PL/SQL)
  • 5.15.3 Spatial (LRS) Network Example (PL/SQL)
  • 5.15.4 Logical Hierarchical Network Example (PL/SQL)
  • 5.15.5 Partitioning and Load on Demand Analysis Examples (PL/SQL, XML, and Java)
  • 5.15.6 User-Defined Data Examples (PL/SQL and Java)
• 5.16 Network Data Model Graph Tutorial and Other Resources
• 5.17 README File for Spatial and Graph and Related Features

6 SDO_NET Package Subprograms

• 6.1 SDO_NET.ADD_CHILD_FEATURE
• 6.2 SDO_NET.ADD_CHILD_FEATURES
• 6.3 SDO_NET.ADD_FEATURE
• 6.4 SDO_NET.ADD_FEATURE_ELEMENT
• 6.5 SDO_NET.ADD_FEATURE_ELEMENTS
• 6.6 SDO_NET.ADD_FEATURE_LAYER
• 6.7 SDO_NET.COMPUTE_PATH_GEOMETRY
• 6.8 SDO_NET.COPY_NETWORK
• 6.9 SDO_NET.CREATE_LINK_TABLE
• 6.10 SDO_NET.CREATE_LOGICAL_NETWORK
• 6.11 SDO_NET.CREATE_LRS_NETWORK
• 6.12 SDO_NET.CREATE_LRS_TABLE
• 6.13 SDO_NET.CREATE_NODE_TABLE
• 6.14 SDO_NET.CREATE_PARTITION_TABLE
• 6.15 SDO_NET.CREATE_PATH_LINK_TABLE
• 6.16 SDO_NET.CREATE_PATH_TABLE
• 6.17 SDO_NET.CREATE_SDO_NETWORK
• 6.18 SDO_NET.CREATE_SUBPATH_TABLE
• 6.19 SDO_NET.CREATE_TOPO_NETWORK
• 6.20 SDO_NET.DELETE_CHILD_FEATURES
• 6.21 SDO_NET.DELETE_CHILD_FEATURES_AT
• 6.22 SDO_NET.DELETE_DANGLING_FEATURES
• 6.23 SDO_NET.DELETE_DANGLING_LINKS
• 6.24 SDO_NET.DELETE_DANGLING_NODES
• 6.25 SDO_NET.DELETE_FEATURE_ELEMENTS
• 6.26 SDO_NET.DELETE_FEATURE_ELEMENTS_AT
• 6.27 SDO_NET.DELETE_FEATURES
• 6.28 SDO_NET.DELETE_LINK
• 6.29 SDO_NET.DELETE_NODE
• 6.30 SDO_NET.DELETE_PATH
• 6.31 SDO_NET.DELETE_PHANTOM_FEATURES
• 6.32 SDO_NET.DELETE_SUBPATH
• 6.33 SDO_NET.DEREGISTER_CONSTRAINT
• 6.34 SDO_NET.DROP_FEATURE_LAYER
• 6.35 SDO_NET.DROP_NETWORK
• 6.36 SDO_NET.FIND_CONNECTED_COMPONENTS
• 6.37 SDO_NET.GENERATE_NODE_LEVELS
• 6.38 SDO_NET.GENERATE_PARTITION_BLOB
• 6.39 SDO_NET.GENERATE_PARTITION_BLOBS
• 6.40 SDO_NET.GET_CHILD_FEATURE_IDS
• 6.41 SDO_NET.GET_CHILD_LINKS
• 6.42 SDO_NET.GET_CHILD_NODES
• 6.43 SDO_NET.GET_DANGLING_FEATURES
• 6.44 SDO_NET.GET_DANGLING_LINKS
• 6.45 SDO_NET.GET_DANGLING_NODES
• 6.46 SDO_NET.GET_FEATURE_ELEMENTS
• 6.47 SDO_NET.GET_FEATURE_LAYER_ID
• 6.48 SDO_NET.GET_FEATURES_ON_LINKS
• 6.49 SDO_NET.GET_FEATURES_ON_NODES
• 6.50 SDO_NET.GET_GEOMETRY_TYPE
• 6.51 SDO_NET.GET_IN_LINKS
• 6.52 SDO_NET.GET_INVALID_LINKS
• 6.53 SDO_NET.GET_INVALID_NODES
• 6.54 SDO_NET.GET_INVALID_PATHS
• 6.55 SDO_NET.GET_ISOLATED_NODES
• 6.56 SDO_NET.GET_LINK_COST_COLUMN
• 6.57 SDO_NET.GET_LINK_DIRECTION
• 6.58 SDO_NET.GET_LINK_GEOM_COLUMN
• 6.59 SDO_NET.GET_LINK_GEOMETRY
• 6.60 SDO_NET.GET_LINK_TABLE_NAME
• 6.61 SDO_NET.GET_LINKS_IN_PATH
• 6.62 SDO_NET.GET_LRS_GEOM_COLUMN
• 6.63 SDO_NET.GET_LRS_LINK_GEOMETRY
• 6.64 SDO_NET.GET_LRS_NODE_GEOMETRY
• 6.65 SDO_NET.GET_LRS_TABLE_NAME
• 6.66 SDO_NET.GET_NETWORK_TYPE
• 6.67 SDO_NET.GET_NO_OF_HIERARCHY_LEVELS
• 6.68 SDO_NET.GET_NO_OF_LINKS
• 6.69 SDO_NET.GET_NO_OF_NODES
• 6.70 SDO_NET.GET_NODE_DEGREE
• 6.71 SDO_NET.GET_NODE_GEOM_COLUMN
• 6.72 SDO_NET.GET_NODE_GEOMETRY
• 6.73 SDO_NET.GET_NODE_IN_DEGREE
• 6.74 SDO_NET.GET_NODE_OUT_DEGREE
• 6.75 SDO_NET.GET_NODE_TABLE_NAME
• 6.76 SDO_NET.GET_OUT_LINKS
• 6.77 SDO_NET.GET_PARENT_FEATURE_IDS
• 6.78 SDO_NET.GET_PARTITION_SIZE
• 6.79 SDO_NET.GET_PATH_GEOM_COLUMN
• 6.80 SDO_NET.GET_PATH_TABLE_NAME
• 6.81 SDO_NET.GET_PERCENTAGE
• 6.82 SDO_NET.GET_PHANTOM_FEATURES
• 6.83 SDO_NET.GET_PT
• 6.84 SDO_NET.IS_HIERARCHICAL
• 6.85 SDO_NET.IS_LINK_IN_PATH
• 6.86 SDO_NET.IS_LOGICAL
• 6.87 SDO_NET.IS_NODE_IN_PATH
• 6.88 SDO_NET.IS_SPATIAL
• 6.89 SDO_NET.LOAD_CONFIG
• 6.90 SDO_NET.LOGICAL_PARTITION
• 6.91 SDO_NET.LOGICAL_POWERLAW_PARTITION
• 6.92 SDO_NET.LRS_GEOMETRY_NETWORK
• 6.93 SDO_NET.NETWORK_EXISTS
• 6.94 SDO_NET.POST_XML
• 6.95 SDO_NET.REGISTER_CONSTRAINT
• 6.96 SDO_NET.SDO_GEOMETRY_NETWORK
• 6.97 SDO_NET.SET_LOGGING_LEVEL
• 6.98 SDO_NET.SET_MAX_JAVA_HEAP_SIZE
• 6.99 SDO_NET.SPATIAL_PARTITION
• 6.100 SDO_NET.TOPO_GEOMETRY_NETWORK
• 6.101 SDO_NET.UPDATE_FEATURE
• 6.102 SDO_NET.UPDATE_FEATURE_ELEMENT
• 6.103 SDO_NET.VALIDATE_LINK_SCHEMA
• 6.104 SDO_NET.VALIDATE_LRS_SCHEMA
• 6.105 SDO_NET.VALIDATE_NETWORK
• 6.106 SDO_NET.VALIDATE_NODE_SCHEMA
• 6.107 SDO_NET.VALIDATE_PARTITION_SCHEMA
• 6.108 SDO_NET.VALIDATE_PATH_SCHEMA
• 6.109 SDO_NET.VALIDATE_SUBPATH_SCHEMA

7 SDO_NFE Package Subprograms

• 7.1 SDO_NFE.APPLY_RULE
• 7.2 SDO_NFE.CLASSIFY_LINES_BY_SIDE
• 7.3 SDO_NFE.CREATE_MODEL_SEQUENCE
• 7.4 SDO_NFE.CREATE_MODEL_STRUCTURE
• 7.5 SDO_NFE.CREATE_MODEL_UNDERLYING_NET
• 7.6 SDO_NFE.CREATE_MODEL_WORKSPACE
• 7.7 SDO_NFE.DELETE_ALL_FT_LAYERS
• 7.8 SDO_NFE.DELETE_ALL_WORKSPACES
• 7.9 SDO_NFE.DELETE_MODEL_STRUCTURE
• 7.10 SDO_NFE.DELETE_MODEL_WORKSPACE
• 7.11 SDO_NFE.DROP_MODEL_SEQUENCE
• 7.12 SDO_NFE.DROP_MODEL_UNDERLYING_NETWORK
• 7.13 SDO_NFE.GET_CONNECTION_POINT_GEOM
• 7.14 SDO_NFE.GET_INTERACTION_GROUPS
• 7.15 SDO_NFE.GET_LINES_MATCH_LP_RULE
• 7.16 SDO_NFE.GET_LL_CONN_INTERSECTIONS
• 7.17 SDO_NFE.GET_LP_CONN_INTERSECTIONS
• 7.18 SDO_NFE.GET_MODEL_SEQUENCE_NAME
• 7.19 SDO_NFE.GET_MODEL_TABLE_NAME
• 7.20 SDO_NFE.GET_MODEL_UNDERLYING_NETWORK
• 7.21 SDO_NFE.GET_NEXT_SEQUENCE_VALUE
• 7.22 SDO_NFE.GET_POINTS_MATCH_LP_RULE
• 7.23 SDO_NFE.IMPORT_NETWORK
• 7.24 SDO_NFE.SET_MODEL_UNDERLYING_NETWORK

Index