Graph Studio
One of the most easiest way to work with graphs is Graph Studio, because, It is provided automatically by Autonomous Data Warehouse(ADW) as part of the same service in the Oracle Cloud and give you the capability to create, analyze and visualize native graphs and even create those from relational models.
In this simplified diagram, you can see the ADW services contains the Oracle database engine, same way, graph studio application is available, connected and ready to use, in others words, ADW is not only about the “engine” and contains the full functionality for graphs and much more and in order to use We only need a modern web browser.
This tutorial assumes you can get access to Autonomous Data Warehouse (ADW) service in Oracle cloud.
Create ADW at free tier
If you has an ADW running up, you can skip this section.
In order to create one ADW instance for free in the Oracle Cloud.
First, go to the Oracle Cloud admin panel and search for Autonomous Data Warehouse and click that option from Services.
Second, as god practice check your current tenancy and compartment, in this example, We are in US East (Ashburn) and Lab respectively.
Third, click on Create Autonomous Database button, many steps here are fine by default, but, I chose:
Warning, to use this service for free verify in the Configure the database section, the always free button is enabled .
Wait a few minutes and done, now ADW is AVAILABLE.
Create a new graph database user
Wen the ADW are available, really the Graph studio is ready to use too, but, you must be create a new database user distinct to default ADMIN with the role GRAPH_DEVELOPER granted.
In order to do this, one option is go to ADW service in the Oracle cloud admin panel and create a new GRAPH database user using Database Actions.
Later, look in the Administration tools for the option to create DATABASE USERS.
There you can create a new database user checking the Graph toggle button and give UNLIMITED Quota on tablespace DATA.
Other options here to do the same as SQL STATEMENTS are valid too, the key is grant to the new database user the GRAPH_DEVELOPER role.
Return to the ADW administration panel and Open Graph Studio link located under the “‘Tools” tab at the control panel and log with the graph user you created.
Finally, you can look something like this:
