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:
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.
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.
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.
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.
Yes. Autonomous Database offers free 30-day trials and Graph Studio is included.
Yes. Autonomous Database offers a free service on Shared Exadata Infrastructure 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 of the security mechanisms of Autonomous Database apply. Read more about the security features of the 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 the data, 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 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.
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.
Currently, the notebook in Graph Studio includes a Java interpreter to access the Graph APIs, as well as a PGQL interpreter to execute pattern matching queries against the graph. The Python API, which is available in the Graph Server and Client Kit on-premises, is not yet available in Graph Studio.
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.
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.
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.