國立高雄大學圖資館 |

Language: English

Back

Practical graph structures in SQL server and Azure SQLenabling deeper insights using highly connected data /

Record Type:	Electronic resources : Monograph/item
Title/Author:	Practical graph structures in SQL server and Azure SQLby Louis Davidson.
Reminder of title:	enabling deeper insights using highly connected data /
Author:	Davidson, Louis.
Published:	Berkeley, CA :Apress :2023.
Description:	1 online resource (xvii, 238 p.) :ill. (chiefly col.), digital ;24 cm.
Contained By:	Springer Nature eBook
Subject:	Graph databases.
Online resource:	https://doi.org/10.1007/978-1-4842-9459-8
ISBN:	9781484294598$q(electronic bk.)

Practical graph structures in SQL server and Azure SQLenabling deeper insights using highly connected data /
Davidson, Louis.

Practical graph structures in SQL server and Azure SQLenabling deeper insights using highly connected data /[electronic resource] :by Louis Davidson. - Berkeley, CA :Apress :2023. - 1 online resource (xvii, 238 p.) :ill. (chiefly col.), digital ;24 cm.

1. Introduction to Graphs -- 2. Data Structures and Algorithms -- 3. SQL Graph Tables 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.

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.

ISBN: 9781484294598$q(electronic bk.)

Standard No.: 10.1007/978-1-4842-9459-8doiSubjects--Uniform Titles:

SQL server.
Subjects--Topical Terms:

835026
Graph databases.

LC Class. No.: QA76.73.S67

Dewey Class. No.: 005.756

Practical graph structures in SQL server and Azure SQLenabling deeper insights using highly connected data /
LDR:03156nmm a2200325 a 4500 001 638277
003 DE-He213
005 20230516204203.0
006 m d
007 cr nn 008maaau
008 230921s2023 cau s 0 eng d
020 $a 9781484294598$q(electronic bk.)
020 $a 9781484294581$q(paper)
024 7 $a 10.1007/978-1-4842-9459-8 $2 doi
035 $a 978-1-4842-9459-8
040 $a GP $c GP
041 0 $a eng
050 4 $a QA76.73.S67
072 7 $a UMP $2 bicssc
072 7 $a COM051380 $2 bisacsh
072 7 $a UMP $2 thema
082 0 4 $a 005.756 $2 23
090 $a QA76.73.S67 $b D252 2023
100 1 $a Davidson, Louis. $3 262103
245 1 0 $a Practical graph structures in SQL server and Azure SQL $h [electronic resource] : $b enabling deeper insights using highly connected data / $c by Louis Davidson.
260 $a Berkeley, CA : $b Apress : $b Imprint: Apress, $c 2023.
300 $a 1 online resource (xvii, 238 p.) : $b ill. (chiefly col.), digital ; $c 24 cm.
505 0 $a 1. Introduction to Graphs -- 2. Data Structures and Algorithms -- 3. SQL Graph Tables 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.
520 $a 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.
630 0 0 $a SQL server. $3 199469
630 0 0 $a Microsoft Azure SQL Database. $3 727076
650 0 $a Graph databases. $3 835026
650 0 $a Database management. $3 182428
650 1 4 $a Microsoft. $3 915087
650 2 4 $a Database Management. $3 273994
650 2 4 $a Programming Techniques. $3 274470
710 2 $a SpringerLink (Online service) $3 273601
773 0 $t Springer Nature eBook
856 4 0 $u https://doi.org/10.1007/978-1-4842-9459-8
950 $a Professional and Applied Computing (SpringerNature-12059)