Integrated Graph Database Features

High performing, scalable, and secure Graph analysis

As a fully integrated feature of Oracle Database, Oracle Graph inherits security, scalability, and high performing capabilities.

Comprehensive Graph support

Oracle Graph supports both RDF (resource description framework) and property graphs on operational data. Plus, developers can now easily build graph applications with SQL using existing SQL development tools and frameworks through SQL property graphs.

RDF graphs

RDF graphs are designed to represent statements and are best for representing complex metadata and master data. Use Oracle Graph, which adheres to W3C standards, for linked data, data integration, and knowledge graphs.

Property graphs

Use property graphs to model data as vertex and edge relationships to query and analyze data based on those relationships.

SQL property graphs

Oracle Database 23ai is the first commercial database to implement the new SQL:2023 standard, making it simple for anyone with SQL knowledge to define and query graph models.

Read the SQL property graphs datasheet (PDF)

More than 60 out-of-box parallelized, in-memory algorithms

Oracle Graph includes more than 60 graph algorithms enabling you to perform ranking, community detection, pathfinding, link prediction, machine learning (ML), and more. You can also use the output as input to a machine learning process so your ML models can use the indirect relationships to improve the accuracy of the predictions. The algorithms are parallelized for scalability and performance against operational data.

Community detection algorithms

Includes: Strongly Connected Components, Weakly Connected Components, Label Propagation, Louvain, Conductance Minimization, and Infomap.

Topology analysis algorithms

Includes: Conductance, Cycle Detection, Degree Distribution, Eccentricity, K-Core, LCC, Modularity, Reachability Topological Ordering, Triangle Counting, Bipartite Check, and Partition Conductance.

Ranking and walking algorithms

Includes: PageRank, Personalized PageRank, Degree Centrality, Closeness Centrality, Vertex Betweenness Centrality, Eigenvector Centrality, HITS, Minimum Spanning-Tree (Prim's), Breadth-First Search, Depth-First Search, and Random Walk with Restart.

Path-finding algorithms

Includes: Shortest Path (Bellman-Ford, Dijkstra, Bidirectional Dijkstra), Fattest Path, Compute Distance Index, Enumerate Simple Paths, Filtered and Unfiltered Fast Path Finding, and Hop Distance.

Link prediction and other algorithms

Includes: Twitter Who-to-follow, SALSA, and Adamic-Adar Index.

Machine learning algorithms

Includes: DeepWalk, Supervised GraphWise, Unsupervised GraphWise, Pg2Vec, Matrix Factorization, and GNNExplainer.

Oracle Graph Studio in Autonomous Database

With Graph Studio, almost anyone can get started with graphs to explore relationships in data. Graph Studio removes barriers to entry by automating complicated setup and management, making data integration seamless, and by providing step-by-step examples for getting started, all while offering powerful algorithms, a speedy in-memory analytics server, and advanced visualization.

Read the ebook (PDF)

Graph Studio includes:

  • Automated graph modeling
  • Extensive graph analytics and graph query support
  • Advanced notebooks and integrated visualization
  • Automated install, upgrade, and provisioning

Graph Studio is included at no additional cost in Autonomous Database Free Tier, Autonomous Data Warehouse Serverless, and Autonomous Transaction Processing Serverless.

For more information on Graph Studio, see the Graph Studio FAQ.

Graph modeling

Use an intuitive UI to create a property and RDF graph. You can create a property from relational tables or from an RDF graph. Import RDF data and create an RDF graph or an RDF graph collection through a wizard.

Graph visualization

Visually explore and interact with a graph to discover patterns. You can annotate and save the graph to communicate your discoveries with others.


Improve productivity and team collaboration by developing, organizing, executing, and sharing code through an interactive, browser-based notebook with nine interpreters. You can also visualize results without using the command line or installing a separate tool.

Interpreters support

  • pgql-rdbms to run PGQL queries in database.
  • pgql-pgx to run PGQL queries against the embedded Graph Server.
    • This requires the graph is loaded into memory through the UI or programmatically through the python-pgx or java-pgx paragraphs.
    • When algorithms are run from the python-pgx or java-pgx paragraphs, the results are reflected on the in-memory graph, so you would use this interpreter to query for those results.
  • python-pgx and java-pgx to write custom Python or Java code, including using the Python/Java APIs to load graphs to the embedded Graph Server and run graph algorithms.
  • custom-algorithms-pgx to write your own custom PGX graph algorithms.
  • sparql-rdf to write sparql queries on an RDF graph.
  • SQL to run SQL queries, create tables, or insert data into tables.
  • Markdown to add descriptions to your notebook.
  • Conda to install third-party libraries.

In-memory performance

Using Autonomous Database as its persistent data layer, Graph Studio moves Graph data into an in-memory structure for fast and efficient analysis. Graph Studio automatically calculates required memory allocation, so you do not have to manually manage it.

Graph Server and Client

Oracle Graph Server and Client enables developers, analysts, and data scientists to use graphs within Oracle Database. It may also be used as a user managed graph environment with Oracle.

It includes a high-speed, in-memory, parallel server for property graph query and analytics, an RDF graph server and query UI to run SPARQL queries, and client components such as command-line shells for working with the graph API, a plugin for SQLcl to run PGQL queries, a Python client for Jupyter notebooks, interpreters for Apache Zeppelin notebook, and a graph visualization tool.

Download Oracle Graph Server and Client

Oracle named a Leader in the Forrester Wave™: Graph Data Platforms, Q4 2020

Oracle Graph Server and Client includes:

  • Graph Server
  • Graph Client
  • Graph Client for Apache Zeppelin
  • Graph HDFS Connector
  • PGQL Plugin for SQLcl
  • Graph visualization application
  • RDF Server and Query UI
  • Graph PL/SQL patch
  • Graph Server REST API

Graph modeling

Use PGQL to write a Create Property Graph statement and create a property graph on your tables. This can be executed from any PGQL tool, such as the PGQL worksheet in SQL Developer, JShell, and the Python and Java APIs.

Graph visualization

Graph Server includes a Graph visualization application you can use to visually explore and interact with a graph to discover patterns. Graph Server also has REST API endpoints that you can use with the Oracle Graph Visualization Library to visualize graphs in your JavaScript application.