{"id":51989,"date":"2022-08-05T16:54:30","date_gmt":"2022-08-05T16:54:30","guid":{"rendered":"https:\/\/dbtut.com\/?p=51989"},"modified":"2022-08-05T16:57:18","modified_gmt":"2022-08-05T16:57:18","slug":"sql-server-graph-database","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2022\/08\/05\/sql-server-graph-database\/","title":{"rendered":"SQL Server Graph Database"},"content":{"rendered":"

In today’s article we will examine the SQL Server Graph Database.<\/p>\n

I will try to explain the Graph database features, which provide complex and hierarchical relationship management, which started to be used with SQL Server 2017, in the article.<\/p>\n

We can say that Graph database is critical to show the complex hierarchical data we experience while working with relational database systems and NoSQL databases, to eliminate performance problems such as the number of relationship levels and database sizes.<\/p>\n

Where can we use a graphical database?<\/p>\n

Social networking<\/p>\n

Fraud detection<\/p>\n

Product recommendations<\/p>\n

IT Network analysis<\/p>\n

Social recommendations<\/p>\n

etc.<\/p>\n

The graphical database consists of two elements.<\/p>\n

Node: Represents entities within the graphical database. customer, employee vs.<\/p>\n

Edge: Represents the \u2013 Node \u2013 relationship between entities.<\/p>\n

After brief information about SQL Server Graph database, let’s perform a demo about its usage and consolidate our knowledge.<\/p>\n

Example scenario: Let’s describe Person, City, Team, Stat and the relationships between them.<\/p>\n

As a first step, let’s create a database named “DMCGraph” with the following code block in order to implement the scenario.<\/p>\n

USE master;\r\nGO\r\nDROP DATABASE IF EXISTS DMCGraph;\r\nGO\r\nCREATE DATABASE DMCGraph;\r\nGO<\/pre>\n
Let’s start creating the “Node” tables. First, let’s take action for users.<\/p>\n
USE DMCGraph;\r\nGO\r\nDROP TABLE IF EXISTS Users;\r\nGO\r\nCREATE TABLE Users (\r\nUserID INT IDENTITY PRIMARY KEY,\r\nUserName NVARCHAR(100) NOT NULL,\r\n) AS NODE;<\/pre>\n
Looking at the code block above, you can see that it’s like a classic table creation process. The only difference is that you specify a “Node” with the phrase “AS NODE” at the end of the table syntax.<\/p>\n
The Node named \u201cUsers\u201d consists of a UserID and Username information, we need to take care that there is a Primary key in the node. To check whether a table is a node or edge, we use the is_node and is_edge columns in the sys.tables system table.<\/p>\n
select name,is_node,is_edge from sys.tables<\/p>\n
<\/p>\n
In the picture above, we see that the table named users is a node. We have already stated that there is a node with \u201cAS NODE\u201d while defining it.<\/p>\n
Now we have a graph table named users and let’s enter data into it.<\/p>\n
insert into Users values
\n(‘Caglar’),(‘Baki’),(‘Contemporary’),(‘Musa’),(‘Sait’),(‘Burak’)<\/p>\n
Now let’s view the content of the node named users.<\/p>\n
select * from dbo.Users<\/p>\n
<\/p>\n
When you examine the picture above, you will see that there is a column other than the UserID and UserName that we defined. The data content here includes JSON data and the default sort value starts from 0.<\/p>\n
Similarly, let’s create Team, Stat and city nodes.<\/p>\n
For the team;<\/h4>\n
USE DMCGraph;\r\nGO\r\nDROP TABLE IF EXISTS Teams;\r\nGO\r\nCREATE TABLE Teams (\r\nTeamID INT IDENTITY PRIMARY KEY,\r\nTeamName NVARCHAR(100) NOT NULL,\r\n) AS NODE;\r\n\r\nINSERT INTO Teams (TeamName)\r\nVALUES\r\n(\u2018Galatasaray\u2019),(\u2018Fenerbah\u00e7e\u2019),(\u2018Be\u015fikta\u015f\u2019),(\u2018Trabzonspor\u2019),(\u2018Ba\u015fak\u015fehir\u2019)<\/pre>\n
For the state;<\/h4>\n
USE DMCGraph;\r\nGO\r\nDROP TABLE IF EXISTS Stat;\r\nGO\r\nCREATE TABLE Stat (\r\nStatID INT IDENTITY PRIMARY KEY,\r\nStatName NVARCHAR(100) NOT NULL,\r\n) AS NODE;\r\n\r\nINSERT INTO Stat (StatName)\r\nVALUES\r\n(\u2018T\u00fcrk Telekom Arena\u2019),(\u2018\u015e\u00fckr\u00fcsara\u00e7o\u011flu\u2019),(\u2018Vodafone Arena\u2019),(\u2018Avni Aker Stad\u0131\u2019),(\u2018Fatih Terim Stad\u0131\u2019)<\/pre>\n
For the city;<\/h4>\n
USE DMCGraph;\r\nGO\r\nDROP TABLE IF EXISTS Cities;\r\nGO\r\nCREATE TABLE Cities (\r\nCityID INT IDENTITY PRIMARY KEY,\r\nCityName NVARCHAR(100) NOT NULL,\r\n) AS NODE;\r\n\r\nINSERT INTO Cities (CityName)\r\nVALUES\r\n(\u2018\u0130stanbul\u2019),(\u2018Trabzon\u2019)<\/pre>\n
We have created the node we will need for the graph database. Now it’s time to create an edge.<\/p>\n
Let’s create an edge named FavoriteTeam, WhichCityTeam and TeamsInStad.<\/p>\n
DROP TABLE IF EXISTS RetainedTeam;\r\nGO\r\nCREATE TABLE RetainedTeam AS EDGE;\r\n\r\nDROP TABLE IF EXISTS WhichCityTeam;\r\nGO\r\nCREATE TABLE WhichCityTeam AS EDGE;\r\n\r\nDROP TABLE IF EXISTS TeamsStad;\r\nGO\r\nCREATE TABLE TeamsStad AS EDGE;<\/pre>\n
After running the above code block, let’s check is_node and is_edge over sys.tables.<\/p>\n
<\/p>\n
We made the definitions as seen in the picture above. Now it’s time to insert insert on Edge. Edge is used to describe the relationship between two or more nodes.<\/p>\n
Assuming that a user is holding a tool, let’s insert the edge named Team Retained. But before we do this, let’s view the HeldTeam edge.<\/p>\n
select * from RetainedTeam<\/p>\n
<\/p>\n
 <\/p>\n
As seen in the picture above, there are 3 columns on the edge. When we look at the column nomenclature, it actually has a structure that tells us the relationship between nodes.<\/p>\n
Let’s take action for users number 1. (I associated user #1 with team #1.)<\/p>\n
insert into retainedteam($from_id, $to_id)\r\nvalues\r\n((SELECT $node_id FROM Users WHERE UserID = 1),\r\n(SELECT $node_id FROM Teams WHERE TeamID = 1));<\/pre>\n
Let’s perform the operation again for users number 1. (I associated user #1 with team #4.)<\/p>\n
insert into retainedteam($from_id, $to_id)\r\nvalues\r\n((SELECT $node_id FROM Users WHERE UserID = 1),\r\n(SELECT $node_id FROM Teams WHERE TeamID = 4));<\/pre>\n
Let’s perform the operation again for users number 2. (I associated user #2 with team #3.)<\/p>\n
insert into retainedteam($from_id, $to_id)\r\nvalues\r\n((SELECT $node_id FROM Users WHERE UserID = 2),\r\n(SELECT $node_id FROM Teams WHERE TeamID = 3));<\/pre>\n
Let’s perform the operation again for users number 3. (I associated user #3 with team #1.)<\/p>\n
insert into retainedteam($from_id, $to_id)\r\nvalues\r\n((SELECT $node_id FROM Users WHERE UserID = 3),\r\n(SELECT $node_id FROM Teams WHERE TeamID = 1));<\/pre>\n
Let’s add a record for whichCityTeam.<\/p>\n
I added team number 1 for city number 1.<\/p>\n
insert into whichCityTeam($from_id, $to_id)\r\nvalues\r\n((SELECT $node_id FROM Teams WHERE TeamId = 1),\r\n(SELECT $node_id FROM Cities WHERE CityId = 1))<\/pre>\n
I added team number 4 for city number 2.<\/p>\n
insert into whichCityTeam($from_id, $to_id)\r\nvalues\r\n((SELECT $node_id FROM Teams WHERE TeamId = 4),\r\n(SELECT $node_id FROM Cities WHERE CityId = 2))<\/pre>\n
I added team number 3 for city number 1.<\/p>\n
insert into whichCityTeam($from_id, $to_id)\r\nvalues\r\n((SELECT $node_id FROM Teams WHERE TeamId = 3),\r\n(SELECT $node_id FROM Cities WHERE CityId = 1))<\/pre>\n
Let’s add a record for TeamsStadium.<\/p>\n
I matched the number 1 team with the number 1 stat.<\/p>\n
insert into TeamsStadium($from_id, $to_id)\r\nvalues\r\n((SELECT $node_id FROM Teams WHERE TeamId = 1),\r\n(SELECT $node_id FROM Stat WHERE StatId = 1))\r\n\r\n<\/pre>\n
I matched team number 2 with stat number 2.<\/p>\n
insert into TeamsStadium($from_id, $to_id)\r\nvalues\r\n((SELECT $node_id FROM Teams WHERE TeamId = 2),\r\n(SELECT $node_id FROM Stat WHERE StatId = 2))<\/pre>\n
I matched team #3 with stat #3.<\/p>\n
insert into TeamsStadium($from_id, $to_id)\r\nvalues\r\n((SELECT $node_id FROM Teams WHERE TeamId = 3),\r\n(SELECT $node_id FROM Stat WHERE StatId = 3))<\/pre>\n
To view the data;<\/p>\n
In the select statement, you must specify the match statement in the where condition. For example, you need to use the following query to display the teams held by Users.<\/p>\n
SELECT u.UserName,  t.TeamName\r\nFROM Users u, retainedteam tt, Teams t\r\nWHERE MATCH(u-(tt)->t);<\/pre>\n
In the above example, as the users node, I named the Retained Team edge as tt and the teams node as t. The output is as follows.<\/p>\n
\"\"<\/p>\n
Similarly, as a different example, we can use the following query to get the answer to the question Which City hosts which team.<\/p>\n
select t.TeamName,c.CityName\r\nfrom\r\nTeams as t,\r\nwhichCityTeam as hst,Cities as c\r\nWHERE MATCH(t-(hst)->c);<\/pre>\n
<\/p>\n
I used t for Teams node, hst for WhichCityTeam, c for Cities and made it match with match.<\/p>\n
If we want to write the query that includes the teams of the users and the cities of the teams;<\/p>\n
select u.UserName,  t.TeamName,C.CityName\r\nfrom\r\nUsers as u,\r\nTeams as t,\r\nCities as c,\r\nTutulanTakim as tt,\r\nHangiSehirTakimi as hst\r\nwhere\r\n1=1\r\nand Match(u-(tt)->t)\r\nand Match(t-(hst)->c)<\/pre>\n
<\/p>\n
For Deletion of Data;<\/p>\n
To perform a Delete operation on Edge, you need to specify the values of $from_id and $to_id.<\/p>\n
delete from retainedteam\r\nwhere\r\n1=1\r\nand $from_id = (select $node_id from users where UserId = 1 )\r\nand $to_id = (select $node_id from Teams where TeamId =4  )<\/pre>\n
When you run the query of the Picture above again, you will not see the Trabzonspor information.<\/p>\n
Graph databases are changing the way many operations from complex operations are implemented.<\/p>\n
In this article, we briefly reviewed how to create nodes and edges in graph databases.<\/p>\n
We also saw how to implement relationships between different nodes and how to add, read, and delete edges.<\/p>\n
 <\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"excerpt":{"rendered":"
In today’s article we will examine the SQL Server Graph Database. I will try to explain the Graph database features, which provide complex and hierarchical relationship management, which started to be used with SQL Server 2017, in the article. We can say that Graph database is critical to show the complex hierarchical data we experience …<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"author":1414,"featured_media":51997,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[3],"tags":[],"class_list":["post-51989","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-mssql"],"aioseo_notices":[],"yoast_head":"\nSQL Server Graph Database - Database Tutorials<\/title>\n<meta name=\"description\" content=\"In today's article we will examine the SQL Server Graph Database.I will try to explain the Graph database features\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2022\/08\/05\/sql-server-graph-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server Graph Database - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"In today's article we will examine the SQL Server Graph Database.I will try to explain the Graph database features\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2022\/08\/05\/sql-server-graph-database\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2022-08-05T16:54:30+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-08-05T16:57:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/08\/Ekran-goruntusu-2022-08-05-195331.png\" \/>\n\t<meta property=\"og:image:width\" content=\"755\" \/>\n\t<meta property=\"og:image:height\" content=\"393\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"\u00c7a\u011flar \u00d6zen\u00e7\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u00c7a\u011flar \u00d6zen\u00e7\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/08\/05\/sql-server-graph-database\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/08\/05\/sql-server-graph-database\/\"},\"author\":{\"name\":\"\u00c7a\u011flar \u00d6zen\u00e7\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/92baa6fd666fb707d903177fed07d6ab\"},\"headline\":\"SQL Server Graph Database\",\"datePublished\":\"2022-08-05T16:54:30+00:00\",\"dateModified\":\"2022-08-05T16:57:18+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/08\/05\/sql-server-graph-database\/\"},\"wordCount\":854,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/08\/05\/sql-server-graph-database\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/08\/Ekran-goruntusu-2022-08-05-195331.png\",\"articleSection\":[\"MSSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2022\/08\/05\/sql-server-graph-database\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/08\/05\/sql-server-graph-database\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2022\/08\/05\/sql-server-graph-database\/\",\"name\":\"SQL Server Graph Database - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/08\/05\/sql-server-graph-database\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/08\/05\/sql-server-graph-database\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/08\/Ekran-goruntusu-2022-08-05-195331.png\",\"datePublished\":\"2022-08-05T16:54:30+00:00\",\"dateModified\":\"2022-08-05T16:57:18+00:00\",\"description\":\"In today's article we will examine the SQL Server Graph Database.I will try to explain the Graph database features\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/08\/05\/sql-server-graph-database\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2022\/08\/05\/sql-server-graph-database\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/08\/05\/sql-server-graph-database\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/08\/Ekran-goruntusu-2022-08-05-195331.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/08\/Ekran-goruntusu-2022-08-05-195331.png\",\"width\":755,\"height\":393},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/08\/05\/sql-server-graph-database\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server Graph Database\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/92baa6fd666fb707d903177fed07d6ab\",\"name\":\"\u00c7a\u011flar \u00d6zen\u00e7\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/997658bc236de4f5a0f3f46e64535566e31ba96824c77c01165e863fc38fd1ba?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/997658bc236de4f5a0f3f46e64535566e31ba96824c77c01165e863fc38fd1ba?s=96&d=mm&r=g\",\"caption\":\"\u00c7a\u011flar \u00d6zen\u00e7\"},\"url\":\"https:\/\/dbtut.com\/index.php\/author\/caglarozenc\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Server Graph Database - Database Tutorials","description":"In today's article we will examine the SQL Server Graph Database.I will try to explain the Graph database features","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/dbtut.com\/index.php\/2022\/08\/05\/sql-server-graph-database\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server Graph Database - Database Tutorials","og_description":"In today's article we will examine the SQL Server Graph Database.I will try to explain the Graph database features","og_url":"https:\/\/dbtut.com\/index.php\/2022\/08\/05\/sql-server-graph-database\/","og_site_name":"Database Tutorials","article_published_time":"2022-08-05T16:54:30+00:00","article_modified_time":"2022-08-05T16:57:18+00:00","og_image":[{"width":755,"height":393,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/08\/Ekran-goruntusu-2022-08-05-195331.png","type":"image\/png"}],"author":"\u00c7a\u011flar \u00d6zen\u00e7","twitter_card":"summary_large_image","twitter_misc":{"Written by":"\u00c7a\u011flar \u00d6zen\u00e7","Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2022\/08\/05\/sql-server-graph-database\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/08\/05\/sql-server-graph-database\/"},"author":{"name":"\u00c7a\u011flar \u00d6zen\u00e7","@id":"https:\/\/dbtut.com\/#\/schema\/person\/92baa6fd666fb707d903177fed07d6ab"},"headline":"SQL Server Graph Database","datePublished":"2022-08-05T16:54:30+00:00","dateModified":"2022-08-05T16:57:18+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/08\/05\/sql-server-graph-database\/"},"wordCount":854,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/08\/05\/sql-server-graph-database\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/08\/Ekran-goruntusu-2022-08-05-195331.png","articleSection":["MSSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2022\/08\/05\/sql-server-graph-database\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2022\/08\/05\/sql-server-graph-database\/","url":"https:\/\/dbtut.com\/index.php\/2022\/08\/05\/sql-server-graph-database\/","name":"SQL Server Graph Database - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/08\/05\/sql-server-graph-database\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/08\/05\/sql-server-graph-database\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/08\/Ekran-goruntusu-2022-08-05-195331.png","datePublished":"2022-08-05T16:54:30+00:00","dateModified":"2022-08-05T16:57:18+00:00","description":"In today's article we will examine the SQL Server Graph Database.I will try to explain the Graph database features","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/08\/05\/sql-server-graph-database\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2022\/08\/05\/sql-server-graph-database\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2022\/08\/05\/sql-server-graph-database\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/08\/Ekran-goruntusu-2022-08-05-195331.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/08\/Ekran-goruntusu-2022-08-05-195331.png","width":755,"height":393},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2022\/08\/05\/sql-server-graph-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"SQL Server Graph Database"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/92baa6fd666fb707d903177fed07d6ab","name":"\u00c7a\u011flar \u00d6zen\u00e7","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/997658bc236de4f5a0f3f46e64535566e31ba96824c77c01165e863fc38fd1ba?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/997658bc236de4f5a0f3f46e64535566e31ba96824c77c01165e863fc38fd1ba?s=96&d=mm&r=g","caption":"\u00c7a\u011flar \u00d6zen\u00e7"},"url":"https:\/\/dbtut.com\/index.php\/author\/caglarozenc\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/51989","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/1414"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=51989"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/51989\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/51997"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=51989"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=51989"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=51989"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}