1/15

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

Part I Topology Data Model

1 Topology Data Model Overview

• Main Steps in Using Topology Data
  • Using a Topology Built from Topology Data
  • Using a Topology Built from Spatial Geometries
• Topology Data Model Concepts
  • Tolerance in the Topology Data Model
• Topology Geometries and Layers
  • Features
  • Collection Layers
• Topology Geometry Layer Hierarchy
• Topology Data Model Tables
  • Edge Information Table
  • Node Information Table
  • Face Information Table
  • Relationship Information Table
  • History Information Table
• Topology Data Types
  • SDO_TOPO_GEOMETRY Type
  • SDO_TOPO_GEOMETRY Constructors
    • Constructors for Insert Operations: Specifying Topological Elements
    • Constructors for Insert Operations: Specifying Lower-Level Features
    • Constructors for Update Operations: Specifying Topological Elements
    • Constructors for Update Operations: Specifying Lower-Level Features
  • GET_GEOMETRY Member Function
  • GET_TGL_OBJECTS Member Function
  • GET_TOPO_ELEMENTS Member Function
  • SDO_LIST_TYPE Type
  • SDO_EDGE_ARRAY and SDO_NUMBER_ARRAY Types
• Topology Metadata Views
  • xxx_SDO_TOPO_INFO Views
  • xxx_SDO_TOPO_METADATA Views
• Topology Application Programming Interface
  • Topology Operators
  • Topology Data Model Java Interface
• Exporting and Importing Topology Data
• Cross-Schema Topology Usage and Editing
  • Cross-Schema Topology Usage
  • Cross-Schema Topology Editing
• Function-Based Indexes Not Supported
• Topology Examples (PL/SQL)
  • Topology Built from Topology Data
  • Topology Built from Spatial Geometries
• README File for Spatial and Graph and Related Features

2 Editing Topologies

• Approaches for Editing Topology Data
  • TopoMap Objects
  • Specifying the Editing Approach with the Topology Parameter
  • Using GET_xxx Topology Functions
  • Process for Editing Using Cache Explicitly (PL/SQL API)
  • Process for Editing Using the Java API
  • Error Handling for Topology Editing
    • Input Parameter Errors
    • All Exceptions
• Performing Operations on Nodes
  • Adding a Node
  • Moving a Node
    • Additional Examples of Allowed and Disallowed Node Moves
  • Removing a Node
  • Removing Obsolete Nodes
• Performing Operations on Edges
  • Adding an Edge
  • Moving an Edge
  • Removing an Edge
  • 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

• Introduction to Network Modeling
• Main Steps in Using the Network Data Model Graph
  • Letting Spatial Perform Most Operations
  • Performing the Operations Yourself
• Network Data Model Graph Concepts
  • Subpaths
  • Features and Feature Layers
• Network Applications
  • Road Network Example
  • Subway (Train) Network Example
  • Multimodal Network and Temporal Examples
  • Utility Network Example
  • Biochemical Network Example
• Network Hierarchy
• Network User Data
  • User-Defined Data Example (PL/SQL and Java)
  • User-Defined Data Example (Custom User Data I/O Implementation)
    • Implementation of writeUserData method of LODUserDataIO
    • Implementation of readUserData method of LODUserDataIO
• Feature Modeling
  • Data Types Used for Feature Modeling
• Network Constraints
• Network Analysis Using Load on Demand
  • Partitioning a Network
  • Generating Partition BLOBs
  • Configuring the Partition Cache
  • Analyzing the Network
  • Using Link Levels for Priority Modeling
  • Precomputed Analysis Results
• Network Data Model Graph Tables
  • Network Layer Tables
    • Node Table
    • Link Table
    • Path Table
    • Path-Link Table
    • Subpath Table
    • Partition Table
    • Partition BLOB Table
    • Connected Component Table
    • Node Hierarchy Table (Optional)
    • Node Level Table (Optional)
  • Feature Layer Tables
    • Feature Table
    • Feature Element Relationships Table
    • Feature Hierarchy Table
• Network Data Model Graph Metadata Views
  • xxx_SDO_NETWORK_METADATA Views
  • xxx_SDO_NETWORK_CONSTRAINTS Views
  • xxx_SDO_NETWORK_USER_DATA Views
  • xxx_SDO_NETWORK_FEATURE Views
• Network Data Model Graph Application Programming Interface
  • Network Data Model Graph PL/SQL Interface
  • Network Data Model Graph Java Interface
    • Network Metadata and Data Management
    • Network Analysis Using the Load on Demand Approach
  • Network Data Model Graph XML Interface
    • User-Specified Implementations
• Cross-Schema Network Access
  • Cross-Schema Access by Specifying Owner in Network Metadata
  • Cross-Schema Access by Using Views
• Network Examples
  • Simple Spatial (SDO) Network Example (PL/SQL)
  • Simple Logical Network Example (PL/SQL)
  • Spatial (LRS) Network Example (PL/SQL)
  • Logical Hierarchical Network Example (PL/SQL)
  • Partitioning and Load on Demand Analysis Examples (PL/SQL, XML, and Java)
  • User-Defined Data Examples (PL/SQL and Java)
• Network Data Model Graph Tutorial and Other Resources
• 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