14 Using Oracle Graph with Autonomous Database

Oracle Graph with Autonomous Database enables you to create graphs from data in your Autonomous Database. With graphs you can analyze your data based on connections and relationships between data entities.

As an Analyst or a Developer you can use graph algorithms and graph pattern queries for ranking, clustering, and path analysis in a graph model of your data. You can use graph features to detect anomalous patterns, identify communities, and find new connections in your data. Then, you can use graphs in your applications, for example, for fraud detection in banking, improved traceability in smart manufacturing, building linked data applications, and more; all while gaining enterprise-grade security, ease of data ingestion, and support for a wide range of workloads.

Autonomous Database includes all the graph capabilities from Oracle Database. In addition, it includes Graph Studio, which further automates graph data management and simplifies modeling, analysis, and visualization across the graph analytics lifecycle.

About Oracle Graph Studio with Autonomous Database

Graph Studio features include automated modeling to create graphs from database tables, an integrated notebook to run graph queries and analytics, and native graph and other visualizations. You can invoke nearly 60 pre-built graph algorithms and visualize your data with many visualization options. Graph Studio is a fully integrated, automated feature with Autonomous Database.

See Graph Studio: Interactive, Self-Service User Interface and Access Graph Studio Using Oracle Cloud Infrastructure Console for more information on Graph Studio.

Note:

Oracle Autonomous JSON Database does not include Graph Studio.

Building Applications Using Graph APIs with Autonomous Database

If you are developing an application using graphs, you can also access Property Graph APIs and RDF Graph APIs with Autonomous Database without Graph Studio.

  • Property Graph: Create and work with Property Graphs with Python and Java developer APIs and the Property Graph Query Language (PGQL). You can use developer APIs to create a graph, run graph queries, and execute graph algorithms.

    You can use these APIs by deploying Oracle Graph Server and Client from OCI Marketplace.

    See Oracle Database Graph for more information.

  • RDF Graph: Using RDF Graph Server and Query UI you can manage, store, query, and perform inferencing on RDF graphs in Autonomous Database. You can use a REST API, a SPARQL endpoint, a web UI to run SPARQL queries, and developer APIs for advanced RDF graph data management operations.

    You can use these APIs by deploying Oracle RDF Graph Server and Query UI from OCI Marketplace.

    See Using RDF Graph Server and Query UI for more information.

Oracle Graph Limitations with Autonomous Database

Autonomous Database includes Oracle Graph, with some limitations.

Note:

Oracle Graph features are not available with Oracle APEX Application Development (APEX Service).

To ensure the security and performance of your database, some Oracle Graph features are restricted:

  • SPARQL editor for SQL Developer desktop is not supported
  • SEM_MATCH (SPARQL in SQL API), SEM_APIS.UPDATE_MODEL and SEM_APIS.SPARQL_to_SQL are not supported
  • Adapter for Eclipse RDF4J is not supported
  • Adapter for Apache Jena is not supported

The recommended architecture for using RDF Graphs with Autonomous Database is deployment of Oracle RDF Server and Query UI from OCI Marketplace to run SPARQL queries and other RDF data management operations.