Practical Graph Structures in SQL Server and Azure SQL (eBook)
XVII, 238 Seiten
Apress (Verlag)
978-1-4842-9459-8 (ISBN)
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.
- 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
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).
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 LearnUnderstand the graph model and the associated terms used in graph analysisStore highly connected data in SQL Server and Azure SQL alongside existing relational dataMake full use of the graph table feature that is refined and enhanced in SQL Server 2019Implement high performance tree structures that will make storing and querying tree data possibleReport on data associated with a tree structure to aggregate results at different levelsWho This Book Is For
| Erscheint lt. Verlag | 16.5.2023 |
|---|---|
| Zusatzinfo | XVII, 238 p. 65 illus., 50 illus. in color. |
| Sprache | englisch |
| Themenwelt | Informatik ► Datenbanken ► SQL Server |
| Mathematik / Informatik ► Informatik ► Programmiersprachen / -werkzeuge | |
| Mathematik / Informatik ► Informatik ► Software Entwicklung | |
| Schlagworte | Acyclic Graphs • Cyclical Graphs • Directed acyclic graphs • Graph Database Structurest • Graph Data Modeling • Graphs • Kimball Helper Tables • Nested Sets • Social Graphs • SQL Graph • SQL Server • Transact-SQL • Trees and Hierarchies in SQL • T-SQL |
| ISBN-10 | 1-4842-9459-9 / 1484294599 |
| ISBN-13 | 978-1-4842-9459-8 / 9781484294598 |
| Haben Sie eine Frage zum Produkt? |
PDF (Wasserzeichen)Größe: 7,1 MB
DRM: Digitales Wasserzeichen
Dieses eBook enthält ein digitales Wasserzeichen und ist damit für Sie personalisiert. Bei einer missbräuchlichen Weitergabe des eBooks an Dritte ist eine Rückverfolgung an die Quelle möglich.
Dateiformat: PDF (Portable Document Format)
Mit einem festen Seitenlayout eignet sich die PDF besonders für Fachbücher mit Spalten, Tabellen und Abbildungen. Eine PDF kann auf fast allen Geräten angezeigt werden, ist aber für kleine Displays (Smartphone, eReader) nur eingeschränkt geeignet.
Systemvoraussetzungen:
PC/Mac: Mit einem PC oder Mac können Sie dieses eBook lesen. Sie benötigen dafür einen PDF-Viewer - z.B. den Adobe Reader oder Adobe Digital Editions.
eReader: Dieses eBook kann mit (fast) allen eBook-Readern gelesen werden. Mit dem amazon-Kindle ist es aber nicht kompatibel.
Smartphone/Tablet: Egal ob Apple oder Android, dieses eBook können Sie lesen. Sie benötigen dafür einen PDF-Viewer - z.B. die kostenlose Adobe Digital Editions-App.
Buying eBooks from abroad
For tax law reasons we can sell eBooks just within Germany and Switzerland. Regrettably we cannot fulfill eBook-orders from other countries.
aus dem Bereich
