Practical Graph Structures in SQL Server and Azure SQL: Enabling Deeper Insights Using Highly Connected Data 1st Edition

Practical Graph Structures in SQL Server and Azure SQL: Enabling Deeper Insights Using Highly Connected Data 1st Edition – Ebook Instant Download/Delivery ISBN(s): 9781484294581,1484294580.,9781484294598, 1484294599

Product details:

• ISBN-10: 1484294599
• ISBN-13: 9781484294598
• Author: Louis Davidson

Use the graph table features in Azure SQL that were introduced in SQL Server 2017 and further refined in SQL Server 2019. This book shows you how to create data structures to capture complex connections between items in your data. These connections will help you analyze and draw insights from connections in your data that go beyond classic relationships. The graph examples in the book are useful for analyzing social media relationships, complex product-to-customer relationships, and any other type of data analysis in which indirect connections that otherwise might be missed using conventional techniques can be mined for their insight and business value. Tree structures are covered, with emphasis on a structure commonly used by organizations to aggregate data at different levels of an organization. The book provides code examples of SQL Graph objects as well as an alternate tree implementation technique. Included is sample data (and data generators) for you to test for performance and choose the implementation approach that best suits your needs and that of your application.

Table contents:

1. Introduction to Graphs
2. Data Structures and Algorithms
3. SQL Graph Table Basics
4. SQL Graph Tables: Extended Topics
5. Tree Data Structures
6. Tree Structures, Algorithms, and Performance
7. Other Directed Acyclic Graphs
8. A Graph For Testing

People also search:

azure sql graph

graph in sql server

azure sql graph database

sql server graph database tutorial

sql server graph database example