Table of Contents
- List of Figures
- List of Tables
- Title and Copyright Information
- Preface
-
Changes in This Release for Oracle Spatial and Graph Property Graph Developer's Guide
-
Changes in Oracle Database Release 19c for Property Graph Support
- Update to TinkerPop 3
- New In-Memory Analyst REST API
- New In-Memory Analyst APIs for Release 19c
- Additions to PGQL Support in In-Memory Analyst for Release 19c
- Deprecation of Two-Table Support
- Deprecation of OraclePgqlResultSet
- Deprecation of Apache Tinkerpop API Support
- Deprecation of Apache Solr and Lucene Support
- Deprecation of Apache Groovy Support
-
Changes in Oracle Database Release 19c for Property Graph Support
- 1 Spatial and Graph Property Graph Support Overview
-
2
Using Property Graphs in an Oracle Database Environment
- 2.1 About Property Graphs
- 2.2 About Property Graph Data Formats
- 2.3 Property Graph Schema Objects for Oracle Database
- 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.2 Parallel Loading of Graph Data
- 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.5.17 Executing PGQL Queries
-
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.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.8 Using the Groovy Shell with Property Graph Data
- 2.9 Using the In-Memory Analyst Zeppelin Interpreter with Oracle Database
- 2.10 REST Support for Oracle Database Property Graph Data
- 2.11 Creating Property Graph Views on an RDF Graph
- 2.12 Handling Property Graphs Using a Two-Tables Schema
-
2.13
Oracle Flat File Format Definition
- 2.13.1 About the Property Graph Description Files
- 2.13.2 Edge File
- 2.13.3 Vertex File
- 2.13.4 Encoding Special Characters
- 2.13.5 Example Property Graph in Oracle Flat File Format
- 2.13.6 Converting an Oracle Database Table to an Oracle-Defined Property Graph Flat File
- 2.13.7 Converting CSV Files for Vertices and Edges to Oracle-Defined Property Graph Flat Files
- 2.14 Example Python User Interface
-
3
Using the In-Memory Analyst (PGX)
- 3.1 Reading a Graph into Memory
- 3.2 Reading Custom Graph Data
- 3.3 Storing Graph Data on Disk
- 3.4 Executing Built-in Algorithms
- 3.5 Creating Subgraphs
- 3.6 Using Automatic Delta Refresh to Handle Database Changes
- 3.7 Deploying to Apache Tomcat
- 3.8 Deploying to Oracle WebLogic Server
- 3.9 Connecting to the In-Memory Analyst Server
- 3.10 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.8
Executing PGQL Queries Directly Against Oracle Database
- 4.8.1 PGQL Features Supported
-
4.8.2
Using the oracle.pg.rdbms Java Package to Execute PGQL Queries
- 4.8.2.1 Basic Query Execution
- 4.8.2.2 Using Bind Variables in PGQL Queries
- 4.8.2.3 Using a Text Index with PGQL Queries
- 4.8.2.4 Obtaining the SQL Translation for a PGQL Query
- 4.8.2.5 Additional Options for PGQL Translation and Execution
- 4.8.2.6 Querying Another User’s Property Graph
- 4.8.2.7 Using Query Optimizer Hints with PGQL
- 4.8.3 Performance Considerations for PGQL Queries
-
5
OPG_APIS Package Subprograms
- 5.1 OPG_APIS.ANALYZE_PG
- 5.2 OPG_APIS.CF
- 5.3 OPG_APIS.CF_CLEANUP
- 5.4 OPG_APIS.CF_PREP
- 5.5 OPG_APIS.CLEAR_PG
- 5.6 OPG_APIS.CLEAR_PG_INDICES
- 5.7 OPG_APIS.CLONE_GRAPH
- 5.8 OPG_APIS.COUNT_TRIANGLE
- 5.9 OPG_APIS.COUNT_TRIANGLE_CLEANUP
- 5.10 OPG_APIS.COUNT_TRIANGLE_PREP
- 5.11 OPG_APIS.COUNT_TRIANGLE_RENUM
- 5.12 OPG_APIS.CREATE_EDGES_TEXT_IDX
- 5.13 OPG_APIS.CREATE_PG
- 5.14 OPG_APIS.CREATE_PG_SNAPSHOT_TAB
- 5.15 OPG_APIS.CREATE_PG_TEXTIDX_TAB
- 5.16 OPG_APIS.CREATE_STAT_TABLE
- 5.17 OPG_APIS.CREATE_SUB_GRAPH
- 5.18 OPG_APIS.CREATE_VERTICES_TEXT_IDX
- 5.19 OPG_APIS.DROP_EDGES_TEXT_IDX
- 5.20 OPG_APIS.DROP_PG
- 5.21 OPG_APIS.DROP_PG_VIEW
- 5.22 OPG_APIS.DROP_VERTICES_TEXT_IDX
- 5.23 OPG_APIS.ESTIMATE_TRIANGLE_RENUM
- 5.24 OPG_APIS.EXP_EDGE_TAB_STATS
- 5.25 OPG_APIS.EXP_VERTEX_TAB_STATS
- 5.26 OPG_APIS.FIND_CC_MAPPING_BASED
- 5.27 OPG_APIS.FIND_CLUSTERS_CLEANUP
- 5.28 OPG_APIS.FIND_CLUSTERS_PREP
- 5.29 OPG_APIS.FIND_SP
- 5.30 OPG_APIS.FIND_SP_CLEANUP
- 5.31 OPG_APIS.FIND_SP_PREP
- 5.32 OPG_APIS.GET_BUILD_ID
- 5.33 OPG_APIS.GET_GEOMETRY_FROM_V_COL
- 5.34 OPG_APIS.GET_GEOMETRY_FROM_V_T_COLS
- 5.35 OPG_APIS.GET_LATLONG_FROM_V_COL
- 5.36 OPG_APIS.GET_LATLONG_FROM_V_T_COLS
- 5.37 OPG_APIS.GET_LONG_LAT_GEOMETRY
- 5.38 OPG_APIS.GET_LATLONG_FROM_V_COL
- 5.39 OPG_APIS.GET_LONGLAT_FROM_V_T_COLS
- 5.40 OPG_APIS.GET_SCN
- 5.41 OPG_APIS.GET_VERSION
- 5.42 OPG_APIS.GET_WKTGEOMETRY_FROM_V_COL
- 5.43 OPG_APIS.GET_WKTGEOMETRY_FROM_V_T_COLS
- 5.44 OPG_APIS.GRANT_ACCESS
- 5.45 OPG_APIS.IMP_EDGE_TAB_STATS
- 5.46 OPG_APIS.IMP_VERTEX_TAB_STATS
- 5.47 OPG_APIS.PR
- 5.48 OPG_APIS.PR_CLEANUP
- 5.49 OPG_APIS.PR_PREP
- 5.50 OPG_APIS.PREPARE_TEXT_INDEX
- 5.51 OPG_APIS.RENAME_PG
- 5.52 OPG_APIS.SPARSIFY_GRAPH
- 5.53 OPG_APIS.SPARSIFY_GRAPH_CLEANUP
- 5.54 OPG_APIS.SPARSIFY_GRAPH_PREP
- 6 OPG_GRAPHOP Package Subprograms
- Supplementary Information for Property Graph Support
- Index