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

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.

If your job involves analyzing or storage of data elements that are connected in a networked topology, then this is the book that will help you bring the power of SQL Server to bear on that data and take advantage of your existing knowledge.

What You Will Learn

• Understand the graph model and the associated terms used in graph analysis
  
• Store highly connected data in SQL Server and Azure SQL alongside existing relational data
• Make full use of the graph table feature that is refined and enhanced in SQL Server 2019
• Implement high performance tree structures that will make storing and querying tree data possible
• Report on data associated with a tree structure to aggregate results at different levels
  

Who This Book Is For

本書介紹了在SQL Server 2017中引入並在SQL Server 2019中進一步改進的Azure SQL中的圖表功能。本書向您展示如何創建數據結構來捕捉數據中項目之間的複雜關聯。這些關聯將幫助您分析並從數據中獲得超越傳統關係的洞察力。

本書中的圖表示例對於分析社交媒體關係、複雜的產品與客戶關係以及任何其他類型的數據分析都很有用。通過使用傳統技術可能會錯過的間接關聯，可以從這些關聯中挖掘出洞察力和商業價值。

本書還介紹了樹狀結構，重點介紹了組織常用的一種結構，用於在組織的不同層級上聚合數據。本書提供了SQL Graph對象的代碼示例，以及一種替代的樹狀結構實現技術。還包括樣本數據（和數據生成器），供您測試性能並選擇最適合您和應用程序需求的實現方法。

如果您的工作涉及分析或存儲以網絡拓撲連接的數據元素，那麼本書將幫助您充分利用SQL Server的功能，並利用您現有的知識。

您將學到什麼：
- 理解圖表模型及其相關術語
- 在SQL Server和Azure SQL中將高度相關的數據存儲在現有的關聯數據旁邊
- 充分利用在SQL Server 2019中改進和增強的圖表功能
- 實現高性能的樹狀結構，實現樹狀數據的存儲和查詢
- 報告與樹狀結構相關的數據，以在不同層級上聚合結果

本書適合對象：
- 需要分析或存儲以網絡拓撲連接的數據元素的人士

Louis Davidson has been working with databases for more than 25 years as a corporate database developer and architect, and is now the editor for the Redgate Simple Talk website. He has been a Microsoft MVP for 18 years. In addition to this book on graphs, he has written six editions of his general-purpose SQL Server database design book (Apress).
Louis has been active in speaking about database design and implementation at many conferences over the past 25 years, including SQL PASS, SQL Rally, SQL Saturday events, CA World, Music City Data, and the devLink Technical Conference. He has a bachelor's degree in computer science from the University of Tennessee at Chattanooga. For more information, please visit his website at drsql.org.

Louis Davidson已經在企業數據庫開發和架構方面工作超過25年，現在是Redgate Simple Talk網站的編輯。他已經連續18年成為Microsoft MVP。除了這本關於圖形的書籍外，他還撰寫了六版他的通用SQL Server數據庫設計書（Apress）。Louis在過去25年中在許多會議上積極演講有關數據庫設計和實施，包括SQL PASS、SQL Rally、SQL Saturday活動、CA World、Music City Data和devLink Technical Conference。他擁有田納西州查塔努加大學的計算機科學學士學位。更多信息，請訪問他的網站drsql.org。