SQL Server 2019 introduced the missing key feature for using graph databases features in a production environment; shortest path. The Shortest Path algorithm calculates the shortest (weighted) path between nodes. Define a starting node and navigate through relationships until the destination has been reached, retrieving all components along the way. In this session, I show how to explode a Bill of Materials (BOM) by using the shortest path algorithm. My customer are wholesale resellers, working actively with warehousing. They use Dynamics AX for warehouse transactions. We are often asked to go over the full BOM of specific items for reporting and cost management purposes.
I show you how to use the new feature for addressing these needs. I set up a complete graph databases environment in SQL Server 2019 from an AX environment, and show how to navigate through all components for every item, calculating costs, relationships between parts, level of iterations.