Recently Viewed

New

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

No reviews yet Write a Review
RRP: £54.99
Booksplease Price: £50.80
Booksplease saves you

  Bookmarks: Included free with every order
  Delivery: We ship to over 200 countries from the UK
  Range: Millions of books available
  Reviews: Booksplease rated "Excellent" on Trustpilot

  FREE UK DELIVERY: When You Buy 3 or More Books - Use code: FREEUKDELIVERY in your cart!

SKU:
9781484294581
MPN:
9781484294581
Available from Booksplease!
Availability: Usually dispatched within 4 working days

Frequently Bought Together:

Total: Inc. VAT
Total: Ex. VAT

Description

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




About the Author
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.


Book Information
ISBN 9781484294581
Author Louis Davidson
Format Paperback
Page Count 238
Imprint APress
Publisher APress

Reviews

No reviews yet Write a Review

Booksplease  Reviews


J - United Kingdom

Fast and efficient way to choose and receive books

This is my second experience using Booksplease. Both orders dealt with very quickly and despatched. Now waiting for my next read to drop through the letterbox.

J - United Kingdom

T - United States

Will definitely use again!

Great experience and I have zero concerns. They communicated through the shipping process and if there was any hiccups in it, they let me know. Books arrived in perfect condition as well as being fairly priced. 10/10 recommend. I will definitely shop here again!

T - United States

R - Spain

The shipping was just superior

The shipping was just superior; not even one of the books was in contact with the shipping box -anywhere-, not even a corner or the bottom, so all the books arrived in perfect condition. The international shipping took around 2 weeks, so pretty great too.

R - Spain

J - United Kingdom

Found a hard to get book…

Finding a hard to get book on Booksplease and with it not being an over inflated price was great. Ordering was really easy with updates on despatch. The book was packaged well and in great condition. I will certainly use them again.

J - United Kingdom