Oracle Cloud Infrastructure Documentation

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 Graph Studio, which automates graph data management and simplifies modeling, analysis, and visualization across the graph analytics lifecycle. Autonomous Database includes all the graph capabilities from Oracle Database, except the following:

  • When using RDF graphs, querying external data sources using SPARQL federated queries is not supported.

  • Triple level security in RDF graphs using Oracle Label Security are not supported. See Fine-Grained Access Control for RDF Data for more information.

Database roles must be set to use Graph Studio on an Autonomous Database instance. See Required Roles to Access Tools from Database Actions for more information.

Parent topic: Features

About Oracle Graph Studio on Autonomous Database

Graph Studio allows you to work with the two popular graph models, property graphs and RDF graphs.

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 easily create and manage either of the graph models. You can validate the graphs by executing queries and exploring their properties.

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

Notes for Graph Studio on Autonomous Database:

  • Graph Studio is supported with Data Warehouse and Transaction Processing workloads.

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.