Free shipping on orders over $99
Practical Graph Structures in SQL Server and Azure SQL

Practical Graph Structures in SQL Server and Azure SQL

Enabling Deeper Insights Using Highly Connected Data

by Louis Davidson
Paperback
Publication Date: 31/05/2023

Share This Book:

  $116.75
or 4 easy payments of $29.19 with
afterpay
This item qualifies your order for FREE DELIVERY
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

ISBN:
9781484294581
9781484294581
Category:
Microsoft programming
Format:
Paperback
Publication Date:
31-05-2023
Language:
English
Publisher:
Apress L. P.
Country of origin:
United States
Dimensions (mm):
254x178mm
Weight:
0.49kg

This title is in stock with our Australian supplier and should arrive at our Sydney warehouse within 2 - 3 weeks of you placing an order.

Once received into our warehouse we will despatch it to you with a Shipping Notification which includes online tracking.

Please check the estimated delivery times below for your region, for after your order is despatched from our warehouse:

ACT Metro: 2 working days
NSW Metro: 2 working days
NSW Rural: 2-3 working days
NSW Remote: 2-5 working days
NT Metro: 3-6 working days
NT Remote: 4-10 working days
QLD Metro: 2-4 working days
QLD Rural: 2-5 working days
QLD Remote: 2-7 working days
SA Metro: 2-5 working days
SA Rural: 3-6 working days
SA Remote: 3-7 working days
TAS Metro: 3-6 working days
TAS Rural: 3-6 working days
VIC Metro: 2-3 working days
VIC Rural: 2-4 working days
VIC Remote: 2-5 working days
WA Metro: 3-6 working days
WA Rural: 4-8 working days
WA Remote: 4-12 working days

Reviews

Be the first to review Practical Graph Structures in SQL Server and Azure SQL.