You can find the following definition of Graphs and Graph theory on WikiIn mathematics, graph theory is the study of graphs, which are mathematical structures used to model pairwise relations between objects. A graph in this context is made up of vertices (also called nodes or points) that are connected by edges (also called links or lines). A distinction is made between undirected graphs, where edges link two vertices symmetrically and directed graphs, where edges link two vertices asymmetrically. Graphs are one of the principal objects of study in discrete mathematics.

In essence, graphs are used to model various types of relationships. In the case of business analytics, graphs can be used in sales and marketing departments to perform recommendations of the products to a particular group of customers that are somehow related to some other group of customers, in manufacturing they can be exploited to manage inventory more effectively due to better planning of materials and semi-products based on relations in bills of material, or simply finding the shortest or the most economical path between two places in transportation. 

Oracle database supports working with graphs for several years now. It all started as an addition in Spatial Option and continued with dedicated graph server support in the database. With the latest addition, Graph Studio, working with graphs in the database has become extremely easy to work with. The working environment is easy to use and users, particularly business analysts, can simply log in and start using the tool instantly.

But we are not here to talk about Graph Studio (which I will hopefully present on some other occasion). This blog post is about graph support in Oracle Analytics. The first algorithms that enable users to work with graphs are available since Oracle Analytics 6.0.

In Oracle Analytics, Graph Analytics is available as one of the steps in a data flow. Currently, four functions are available:

  • Clustering finds connected components or clusters in a graph.

  • Node Ranking measures the importance of nodes in a graph.

  • Shortest Path calculates the shortest path between two nodes in a graph.

  • Sub Graph finds all nodes within a specified number of hops of a given node.

In the next blog posts, we will take a look at each of these in more detail. Stay tuned.

Become a member


Receive our newsletter to stay on top of the latest posts.



Ziga Vaupot


Ziga Vaupot