5 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:

1. Use the CREATE PROPERTY GRAPH statement to create and populate these property graph schema objects.
2. 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.
• Managing Text Indexing for Property Graph Data
  Indexes in Oracle Spatial and Graph property graph support allow fast retrieval of elements by a particular key/value or key/text pair. These indexes are created based on an element type (vertices or edges), a set of keys (and values), and an index type.
• 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.