剧集

使用图形最短路径分解材料清单

在此演示中，我们将演示如何使用图形最短路径函数（SQL Server 2019 CTP3.1 引入）分解材料清单，以了解给定产品/部件所属的 BOM/程序集。此信息可用于报告或产品召回方案。我们将探索最短路径函数，并尝试了解可以使用它的不同方式。

详细信息：

SQL Server Graph 官方文档：https://learn.microsoft.com/sql/relational-databases/graphs/sql-graph-overview?view=sql-server-ver16和 https://learn.microsoft.com/sql/relational-databases/graphs/sql-graph-architecture https://blogs.technet.microsoft.com/dataplatforminsider/2017/04/20/graph-data-processing-with-sql-server-2017/
批量插入最佳做法： https://github.com/Microsoft/sql-server-samples/tree/master/samples/features/sql-graph
建议系统： https://blogs.msdn.microsoft.com/sqlcat/2017/04/21/build-a-recommendation-system-with-the-support-for-graph-data-in-sql-server-2017-and-azure-sql-db/
使用 SQL Graph 的 WideWorldImporters 中的产品推荐：https://github.com/Microsoft/sql-server-samples/tree/master/samples/demos/sql-graph/recommendation-system
边缘约束： https://blogs.msdn.microsoft.com/sqlserverstorageengine/2018/09/28/public-preview-of-graph-edge-constraints-on-sql-server-2019/
在图形匹配中使用派生表或视图： https://blogs.msdn.microsoft.com/sqlserverstorageengine/2018/11/07/public-preview-of-derived-tables-and-views-on-graph-tables-in-match-queries/https://github.com/microsoft/sql-server-samples/tree/master/samples/features/sql-graph/DerivedTablesAndViewsInGraphMatch
SHORTEST_PATH函数： https://techcommunity.microsoft.com/t5/SQL-Server/Public-Preview-of-Shortest-Path-on-SQL-Server-2019/ba-p/721240 https://github.com/microsoft/sql-server-samples/tree/master/samples/features/sql-graph/ShortestPath
高级图形算法： https://github.com/shkale-msft/GraphRecursiveQueries

详细信息：

SQL Server Graph 官方文档：https://learn.microsoft.com/sql/relational-databases/graphs/sql-graph-overview?view=sql-server-ver16和 https://learn.microsoft.com/sql/relational-databases/graphs/sql-graph-architecture https://blogs.technet.microsoft.com/dataplatforminsider/2017/04/20/graph-data-processing-with-sql-server-2017/
批量插入最佳做法： https://github.com/Microsoft/sql-server-samples/tree/master/samples/features/sql-graph
建议系统： https://blogs.msdn.microsoft.com/sqlcat/2017/04/21/build-a-recommendation-system-with-the-support-for-graph-data-in-sql-server-2017-and-azure-sql-db/
使用 SQL Graph 的 WideWorldImporters 中的产品推荐：https://github.com/Microsoft/sql-server-samples/tree/master/samples/demos/sql-graph/recommendation-system
边缘约束： https://blogs.msdn.microsoft.com/sqlserverstorageengine/2018/09/28/public-preview-of-graph-edge-constraints-on-sql-server-2019/
在图形匹配中使用派生表或视图： https://blogs.msdn.microsoft.com/sqlserverstorageengine/2018/11/07/public-preview-of-derived-tables-and-views-on-graph-tables-in-match-queries/https://github.com/microsoft/sql-server-samples/tree/master/samples/features/sql-graph/DerivedTablesAndViewsInGraphMatch
SHORTEST_PATH函数： https://techcommunity.microsoft.com/t5/SQL-Server/Public-Preview-of-Shortest-Path-on-SQL-Server-2019/ba-p/721240 https://github.com/microsoft/sql-server-samples/tree/master/samples/features/sql-graph/ShortestPath
高级图形算法： https://github.com/shkale-msft/GraphRecursiveQueries