Graph Studio FAQ

FAQ topics

General Questions

What is Graph Studio?

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:

  • 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. It is not a part of Oracle APEX or Autonomous JSON Database.

Watch a tour of the Graph Studio interface (3:48)

How can I access Graph Studio?

You can access Graph Studio in two ways from the Oracle Cloud Infrastructure (OCI) console:

  • Go to “Database Actions” and click Graph Studio.

or

  • Find Graph Studio among the tools under your Autonomous Database's Tools Configuration tab, copy the Graph Studio link, then paste it into a new browser tab.

You need to create a database user with an assigned GRAPH_DEVELOPER role to log on to Graph Studio.

What kind of analytics are possible with 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.

Is Graph Studio available on-premises?

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.

Pricing and licensing

What is the price of graph features in Autonomous Database Serverless?

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.

What is the price of Graph Studio?

No additional licenses are required when using Graph Studio with Autonomous Data Warehouse Serverless and Autonomous Transaction Processing Serverless.

Does Graph Studio offer free trial licenses?

Yes. Autonomous Database offers free 30-day trials, and Graph Studio is included.

Is Graph Studio included in a completely free service?

Yes. Autonomous Database Serverless offers a free service, and Graph Studio is part of this offering.

Security

Which roles and privileges are required to use Graph Studio?

As a database user, you can access the graph features once you have the GRAPH_DEVELOPER role assigned.

How does Graph Studio provide data security?

All the security mechanisms of Autonomous Database apply. Read more about the security features of Autonomous Database.

Architecture

What are the main architectural components of Graph Studio?

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.

What are the main features of Graph Studio?

Graph Studio is an integrated, self-service tool to work with graphs. It includes:

  • An automated modeling tool to conveniently map relational data to a graph model
  • A browser-based notebook environment enhanced with graph-specific features such as integrated visualization and extensive analytics and query support
  • A graphical user interface to manage graph data
  • Automated install, upgrade, and provisioning

Graph Studio also contains sample data and demo notebooks to illustrate how to get started.

Loading data

Which tools can be used to load data into Graph Studio?

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.

Query and analysis

How can I search for graph patterns in my data?

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.

Which graph algorithms does Graph Studio support?

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.

Which programming languages are supported in Graph Studio?

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.

Application development

How can I develop applications that include Graph Studio and Autonomous Database?

You can download Oracle Graph Client and use Graph Studio APIs in your application to work with Graph Studio in Autonomous Database Serverless.

Performance

How can I control the amount of memory dedicated to graph analytics?

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.

Do I need to create indices on my graph data to achieve optimal performance?

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.

Migration

How can I use a PGQL DDL statement I have created previously to map relational data to a graph model?

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.