CHAPTER

31

SQL Server Graph Databases

In This Chapter

•   Graph Databases: A General Introduction

•   Creating Node Tables and Edge Tables

•   Querying Graph Data

•   Modifying and Editing Data in Graph Databases

•   Querying Graph Data Using Relational Queries

Microsoft introduced graph capabilities in SQL Server 2017. This new component is very important because most social networks are based on graphs and Transact-SQL statements do not support operations on graphs optimally.

The chapter discusses all extensions in SQL Server to support Graph Databases. The first section provides a general introduction to graph databases and then lists all properties of this component in SQL Server. The second section explains in detail the creation ...

Get Microsoft SQL Server 2019: A Beginner's Guide, Seventh Edition, 7th Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial