Home
%3CLINGO-SUB%20id%3D%22lingo-sub-784232%22%20slang%3D%22en-US%22%3ENew%20Data%20Exposed%20episode%3A%20Exploding%20Bill%20of%20Materials%20using%20Graph%20Shortest%20Path%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-784232%22%20slang%3D%22en-US%22%3E%3CP%3EIn%20this%20demo%2C%20we%20will%20show%20how%20you%20can%20explode%20a%20Bill%20of%20Materials%20using%20Graph%20Shortest%20Path%20function%2C%20introduced%20with%20SQL%20Server%202019%20CTP3.1%2C%20to%20find%20out%20which%20BOMs%2Fassemblies%20a%20given%20product%2Fpart%20belongs%20to.%20This%20information%20can%20be%20useful%20for%20reporting%20or%20product%20recall%20scenarios.%20We%20will%20explore%20the%20Shortest%20Path%20function%20and%20try%20to%20understand%20different%20ways%20in%20which%20it%20can%20be%20used.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CIFRAME%20src%3D%22https%3A%2F%2Fchannel9.msdn.com%2FShows%2FData-Exposed%2FExploding-Bill-of-Materials-using-Graph-Shortest-Path%2Fplayer%3FWT.mc_id%3Ddataexposed-c9-niner%22%20width%3D%22960%22%20height%3D%22540%22%20frameborder%3D%220%22%20allowfullscreen%3D%22allowfullscreen%22%20title%3D%22Exploding%20Bill%20of%20Materials%20using%20Graph%20Shortest%20Path%20-%20Microsoft%20Channel%209%20Video%22%3E%3C%2FIFRAME%3E%3C%2FP%3E%0A%3CP%3EMore%20information%3A%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3ESQL%20Server%20Graph%20official%20documentation%3A%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Frelational-databases%2Fgraphs%2Fsql-graph-overview%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Frelational-databases%2Fgraphs%2Fsql-graph-overview%3C%2FA%3E%2C%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Frelational-databases%2Fgraphs%2Fsql-graph-architecture%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Frelational-databases%2Fgraphs%2Fsql-graph-architecture%3C%2FA%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Eand%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fblogs.technet.microsoft.com%2Fdataplatforminsider%2F2017%2F04%2F20%2Fgraph-data-processing-with-sql-server-2017%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fblogs.technet.microsoft.com%2Fdataplatforminsider%2F2017%2F04%2F20%2Fgraph-data-processing-with-sql-server-2017%2F%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3EBulk%20Insert%20Best%20Practices%3A%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FMicrosoft%2Fsql-server-samples%2Ftree%2Fmaster%2Fsamples%2Ffeatures%2Fsql-graph%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fgithub.com%2FMicrosoft%2Fsql-server-samples%2Ftree%2Fmaster%2Fsamples%2Ffeatures%2Fsql-graph%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3ERecommendation%20System%3A%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fblogs.msdn.microsoft.com%2Fsqlcat%2F2017%2F04%2F21%2Fbuild-a-recommendation-system-with-the-support-for-graph-data-in-sql-server-2017-and-azure-sql-db%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fblogs.msdn.microsoft.com%2Fsqlcat%2F2017%2F04%2F21%2Fbuild-a-recommendation-system-with-the-support-for-graph-data-in-sql-server-2017-and-azure-sql-db%2F%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3EProduct%20Recommendations%20in%20WideWorldImporters%20using%20SQL%20Graph%3A%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FMicrosoft%2Fsql-server-samples%2Ftree%2Fmaster%2Fsamples%2Fdemos%2Fsql-graph%2Frecommendation-system%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fgithub.com%2FMicrosoft%2Fsql-server-samples%2Ftree%2Fmaster%2Fsamples%2Fdemos%2Fsql-graph%2Frecommendation-system%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3EEdge%20Constraints%3A%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fblogs.msdn.microsoft.com%2Fsqlserverstorageengine%2F2018%2F09%2F28%2Fpublic-preview-of-graph-edge-constraints-on-sql-server-2019%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fblogs.msdn.microsoft.com%2Fsqlserverstorageengine%2F2018%2F09%2F28%2Fpublic-preview-of-graph-edge-constraints-on-sql-server-2019%2F%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3EUsing%20Derived%20Tables%20or%20Views%20in%20graph%20match%3A%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fblogs.msdn.microsoft.com%2Fsqlserverstorageengine%2F2018%2F11%2F07%2Fpublic-preview-of-derived-tables-and-views-on-graph-tables-in-match-queries%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fblogs.msdn.microsoft.com%2Fsqlserverstorageengine%2F2018%2F11%2F07%2Fpublic-preview-of-derived-tables-and-views-on-graph-tables-in-match-queries%2F%3C%2FA%3E%2C%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fsql-server-samples%2Ftree%2Fmaster%2Fsamples%2Ffeatures%2Fsql-graph%2FDerivedTablesAndViewsInGraphMatch%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fgithub.com%2Fmicrosoft%2Fsql-server-samples%2Ftree%2Fmaster%2Fsamples%2Ffeatures%2Fsql-graph%2FDerivedTablesAndViewsInGraphMatch%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3ESHORTEST_PATH%20function%3A%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FSQL-Server%2FPublic-Preview-of-Shortest-Path-on-SQL-Server-2019%2Fba-p%2F721240%22%20target%3D%22_blank%22%20rel%3D%22noopener%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FSQL-Server%2FPublic-Preview-of-Shortest-Path-on-SQL-Server-2019%2Fba-p%2F721240%3C%2FA%3E%2C%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fsql-server-samples%2Ftree%2Fmaster%2Fsamples%2Ffeatures%2Fsql-graph%2FShortestPath%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fgithub.com%2Fmicrosoft%2Fsql-server-samples%2Ftree%2Fmaster%2Fsamples%2Ffeatures%2Fsql-graph%2FShortestPath%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3EAdvanced%20Graph%20Algorithms%3A%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fshkale-msft%2FGraphRecursiveQueries%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fgithub.com%2Fshkale-msft%2FGraphRecursiveQueries%3C%2FA%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3EFollow%20Shreya%20Verma%20and%20Jeroen%20ter%20Heerdt%20on%20Twitter%20at%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Ftwitter.com%2FShreyaVermaKale%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Ftwitter.com%2FShreyaVermaKale%3C%2FA%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Eand%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Ftwitter.com%2Fjeroenterheerdt%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Ftwitter.com%2Fjeroenterheerdt%3C%2FA%3E.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-784232%22%20slang%3D%22en-US%22%3E%3CP%3EIn%20this%20demo%2C%20we%20will%20show%20how%20you%20can%20explode%20a%20Bill%20of%20Materials%20using%20Graph%20Shortest%20Path%20function%2C%20introduced%20with%20SQL%20Server%202019%20CTP3.1%2C%20to%20find%20out%20which%20BOMs%2Fassemblies%20a%20given%20product%2Fpart%20belongs%20to.%20This%20information%20can%20be%20useful%20for%20reporting%20or%20product%20recall%20scenarios.%20We%20will%20explore%20the%20Shortest%20Path%20function%20and%20try%20to%20understand%20different%20ways%20in%20which%20it%20can%20be%20used.%3C%2FP%3E%0A%3CP%3EMore%20information%3A%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3ESQL%20Server%20Graph%20official%20documentation%3A%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Frelational-databases%2Fgraphs%2Fsql-graph-overview%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Frelational-databases%2Fgraphs%2Fsql-graph-overview%3C%2FA%3E%2C%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Frelational-databases%2Fgraphs%2Fsql-graph-architecture%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Frelational-databases%2Fgraphs%2Fsql-graph-architecture%3C%2FA%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Eand%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fblogs.technet.microsoft.com%2Fdataplatforminsider%2F2017%2F04%2F20%2Fgraph-data-processing-with-sql-server-2017%2F%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Fblogs.technet.microsoft.com%2Fdataplatforminsider%2F2017%2F04%2F20%2Fgraph-data-processing-with-sql-server-2017%2F%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3EBulk%20Insert%20Best%20Practices%3A%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FMicrosoft%2Fsql-server-samples%2Ftree%2Fmaster%2Fsamples%2Ffeatures%2Fsql-graph%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Fgithub.com%2FMicrosoft%2Fsql-server-samples%2Ftree%2Fmaster%2Fsamples%2Ffeatures%2Fsql-graph%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3ERecommendation%20System%3A%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fblogs.msdn.microsoft.com%2Fsqlcat%2F2017%2F04%2F21%2Fbuild-a-recommendation-system-with-the-support-for-graph-data-in-sql-server-2017-and-azure-sql-db%2F%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Fblogs.msdn.microsoft.com%2Fsqlcat%2F2017%2F04%2F21%2Fbuild-a-recommendation-system-with-the-support-for-graph-data-in-sql-server-2017-and-azure-sql-db%2F%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3EProduct%20Recommendations%20in%20WideWorldImporters%20using%20SQL%20Graph%3A%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FMicrosoft%2Fsql-server-samples%2Ftree%2Fmaster%2Fsamples%2Fdemos%2Fsql-graph%2Frecommendation-system%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Fgithub.com%2FMicrosoft%2Fsql-server-samples%2Ftree%2Fmaster%2Fsamples%2Fdemos%2Fsql-graph%2Frecommendation-system%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3EEdge%20Constraints%3A%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fblogs.msdn.microsoft.com%2Fsqlserverstorageengine%2F2018%2F09%2F28%2Fpublic-preview-of-graph-edge-constraints-on-sql-server-2019%2F%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Fblogs.msdn.microsoft.com%2Fsqlserverstorageengine%2F2018%2F09%2F28%2Fpublic-preview-of-graph-edge-constraints-on-sql-server-2019%2F%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3EUsing%20Derived%20Tables%20or%20Views%20in%20graph%20match%3A%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fblogs.msdn.microsoft.com%2Fsqlserverstorageengine%2F2018%2F11%2F07%2Fpublic-preview-of-derived-tables-and-views-on-graph-tables-in-match-queries%2F%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Fblogs.msdn.microsoft.com%2Fsqlserverstorageengine%2F2018%2F11%2F07%2Fpublic-preview-of-derived-tables-and-views-on-graph-tables-in-match-queries%2F%3C%2FA%3E%2C%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fsql-server-samples%2Ftree%2Fmaster%2Fsamples%2Ffeatures%2Fsql-graph%2FDerivedTablesAndViewsInGraphMatch%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Fgithub.com%2Fmicrosoft%2Fsql-server-samples%2Ftree%2Fmaster%2Fsamples%2Ffeatures%2Fsql-graph%2FDerivedTablesAndViewsInGraphMatch%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3ESHORTEST_PATH%20function%3A%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FSQL-Server%2FPublic-Preview-of-Shortest-Path-on-SQL-Server-2019%2Fba-p%2F721240%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FSQL-Server%2FPublic-Preview-of-Shortest-Path-on-SQL-Server-2019%2Fba-p%2F721240%3C%2FA%3E%2C%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fsql-server-samples%2Ftree%2Fmaster%2Fsamples%2Ffeatures%2Fsql-graph%2FShortestPath%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Fgithub.com%2Fmicrosoft%2Fsql-server-samples%2Ftree%2Fmaster%2Fsamples%2Ffeatures%2Fsql-graph%2FShortestPath%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3EAdvanced%20Graph%20Algorithms%3A%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fshkale-msft%2FGraphRecursiveQueries%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Fgithub.com%2Fshkale-msft%2FGraphRecursiveQueries%3C%2FA%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3EFollow%20Shreya%20Verma%20and%20Jeroen%20ter%20Heerdt%20on%20Twitter%20at%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Ftwitter.com%2FShreyaVermaKale%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftwitter.com%2FShreyaVermaKale%3C%2FA%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Eand%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Ftwitter.com%2Fjeroenterheerdt%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftwitter.com%2Fjeroenterheerdt%3C%2FA%3E.%3C%2FP%3E%3C%2FLINGO-TEASER%3E
Microsoft

In this demo, we will show how you can explode a Bill of Materials using Graph Shortest Path function, introduced with SQL Server 2019 CTP3.1, to find out which BOMs/assemblies a given product/part belongs to. This information can be useful for reporting or product recall scenarios. We will explore the Shortest Path function and try to understand different ways in which it can be used.

 

More information:

Follow Shreya Verma and Jeroen ter Heerdt on Twitter at https://twitter.com/ShreyaVermaKale and https://twitter.com/jeroenterheerdt.