Frequently Asked Questions

Open all Close all

    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. With the addition of Graph Studio, Oracle Autonomous Database is now a complete, managed platform for analyzing and visualizing graph models.

    With Oracle Autonomous Database, 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 in Autonomous Database Free Tier, Autonomous Data Warehouse on Shared Infrastructure, and Autonomous Transaction Processing on Shared Infrastructure. It is not a part of APEX Service or Autonomous JSON.

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

  • How can I access Graph Studio?

    Graph Studio is among the tools you can find under the ‘Development’ tab or the ‘Tools’ tab of your Autonomous Database. 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?

    With the graph features of the Autonomous Database, you can search for specific patterns in your graph and you can execute a large number of prebuilt graph algorithms. Using Graph Studio, you can perform pattern-matching queries using a SQL-like language, PGQL, which allows you to specify graph patterns following the language specification. You also have access to 60 graph algorithms for ranking and walking, community detection, path-finding, or evaluating graph structures, for link prediction, or other purposes.

  • Is Graph Studio available on-premises?

    No, Graph Studio is tightly integrated with Oracle Cloud Infrastructure 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 the graph features of the Autonomous Database?

    Graph Studio and the graph features of Oracle Autonomous Database, Oracle Autonomous Data Warehouse, and Oracle Autonomous Transaction Processing require no separate subscription fees or licenses. For more details on licensing Autonomous Database, see the related FAQ document.

  • 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 offers a free service on Shared Exadata Infrastructure and Graph Studio is part of this offering.


  • 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 of the security mechanisms of Autonomous Database apply. Read more about the security features of the Autonomous Database.


  • 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 the data, 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 graph 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 an SQL-based 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 almost 60 optimized, built-in graph algorithms for tasks such as ranking and walking, community detection, path-finding, 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, as well as a PGQL interpreter to execute pattern-matching queries against the graph.


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

    Graph Studio calculates automatically 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 preallocate 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 which do not require the explicit creation of indices.


  • 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.