4 Introduction to SQL Property Graphs

You can work with SQL property graphs in any SQL based interface (such as SQL Developer, SQLPLUS, or SQLcl) or from a Java program using JDBC.

Using SQL statements, you can perform the following:

• Create a SQL property graph from existing database objects in your schema, such as:
  • Tables.
    • See Special Instructions for Creating SQL Property Graphs with Advanced Table Features for certain tables that require special instructions.
    • See Limitations of Creating a SQL Property Graph for some exceptions.
  • Views.

    See Creating a SQL Property Graph Using Database Views for more information.

  • Materialized views.
  • External tables.
  • Synonyms for any of the preceding database objects.
• Create a synonym for a SQL property graph.
• Revalidate a SQL property graph.
• Rename a SQL property graph
• Run graph pattern matching queries on a SQL property graph.
• Drop a SQL property graph.

For example, the following figure shows the creation of a SQL property graph using the SQL Developer tool.

Figure 4-1 Using SQL Developer to Create a SQL Property Graph

Description of "Figure 4-1 Using SQL Developer to Create a SQL Property Graph"

• Quick Start for Working with SQL Property Graphs
  This tutorial helps you get started on creating, querying, and running graph algorithms on a SQL property graph.
• Quick Start: Creating a SQL Property Graph by Importing Graph Data from Neo4j
  Oracle Graph provides PL/SQL scripts that allow you to import Neo4j graph data and create a SQL property graph in either your Oracle Autonomous AI Database instance or an on-premises Oracle AI Database.