A Using the Property Graph Schema
This chapter provides conceptual and usage information about creating, storing, and working with property graph data in an Oracle Database environment.
You can create a property graph and store it in the property graph schema in Oracle Database in one of the following ways:
- Use the
CREATE PROPERTY GRAPH
statement to create and populate these property graph schema objects. - Use
OPG_APIS.CREATE_PG
, to create the property graph schema objects. Then load data from the database tables into the schema objects using SQL or using the Data Access Layer APIs. The property graph schema provides a flexible schema option for storing your graph.Note:
The original database tables remain as-is and the data is copied from the original tables into the property graph schema tables.
- Property Graph Schema Objects for Oracle Database
The property graph PL/SQL and Java APIs use special Oracle Database schema objects. - Data Access Layer
- Getting Started with Property Graphs
Follow these steps to get started with property graphs. - Using Java APIs for Property Graph Data
Creating a property graph involves using the Java APIs to create the property graph and objects in it. - Access Control for Property Graph Data (Graph-Level and OLS)
Oracle Graph supports two access control and security models: graph level access control, and fine-grained security through integration with Oracle Label Security (OLS). - SQL-Based Property Graph Query and Analytics
You can use SQL to query property graph data in Oracle Spatial and Graph. - Creating Property Graph Views on an RDF Graph
With Oracle Graph, you can view RDF data as a property graph to execute graph analytics operations by creating property graph views over an RDF graph stored in Oracle Database. - Using Automatic Delta Refresh to Handle Database Changes
You can automatically refresh (auto-refresh) graphs periodically to keep the in-memory graph synchronized with changes to the property graph stored in the property graph tables in Oracle Database (VT$ and GE$ tables). - API for Loading Graphs into Memory
Learn about the APIs used for loading a graph using a JSON configuration file or graph configuration object. - Quick Start: Interactively Analyze Graph Data Stored in Property Graph Schema Objects
This tutorial shows how you can quickly get started using property graph data and learn to execute PGQL queries and run graph algorithms on the data and display results. - Working with Property Graph Objects in SQL Developer
You can use Oracle SQL Developer to execute PGQL statements and queries directly on property graph schema graphs in the database. - Executing PGQL Queries Against Property Graph Schema Tables
This topic explains how you can execute PGQL queries directly against the graph stored in property graph schema tables. - OPG_APIS Package Subprograms
The OPG_APIS package contains subprograms (functions and procedures) for working with property graphs in an Oracle database. - OPG_GRAPHOP Package Subprograms
The OPG_GRAPHOP package contains subprograms for various operations on property graphs in an Oracle database.
Parent topic: Supplementary Information for Property Graph Support