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%3C%2FP%3E%3CDIV%20class%3D%22video-embed-center%20video-embed%22%3E%3CIFRAME%20class%3D%22embedly-embed%22%20src%3D%22https%3A%2F%2Fcdn.embedly.com%2Fwidgets%2Fmedia.html%3Fsrc%3Dhttps%253A%252F%252Fwww.youtube.com%252Fembed%252F9F3Ls0IjPOA%253Ffeature%253Doembed%26amp%3Burl%3Dhttp%253A%252F%252Fwww.youtube.com%252Fwatch%253Fv%253D9F3Ls0IjPOA%26amp%3Bimage%3Dhttps%253A%252F%252Fi.ytimg.com%252Fvi%252F9F3Ls0IjPOA%252Fhqdefault.jpg%26amp%3Bkey%3Dfad07bfa4bd747d3bdea27e17b533c0e%26amp%3Btype%3Dtext%252Fhtml%26amp%3Bschema%3Dyoutube%22%20width%3D%22600%22%20height%3D%22337%22%20scrolling%3D%22no%22%20frameborder%3D%220%22%20allow%3D%22autoplay%3B%20fullscreen%22%20allowfullscreen%3D%22true%22%20title%3D%22Video%22%3E%3C%2FIFRAME%3E%3C%2FDIV%3E%3CP%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.