Enhancing Relational Models with Graph processing in SQL Server 2017

Session Details: Analyzing highly connected data using SQL is hard! Relational databases were simply not designed to handle this, but graph databases were. Built from the ground up to understand interconnectivity, graph databases enable a flexible performant way to analyze relationships, and one has just landed in SQL Server 2017! SQL Server supports two new table types NODE and EDGE and a new function MATCH, which enables deeper exploration of the relationships in your data than ever before. In this session, we seek to explore, what is a graph database, why you should be interested, what query patterns do they solve and how does SQL Server compare with competitors. We will explore each of these based on real data shredded from IMDB. Speaker Details: Terry McCann is a Data Science & Advanced Analytics Consultant for Adatis Consulting Limited, a Microsoft Data & Analytics consultancy in the UK. Data Science Master's student, organizer of the Data Science Exeter user group, a frequent speaker at SQL Saturdays in the UK and Europe. Previous co-organiser of SQLSaturday Exeter. http://blogs.adatis.co.uk/terrymccann/