For product manufacturers, it is crucial in B2B e-commerce settings to give customers more insight into your products. Especially if you have a complex product catalog, with long-lasting products such as industrial durable goods, which can be composed of other products, enabling business customers to find the right information within a few clicks is a key factor for customer satisfaction.
Graphs are a useful way to model the complex relationships and dependencies among many different products and parts. To illustrate this, we construct a graph in a multi-catalog environment to model which “Part of”-relationships can be found in bills of materials (BoMs). The type of item is included in the graph: whether they are wear- or spare-parts, or just regular products. We can also perform useful queries such as finding nested spare- or wear-parts, and how a certain product or part has been used. In this example, we use Oracle Database Graph features to store, model, and analyze the BoM data set. We will also show how we use PGQL, a natural and powerful query language, to easily perform various analyses on the graph structures. Here PGQL – the query language used in PGX – here shows its advantages for handling these structures.
Florian Siepe, Software Engineer, Viessmann IT Service
Florian is a software engineer at the Viessmann IT Service. After finishing his bachelor’s degree in 2021, he is currently pursuing his Master studies at the University of Marburg (Germany).
His professional areas currently include full-stack development in a B2B e-commerce setting, while focusing on Java-based technologies such as Spring Boot or Quarkus, as well as Angular on the client side. During his bachelor studies, he gained familiarity with NoSQL database solutions and graph analytics technologies such as PGX.