Using SAP HANA Graph to map relationships between different SAP products
SAP HANA Graph expands the SAP HANA platform with native support for graph processing and allows executing typical graph operations on the data stored in an SAP HANA system. Graphs are powerful abstraction that can be used to model different kinds of networks and linked data coming from many areas, such as logistics and transportation, utility networks, knowledge representation, text processing, and more.
The idea is that we can represent the relationships between different SAP products, components, services, 3rd party products within a graph. It is possible to represent the products and their relationships, as vertices and edges respectively. Given that we are using a database for this, we can also store additional information against the graph data. The data can be stored as links, which allows storing useful information relevant to each component of the graph. These type of information can then help me remember/understand how different components interact with each other.
Examples of information that can be stored against a vertex/edge:
Why store data in a graph? What does a graph allows us to do?
- We can explore the data (graph) in a graphical way. By opening the graph in the SAP HANA Database explorer and viewing the graph workspace created in SAP HANA Cloud, see screenshot above.
- It is simple to add new information (products, relationships) to the graph.
- By mapping relationships and the capabilities of products in a graph, we can query it and ask questions like:
- How does Product X relates with Product Y? We can easily visualise this in the graph workspace.
- How can I integrate Product X with Product Y? Is it possible or not? This is possible by finding the shortest path between two vertices.