Skip to main content

Posts

Showing posts with the label sub graph

Working with Graphs in Oracle Analytics - Subgraph, Shortest Path, Clusters

In my previous post I described, in a bit more details, how to perform graph analysis in the case of Node Ranking. Basically the key tool that you can use in Oracle Analytics is Data Flows . Graph Analytics step in Data Flows enables users to perform four graph analytics operations. Besides Node Ranking these are Sub Graph , Clusters and Shortest Path . For easier understanding and visualisation we are using the following Dolphins dataset. Sub Graph Sub Graph operations finds all nodes within specified number of hops of a given node . Using other words, Sub Graph finds all nodes, neighbours of a given node, if we specify the number of hops is one. If number of hops is two, Sub Graph returns all neighbouring nodes of a given node and all neighbours of found neighbours, and so on. This is for example useful in marketing when we can find who are friends of a customer who has bought a specific product. We might assume that customer presented that product to his friends and is also pos...