Graph Studio is a self-service graph database, data management, and analytics environment for developers, data scientists, and database administrators. It takes advantage of the graph feature in Oracle Autonomous Database, which offers many prebuilt graph algorithms. With the addition of Graph Studio, Oracle Autonomous Database is now a complete, managed platform for analyzing and visualizing your data as a graph.
With Oracle Autonomous Database and Graph Studio, you gain a complete graph database platform that can be deployed in minutes with one-click provisioning, integrated tooling, and security, which makes graph analytics a possibility even for beginners.
The new comprehensive tooling includes:
Graph Studio is included at no additional cost in Autonomous Database Free Tier, Autonomous Data Warehouse Serverless, and Autonomous Transaction Processing Serverless. It is not a part of Oracle APEX or Autonomous JSON Database.
You can access Graph Studio in two ways from the Oracle Cloud Infrastructure (OCI) console:
You need to create a database user with an assigned GRAPH_DEVELOPER role to log on to Graph Studio.
Using Graph Studio, you can perform pattern-matching queries using PGQL, a SQL-like language, which allows you to specify graph patterns following the language specification. You also have access to more than 60 graph algorithms for a wide range of purposes, including ranking and walking, community detection, pathfinding, evaluating graph structures, and link prediction. When Autonomous Database starts supporting Oracle Database 23c, it will support SQL property graphs, allowing you to perform pattern-matching queries using SQL and run more than 60 algorithms on SQL property graphs.
No. Graph Studio is tightly integrated with OCI, and there are currently no plans to make it available on-premises. For graph analysis on-premises or on Oracle Cloud IaaS, we recommend the Oracle Graph Server and Client Kit, which is available for download.
No additional licenses are required when using the graph features of Autonomous Database Serverless. For more details on licensing Autonomous Database, see the related FAQ document.
No additional licenses are required when using Graph Studio with Autonomous Data Warehouse Serverless and Autonomous Transaction Processing Serverless.
Yes. Autonomous Database offers free 30-day trials, and Graph Studio is included.
Yes. Autonomous Database Serverless offers a free service, and Graph Studio is part of this offering.
As a database user, you can access the graph features once you have the GRAPH_DEVELOPER role assigned.
All the security mechanisms of Autonomous Database apply. Read more about the security features of Autonomous Database.
Graph Studio uses Autonomous Database as its persistence layer. From there, graph data is moved into in-memory data structures for analysis. You can use Graph Studio to manage graphs, to map relational tables to a graph model, and to analyze the resulting graph data.
Graph Studio is an integrated, self-service tool to work with graphs. It includes:
Graph Studio also contains sample data and demo notebooks to illustrate how to get started.
Graph Studio uses the underlying Autonomous Database as a staging area, so any tools or solutions working with Autonomous Database as a data store can be used. This includes Oracle GoldenGate and Oracle Data Integration. Discover more details on loading data into Autonomous Database.
For graph pattern-matching, Graph Studio offers Property Graph Query Language (PGQL) support. PGQL is a SQL-like query language for the property graph data model that allows you to specify high-level graph patterns which are matched against vertices and edges in a graph. PGQL has support for grouping (GROUP BY), aggregation (for example, MIN, MAX, AVG, SUM), sorting (ORDER BY), and many other familiar SQL constructs. Furthermore, PGQL has powerful regular expression constructs for graph reachability, shortest path finding, and cheapest path finding. Learn more about the latest language specification along with many examples.
Graph Studio includes more than 60 optimized, built-in graph algorithms for tasks such as ranking and walking, community detection, pathfinding, link prediction, or structure evaluation. Discover more details on the specific algorithms.
The notebook in Graph Studio includes Java and Python interpreters to access the Graph APIs and two PGQL interpreters to execute pattern-matching queries against the graph, either in database or in the in-memory server (PGX). The notebook also includes a Conda interpreter, so you can use third-party libraries with your Python paragraphs, and a SQL interpreter so you can access your data via SQL. When Autonomous Database starts supporting Oracle Database 23c, you can also use the SQL interpreter to execute pattern-matching queries against your SQL property graphs.
You can download Oracle Graph Client and use Graph Studio APIs in your application to work with Graph Studio in Autonomous Database Serverless.
Graph Studio automatically calculates how much memory is required to move the graph data into in-memory data structures for analysis. To speed up the process, it is possible to pre-allocate memory in Graph Studio.
No. The underlying Autonomous Database takes care of determining the optimal access path for the tabular data structures, and for in-memory graph analysis, there are specific data structures in place that do not require the explicit creation of indices.
The Graph Modeler in Graph Studio generates PGQL DDL as part of the modeling process. If you have already created a PGQL DDL statement previously, you can copy and paste it into the Graph Modeler and either work with it as-is or refine it if needed. Alternatively, you can enter the PGQL DDL statement in the ‘Query Playground’ under the ‘Graphs’ menu icon.