Session Title: SQL Graph: best practices for easily modelling & querying complex data models
Speaker(s): Arvind Shyamsundar
Abstract: Have you struggled with how to represent a “many-to-many” relationship in relational tables? Has your mind been strained in the process of writing a recursive CTE to query a hierarchy? Have you given up trying to implement core graph algorithms efficiently in T-SQL?
For all these cases, and more, SQL Graph provides an elegant way to model a graph (nodes and edges) built-in T-SQL support (MATCH / SHORTEST_PATH) to help with pattern matching and recursive path finding in such a graph. In this session we will use examples derived from real-world cases where SQL Graph has been used to ease development effort and enable new types of workloads on Azure SQL DB, Azure SQL Managed Instance, and SQL Server.
500+ sessions are now available on-demand from Data Platform Summit 2022, 2021 & 2020 at no cost. Browse all sessions.
Stay tuned, more learning coming your way.