Skip Headers
Oracle® Spatial Topology and Network Data Models
10
g
Release 2 (10.2)
Part Number B14256-01
Home
Book List
Index
Master Index
Feedback
Next
View PDF
Contents
List of Examples
List of Figures
List of Tables
Title and Copyright Information
Send Us Your Comments
Preface
Audience
Documentation Accessibility
Organization
Related Documentation
Conventions
What's New in the Topology and Network Data Models?
New SDO_TOPO_MAP Subprograms
Additional Topology Operators
New GET_TGL_OBJECTS Member Function
Collection Layers
Features Built from Topological Elements in Parent Layers
New Format for Topology Operators and SDO_TOPO.RELATE Function
Simplified Process for Exporting and Importing Topologies
SDO_NET_MEM Package for Network Editing and Analysis
Bidirected Links
Cost Computation by a PL/SQL Function
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.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 Usage and Editing Considerations
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 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 Overview
5.1
Introduction to Network Modeling
5.2
Main Steps in Using the Network Data Model
5.2.1
Letting Spatial Perform Most Operations
5.2.2
Performing the Operations Yourself
5.3
Network Data Model Concepts
5.4
Network Applications
5.4.1
Road Network Example
5.4.2
Train (Subway) Network Example
5.4.3
Utility Network Example
5.4.4
Biochemical Network Example
5.5
Network Hierarchy
5.6
Network Constraints
5.7
Network Editing and Analysis Using a Network Memory Object
5.8
Network Data Model Tables
5.8.1
Node Table
5.8.2
Link Table
5.8.3
Path Table
5.8.4
Path-Link Table
5.9
Network Data Model Metadata Views
5.9.1
xxx_SDO_NETWORK_METADATA Views
5.9.2
xxx_SDO_NETWORK_CONSTRAINTS Views
5.10
Network Data Model Application Programming Interface
5.10.1
Network Data Model PL/SQL Interface
5.10.2
Network Data Model Java Interface
5.10.2.1
Network Metadata and Data Management
5.10.2.2
Network Analysis
5.10.2.3
Major Interfaces and Methods in the Network Java API
5.11
Network Examples (PL/SQL)
5.11.1
Simple Spatial (SDO) Network Example
5.11.2
Simple Logical Network Example
5.11.3
Spatial (LRS) Network Example
5.11.4
Logical Hierarchical Network Example
5.12
Network Editor and Other Demo Files
5.13
README File for Spatial and Related Features
6
SDO_NET Package Subprograms
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_PATH_LINK_TABLE
SDO_NET.CREATE_PATH_TABLE
SDO_NET.CREATE_SDO_NETWORK
SDO_NET.CREATE_TOPO_NETWORK
SDO_NET.DROP_NETWORK
SDO_NET.GET_CHILD_LINKS
SDO_NET.GET_CHILD_NODES
SDO_NET.GET_GEOMETRY_TYPE
SDO_NET.GET_IN_LINKS
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_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_PATH_GEOM_COLUMN
SDO_NET.GET_PATH_TABLE_NAME
SDO_NET.IS_HIERARCHICAL
SDO_NET.IS_LOGICAL
SDO_NET.IS_SPATIAL
SDO_NET.LRS_GEOMETRY_NETWORK
SDO_NET.NETWORK_EXISTS
SDO_NET.SDO_GEOMETRY_NETWORK
SDO_NET.TOPO_GEOMETRY_NETWORK
SDO_NET.VALIDATE_LINK_SCHEMA
SDO_NET.VALIDATE_LRS_SCHEMA
SDO_NET.VALIDATE_NETWORK
SDO_NET.VALIDATE_NODE_SCHEMA
SDO_NET.VALIDATE_PATH_SCHEMA
7
SDO_NET_MEM Package Subprograms
SDO_NET_MEM.LINK.GET_CHILD_LINKS
SDO_NET_MEM.LINK.GET_CO_LINK_IDS
SDO_NET_MEM.LINK.GET_COST
SDO_NET_MEM.LINK.GET_END_MEASURE
SDO_NET_MEM.LINK.GET_END_NODE_ID
SDO_NET_MEM.LINK.GET_GEOM_ID
SDO_NET_MEM.LINK.GET_GEOMETRY
SDO_NET_MEM.LINK.GET_LEVEL
SDO_NET_MEM.LINK.GET_NAME
SDO_NET_MEM.LINK.GET_PARENT_LINK_ID
SDO_NET_MEM.LINK.GET_SIBLING_LINK_IDS
SDO_NET_MEM.LINK.GET_START_MEASURE
SDO_NET_MEM.LINK.GET_START_NODE_ID
SDO_NET_MEM.LINK.GET_STATE
SDO_NET_MEM.LINK.GET_TYPE
SDO_NET_MEM.LINK.IS_ACTIVE
SDO_NET_MEM.LINK.IS_EXTERNAL_LINK
SDO_NET_MEM.LINK.IS_LOGICAL
SDO_NET_MEM.LINK.IS_TEMPORARY
SDO_NET_MEM.LINK.SET_COST
SDO_NET_MEM.LINK.SET_END_NODE
SDO_NET_MEM.LINK.SET_GEOM_ID
SDO_NET_MEM.LINK.SET_GEOMETRY
SDO_NET_MEM.LINK.SET_LEVEL
SDO_NET_MEM.LINK.SET_MEASURE
SDO_NET_MEM.LINK.SET_NAME
SDO_NET_MEM.LINK.SET_PARENT_LINK
SDO_NET_MEM.LINK.SET_START_NODE
SDO_NET_MEM.LINK.SET_STATE
SDO_NET_MEM.LINK.SET_TYPE
SDO_NET_MEM.NETWORK.ADD_LINK
SDO_NET_MEM.NETWORK.ADD_LRS_NODE
SDO_NET_MEM.NETWORK.ADD_NODE
SDO_NET_MEM.NETWORK.ADD_PATH
SDO_NET_MEM.NETWORK.ADD_SDO_NODE
SDO_NET_MEM.NETWORK.DELETE_LINK
SDO_NET_MEM.NETWORK.DELETE_NODE
SDO_NET_MEM.NETWORK.DELETE_PATH
SDO_NET_MEM.NETWORK_MANAGER.ALL_PATHS
SDO_NET_MEM.NETWORK_MANAGER.CREATE_LOGICAL_NETWORK
SDO_NET_MEM.NETWORK_MANAGER.CREATE_LRS_NETWORK
SDO_NET_MEM.NETWORK_MANAGER.CREATE_REF_CONSTRAINTS
SDO_NET_MEM.NETWORK_MANAGER.CREATE_SDO_NETWORK
SDO_NET_MEM.NETWORK_MANAGER.DISABLE_REF_CONSTRAINTS
SDO_NET_MEM.NETWORK_MANAGER.DROP_NETWORK
SDO_NET_MEM.NETWORK_MANAGER.ENABLE_REF_CONSTRAINTS
SDO_NET_MEM.NETWORK_MANAGER.FIND_CONNECTED_COMPONENTS
SDO_NET_MEM.NETWORK_MANAGER.FIND_REACHABLE_NODES
SDO_NET_MEM.NETWORK_MANAGER.FIND_REACHING_NODES
SDO_NET_MEM.NETWORK_MANAGER.IS_REACHABLE
SDO_NET_MEM.NETWORK_MANAGER.LIST_NETWORKS
SDO_NET_MEM.NETWORK_MANAGER.MCST_LINK
SDO_NET_MEM.NETWORK_MANAGER.NEAREST_NEIGHBORS
SDO_NET_MEM.NETWORK_MANAGER.READ_NETWORK
SDO_NET_MEM.NETWORK_MANAGER.SHORTEST_PATH
SDO_NET_MEM.NETWORK_MANAGER.SHORTEST_PATH_DIJKSTRA
SDO_NET_MEM.NETWORK_MANAGER.TSP_PATH
SDO_NET_MEM.NETWORK_MANAGER.VALIDATE_NETWORK_SCHEMA
SDO_NET_MEM.NETWORK_MANAGER.WITHIN_COST
SDO_NET_MEM.NETWORK_MANAGER.WRITE_NETWORK
SDO_NET_MEM.NODE.GET_ADJACENT_NODE_IDS
SDO_NET_MEM.NODE.GET_CHILD_NODE_IDS
SDO_NET_MEM.NODE.GET_COMPONENT_NO
SDO_NET_MEM.NODE.GET_COST
SDO_NET_MEM.NODE.GET_EXTERNAL_NETWORK_ID
SDO_NET_MEM.NODE.GET_EXTERNAL_NETWORK_NAME
SDO_NET_MEM.NODE.GET_EXTERNAL_NODE_ID
SDO_NET_MEM.NODE.GET_GEOM_ID
SDO_NET_MEM.NODE.GET_GEOMETRY
SDO_NET_MEM.NODE.GET_HIERARCHY_LEVEL
SDO_NET_MEM.NODE.GET_IN_LINK_IDS
SDO_NET_MEM.NODE.GET_INCIDENT_LINK_IDS
SDO_NET_MEM.NODE.GET_MEASURE
SDO_NET_MEM.NODE.GET_NAME
SDO_NET_MEM.NODE.GET_OUT_LINK_IDS
SDO_NET_MEM.NODE.GET_PARENT_NODE_ID
SDO_NET_MEM.NODE.GET_PARTITION_ID
SDO_NET_MEM.NODE.GET_SIBLING_NODE_IDS
SDO_NET_MEM.NODE.GET_STATE
SDO_NET_MEM.NODE.GET_TYPE
SDO_NET_MEM.NODE.IS_ACTIVE
SDO_NET_MEM.NODE.IS_EXTERNAL_NODE
SDO_NET_MEM.NODE.IS_LOGICAL
SDO_NET_MEM.NODE.IS_TEMPORARY
SDO_NET_MEM.NODE.LINK_EXISTS
SDO_NET_MEM.NODE.MAKE_TEMPORARY
SDO_NET_MEM.NODE.SET_COMPONENT_NO
SDO_NET_MEM.NODE.SET_COST
SDO_NET_MEM.NODE.SET_EXTERNAL_NETWORK_ID
SDO_NET_MEM.NODE.SET_EXTERNAL_NODE_ID
SDO_NET_MEM.NODE.SET_GEOM_ID
SDO_NET_MEM.NODE.SET_GEOMETRY
SDO_NET_MEM.NODE.SET_HIERARCHY_LEVEL
SDO_NET_MEM.NODE.SET_MEASURE
SDO_NET_MEM.NODE.SET_NAME
SDO_NET_MEM.NODE.SET_PARENT_NODE
SDO_NET_MEM.NODE.SET_STATE
SDO_NET_MEM.NODE.SET_TYPE
SDO_NET_MEM.PATH.GET_COST
SDO_NET_MEM.PATH.GET_END_NODE_ID
SDO_NET_MEM.PATH.GET_GEOMETRY
SDO_NET_MEM.PATH.GET_LINK_IDS
SDO_NET_MEM.PATH.GET_NAME
SDO_NET_MEM.PATH.GET_NO_OF_LINKS
SDO_NET_MEM.PATH.GET_NODE_IDS
SDO_NET_MEM.PATH.GET_START_NODE_ID
SDO_NET_MEM.PATH.GET_TYPE
SDO_NET_MEM.PATH.IS_ACTIVE
SDO_NET_MEM.PATH.IS_CLOSED
SDO_NET_MEM.PATH.IS_CONNECTED
SDO_NET_MEM.PATH.IS_LOGICAL
SDO_NET_MEM.PATH.IS_SIMPLE
SDO_NET_MEM.PATH.IS_TEMPORARY
SDO_NET_MEM.PATH.SET_GEOMETRY
SDO_NET_MEM.PATH.SET_NAME
SDO_NET_MEM.PATH.SET_PATH_ID
SDO_NET_MEM.PATH.SET_TYPE
Index
