Oracle Graph Database is an emerging database technology, which is getting popular among Artificial Intelligence market.Oracle property graph functionality has been provided in Oracle Analytics in latest release of Oracle Analytics Cloud(OAC) and Oracle Analytics Server(OAS).This blog is about how to enable oracle property graph in Oracle Analytics Cloud or Oracle Analytics Server and how to use it in analytics.
Enable Oracle Graph on OAC/OAS
To enable oracle property graph in OAC or OAS a Graph Plug-in is required to be uploaded on OAS/OAC.
Download the Oracle property graph plug in from “Oracle Analytics Extension Library“
Upload Plug-in on OAC/OAS
Once this plug-in will be uploaded then you will find a “Graph Analytics” in Data Flow and these four Graph Algorithms would be available to use in Data Flow.
- Sub Graph
- Clustering
- Shortest Path
- Node Ranking
And a new Graph Visualisation will be added in Visualisation list.
How to use Graph Analytics in OAC & OAS
Create DataFlow with Graph Analytics Algorithm
- Create a Database connection and Dataset based on required Entities having vertices and nodes attributes. For example we have Bank Dataset where Bank Accounts are nodes and Transactions between these accounts are edges.
- Create a Dataflow using this Dataset and take any of the Graph Analytics algorithm mentioned above. Let’s take Clustering algorithm as an example.
- Set the Clustering Algorithm Parameters for e.g. Source Column, Destination Column. In this example We have set Source Column as From_Account and Destination as To_Account.
- Save the Dataset which is an output of the Dataflow.
- In Output dataset all bank accounts will be divided into in different clusters and a cluster id will be assigned to each cluster.
Visualise the Data
- To create Visualisation, join original Bank Dataset with Cluster Dataset so that all attributes(Bank Account Details and Cluster Attribute) are available for Visualisation.
- Create property graph Visualisation(newly added with plug-in) with this combined dataset.
