Go to main content
1/12
Contents
List of Figures
List of Tables
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Related Documents
Conventions
1
Spatial and Graph Property Graph Support Overview
1.1
About Property Graph Support
1.2
Property Graph Features
1.2.1
Property Graph Sizing Recommendations
1.3
Spatial Support in Property Graphs
1.3.1
Representing Spatial Data in a Property Graph
1.3.2
Creating a Spatial Index on Property Graph Data
1.3.3
Querying Spatial Data in a Property Graph
2
Using Property Graphs in an Oracle Database Environment
2.1
About Property Graphs
2.1.1
What Are Property Graphs?
2.1.2
What Is Oracle Database Support for Property Graphs?
2.1.2.1
In-Memory Analyst
2.1.2.2
Data Access Layer
2.1.2.3
Storage Management
2.2
About Property Graph Data Formats
2.2.1
GraphML Data Format
2.2.2
GraphSON Data Format
2.2.3
GML Data Format
2.2.4
Oracle Flat File Format
2.3
Property Graph Schema Objects for Oracle Database
2.3.1
Default Indexes on Vertex (VT$) and Edge (GE$) Tables
2.3.2
Flexibility in the Property Graph Schema
2.4
Getting Started with Property Graphs
2.5
Using Java APIs for Property Graph Data
2.5.1
Overview of the Java APIs
2.5.1.1
Oracle Spatial and Graph Property Graph Java APIs
2.5.1.2
TinkerPop Blueprints Java APIs
2.5.1.3
Oracle Database Property Graph Java APIs
2.5.2
Parallel Loading of Graph Data
2.5.2.1
JDBC-Based Data Loading
2.5.2.2
External Table-Based Data Loading
2.5.2.3
SQL*Loader-Based Data Loading
2.5.3
Parallel Retrieval of Graph Data
2.5.4
Using an Element Filter Callback for Subgraph Extraction
2.5.5
Using Optimization Flags on Reads over Property Graph Data
2.5.6
Adding and Removing Attributes of a Property Graph Subgraph
2.5.7
Getting Property Graph Metadata
2.5.8
Merging New Data into an Existing Property Graph
2.5.9
Opening and Closing a Property Graph Instance
2.5.10
Creating Vertices
2.5.11
Creating Edges
2.5.12
Deleting Vertices and Edges
2.5.13
Reading a Graph from a Database into an Embedded In-Memory Analyst
2.5.14
Specifying Labels for Vertices
2.5.15
Building an In-Memory Graph
2.5.16
Dropping a Property Graph
2.6
Managing Text Indexing for Property Graph Data
2.6.1
Configuring a Text Index for Property Graph Data
2.6.2
Using Automatic Indexes for Property Graph Data
2.6.3
Using Manual Indexes for Property Graph Data
2.6.4
Executing Search Queries Over a Property Graph’s Text Indexes
2.6.5
Handling Data Types
2.6.5.1
Appending Data Type Identifiers on Apache Lucene
2.6.5.2
Appending Data Type Identifiers on SolrCloud
2.6.5.3
Handling Data Types on Oracle Text
2.6.6
Uploading a Collection's SolrCloud Configuration to Zookeeper
2.6.7
Updating Configuration Settings on Text Indexes for Property Graph Data
2.6.8
Using Parallel Query on Text Indexes for Property Graph Data
2.6.9
Using Native Query Objects on Text Indexes for Property Graph Data
2.6.10
Using Native Query Results on Text Indexes for Property Graph Data
2.7
Access Control for Property Graph Data (Graph-Level and OLS)
2.7.1
Applying Oracle Label Security (OLS) on Property Graph Data
2.8
Using the Groovy Shell with Property Graph Data
2.9
Creating Property Graph Views on an RDF Graph
2.10
Handling Property Graphs Using a Two-Tables Schema
2.10.1
Preparing the Two-Tables Schema
2.10.2
Storing Data in a Property Graph Using a Two-Tables Schema
2.10.3
Reading Data from a Property Graph Using a Two-Tables Schema
2.11
Oracle Flat File Format Definition
2.11.1
About the Property Graph Description Files
2.11.2
Edge File
2.11.3
Vertex File
2.11.4
Encoding Special Characters
2.11.5
Example Property Graph in Oracle Flat File Format
2.11.6
Converting an Oracle Database Table to an Oracle-Defined Property Graph Flat File
2.11.7
Converting CSV Files for Vertices and Edges to Oracle-Defined Property Graph Flat Files
2.12
Example Python User Interface
3
Using the In-Memory Analyst (PGX)
3.1
Reading a Graph into Memory
3.1.1
Connecting to an In-Memory Analyst Server Instance
3.1.2
Using the Shell Help
3.1.3
Providing Graph Metadata in a Configuration File
3.1.4
Reading Graph Data into Memory
3.1.4.1
Read a Graph Stored in Oracle Database into Memory
3.1.4.2
Read a Graph Stored in the Local File System into Memory
3.2
Reading Custom Graph Data
3.2.1
Creating a Simple Graph File
3.2.2
Adding a Vertex Property
3.2.3
Using Strings as Vertex Identifiers
3.2.4
Adding an Edge Property
3.3
Storing Graph Data on Disk
3.3.1
Storing the Results of Analysis in a Vertex Property
3.3.2
Storing a Graph in Edge-List Format on Disk
3.4
Executing Built-in Algorithms
3.4.1
About the In-Memory Analyst
3.4.2
Running the Triangle Counting Algorithm
3.4.3
Running the Pagerank Algorithm
3.5
Creating Subgraphs
3.5.1
About Filter Expressions
3.5.2
Using a Simple Filter to Create a Subgraph
3.5.3
Using a Complex Filter to Create a Subgraph
3.5.4
Using a Vertex Set to Create a Bipartite Subgraph
3.6
Using Automatic Delta Refresh to Handle Database Changes
3.6.1
Configuring the In-Memory Server for Auto-Refresh
3.6.2
Configuring Basic Auto-Refresh
3.6.3
Reading the Graph Using the In-Memory Analyst or a Java Application
3.6.4
Checking Out a Specific Snapshot of the Graph
3.6.5
Advanced Auto-Refresh Configuration
3.7
Deploying to Jetty
3.7.1
About the Authentication Mechanism
3.8
Deploying to Apache Tomcat
3.9
Deploying to Oracle WebLogic Server
3.9.1
Installing Oracle WebLogic Server
3.9.2
Deploying the In-Memory Analyst
3.9.3
Verifying That the Server Works
3.10
Connecting to the In-Memory Analyst Server
3.10.1
Connecting with the In-Memory Analyst Shell
3.10.1.1
About Logging HTTP Requests
3.10.2
Connecting with Java
3.10.3
Connecting with an HTTP Request
3.11
Managing Property Graph Snapshots
4
SQL-Based Property Graph Query and Analytics
4.1
Simple Property Graph Queries
4.2
Text Queries on Property Graphs
4.3
Navigation and Graph Pattern Matching
4.4
Navigation Options: CONNECT BY and Parallel Recursion
4.5
Pivot
4.6
SQL-Based Property Graph Analytics
4.7
Property Graph Query Language (PGQL)
4.7.1
Topology Constraints with PGQL
4.7.2
Constraints are Directional with PGQL
4.7.3
Vertex and Edge Labels with PGQL
4.7.4
Regular Path Queries with PGQL
4.7.5
Aggregation and Sorting with PGQL
5
OPG_APIS Package Subprograms
5.1
OPG_APIS.ANALYZE_PG
5.2
OPG_APIS.CLEAR_PG
5.3
OPG_APIS.CLEAR_PG_INDICES
5.4
OPG_APIS.CLONE_GRAPH
5.5
OPG_APIS.COUNT_TRIANGLE
5.6
OPG_APIS.COUNT_TRIANGLE_CLEANUP
5.7
OPG_APIS.COUNT_TRIANGLE_PREP
5.8
OPG_APIS.COUNT_TRIANGLE_RENUM
5.9
OPG_APIS.CREATE_EDGES_TEXT_IDX
5.10
OPG_APIS.CREATE_PG
5.11
OPG_APIS.CREATE_PG_SNAPSHOT_TAB
5.12
OPG_APIS.CREATE_PG_TEXTIDX_TAB
5.13
OPG_APIS.CREATE_STAT_TABLE
5.14
OPG_APIS.CREATE_SUB_GRAPH
5.15
OPG_APIS.CREATE_VERTICES_TEXT_IDX
5.16
OPG_APIS.DROP_EDGES_TEXT_IDX
5.17
OPG_APIS.DROP_PG
5.18
OPG_APIS.DROP_PG_VIEW
5.19
OPG_APIS.DROP_VERTICES_TEXT_IDX
5.20
OPG_APIS.ESTIMATE_TRIANGLE_RENUM
5.21
OPG_APIS.EXP_EDGE_TAB_STATS
5.22
OPG_APIS.EXP_VERTEX_TAB_STATS
5.23
OPG_APIS.FIND_CC_MAPPING_BASED
5.24
OPG_APIS.FIND_CLUSTERS_CLEANUP
5.25
OPG_APIS.FIND_CLUSTERS_PREP
5.26
OPG_APIS.FIND_SP
5.27
OPG_APIS.FIND_SP_CLEANUP
5.28
OPG_APIS.FIND_SP_PREP
5.29
OPG_APIS.GET_BUILD_ID
5.30
OPG_APIS.GET_GEOMETRY_FROM_V_COL
5.31
OPG_APIS.GET_GEOMETRY_FROM_V_T_COLS
5.32
OPG_APIS.GET_LATLONG_FROM_V_COL
5.33
OPG_APIS.GET_LATLONG_FROM_V_T_COLS
5.34
OPG_APIS.GET_LONG_LAT_GEOMETRY
5.35
OPG_APIS.GET_LATLONG_FROM_V_COL
5.36
OPG_APIS.GET_LONGLAT_FROM_V_T_COLS
5.37
OPG_APIS.GET_SCN
5.38
OPG_APIS.GET_VERSION
5.39
OPG_APIS.GET_WKTGEOMETRY_FROM_V_COL
5.40
OPG_APIS.GET_WKTGEOMETRY_FROM_V_T_COLS
5.41
OPG_APIS.GRANT_ACCESS
5.42
OPG_APIS.IMP_EDGE_TAB_STATS
5.43
OPG_APIS.IMP_VERTEX_TAB_STATS
5.44
OPG_APIS.PR
5.45
OPG_APIS.PR_CLEANUP
5.46
OPG_APIS.PR_PREP
5.47
OPG_APIS.PREPARE_TEXT_INDEX
5.48
OPG_APIS.RENAME_PG
5.49
OPG_APIS.SPARSIFY_GRAPH
5.50
OPG_APIS.SPARSIFY_GRAPH_CLEANUP
5.51
OPG_APIS.SPARSIFY_GRAPH_PREP
6
OPG_GRAPHOP Package Subprograms
6.1
OPG_GRAPHOP.POPULATE_SKELETON_TAB
Index
Scripting on this page enhances content navigation, but does not change the content in any way.