SQL Server 2017 Graph Database [Stage]
SQL Server has always provided tools to manage hierarchies and relationships, facilitating query execution on hierarchical data, but sometimes relationships can become complex. Think about many-to-many relationships, relational databases don't have a native solution for many-to-many associations. A common approach to realize a many-to-many association is to introduce a table that holds such relationship. SQL Server 2017, thanks to the Graph Database, can express certain kinds of queries more easily than a relational database by transforming complex relationships into graphs. In this session, I will introduce what Graph Database is and which scenarios it solves easily. The last demo will show how to build a recommendation system for sales offers that is able to determine the recommended products based on the product the customer is purchasing.