{"id":14331,"date":"2019-12-23T12:04:19","date_gmt":"2019-12-23T12:04:19","guid":{"rendered":"https:\/\/dbtut.com\/?p=14331"},"modified":"2019-12-23T12:17:59","modified_gmt":"2019-12-23T12:17:59","slug":"sql-server-2017-graphdb","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2019\/12\/23\/sql-server-2017-graphdb\/","title":{"rendered":"SQL Server 2017 GraphDB"},"content":{"rendered":"

What is GraphDB?<\/h2>\n

GraphDB introduced in SQL Server 2017. We will examine GraphDB with examples in this article. At the end of the article, we will learn the architecture of GraphDB and how to query. In our article, we will also design a Normal table to address the difference between Relational DB and GraphDB.<\/p>\n

GraphDB consists of Node and Edge tables. A Node represents an entity. This can be a person or organization. An Edge indicates the relationship between the two nodes to which it is connected. You can create Node and Edge tables under any Schema in the database, but they all belong to a logical graph.<\/p>\n

Example<\/h2>\n

SQL Server Relational Database Example<\/h3>\n

In this example, we will see how the relational database query works and create three tables for it.<\/p>\n

Our Tables: Personel, WorksIn ve Company<\/p>\n

After creating these tables, we will insert our demo data into our tables and prepare related queries.<\/p>\n

Let’s create our Demo database.<\/p>\n

Create Database<\/h4>\n
Create Database SQLTurkiye_GraphDB\nGo<\/pre>\n
Create Demo Tables<\/h4>\n
USE [SQLTurkiye_GraphDB]\nGO\n\nCREATE TABLE [dbo].[Personel](\n [Personel_id] [int] NOT NULL,\n [Name] [nvarchar](75) NULL,\n [Gender] [nvarchar](6) NULL,\nPRIMARY KEY CLUSTERED \n(\n [Personel_id] ASC\n)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]\n) ON [PRIMARY]\nGO\n\nCREATE TABLE [dbo].[WorksIn](\n [Personel_id] [int] NULL,\n [Cmp_ID] [int] NULL,\n [Since] [int] NULL\n) ON [PRIMARY]\nGO\n\nCREATE TABLE [dbo].[Company](\n [cmp_ID] [int] NULL,\n [cmpName] [varchar](100) NULL\n) ON [PRIMARY]\nGO<\/pre>\n
Insert Records into Tables<\/h4>\n
Insert data into created tables.<\/p>\n
INSERT INTO Personel VALUES (1,'Yusuf Kahveci','Male');\nINSERT INTO Personel VALUES (2,'Yasar Kahveci','Male');\nINSERT INTO Personel VALUES (3,'Julia Mertz Shand','Female');\nINSERT INTO Personel VALUES (4,'March Hons','Male');\nINSERT INTO Personel VALUES (5,'Lady Mish','Female');\nINSERT INTO Personel VALUES (6,'Elizabeth Tork','Female');\n\nINSERT INTO Company VALUES (1,'SQL Turkiye')\nINSERT INTO Company VALUES (2,'noSQLturkiye')\nINSERT INTO Company VALUES (3,'dataplatform services')\nINSERT INTO Company VALUES (4,'Orange Performance')\n\nINSERT INTO WorksIn  VALUES(1,1,2015)\nINSERT INTO WorksIn  VALUES(2,2,2014)\nINSERT INTO WorksIn  VALUES(3,3,2016)\nINSERT INTO WorksIn  VALUES(4,3,2016)\nINSERT INTO WorksIn  VALUES(5,3,2014)\nINSERT INTO WorksIn  VALUES(6,4,2014)<\/pre>\n
You can see the columns we relate the tables in the graph below.<\/p>\n
\"\"<\/p>\n
As you can see, we can access the WorksIn table by using Personel_id in the Personel table by matching it with Personel_id in WorksIn.<\/p>\n
Then we can access the Company table by using Cmp_Id in WorksIn table by matching it with the cmp_ID in Company table.<\/p>\n
The query should be as follows;<\/p>\n
SELECT p.[Name] FROM Personel p \nINNER JOIN WorksIn w ON p.Personel_id=w.Personel_id\nINNER JOIN Company c ON w.Cmp_ID=c.Cmp_ID\nWHERE c.cmpName='SQL Turkiye'<\/pre>\n
\"\"<\/p>\n
In the query above, we accessed the data using Foreign Keys to find employees in the company. In this example we have reached this result with 3 tables and 3 FK, but as the complexity increases, we will be able to access the result using more tables and more FK. The structure will grow and the effort will increase.<\/p>\n
Do not forget the above example and let’s analyze the same process in the GraphDB model using Nodes and Edges.<\/p>\n
SQL Server GraphDB Example<\/h3>\n
Create Nodes and Edges Tables<\/h4>\n
CREATE TABLE [dbo].[Company_Node](\n [ID] [int] NOT NULL,\n [name] [varchar](100) NULL,\n [sector] [varchar](100) NULL,\n [city] [varchar](100) NULL\n)\nAS NODE;\n\nCREATE TABLE [dbo].[Personel_Node](\n [ID] [int] NOT NULL,\n [name] [varchar](100) NULL,\n [Gender] [char](10) NULL\n ) As Node;\n\n\n CREATE TABLE [dbo].[City_Node](\n [ID] [int] NOT NULL,\n [name] [varchar](100) NULL,\n [stateName] [varchar](100) NULL\n ) As Node;\n\nCREATE TABLE [WorksIn_Edge] ([year] [int] )AS EDGE\nCREATE TABLE  LocatedIn_Edge as edge;\nCREATE TABLE  LivesIn_Edge as edge;<\/pre>\n
Now insert data into the Node tables. Adding data to Node tables is not different than adding data to normal tables.<\/p>\n
INSERT INTO [Personel_Node] VALUES (1,'Yusuf Kahveci','Male');\nINSERT INTO [Personel_Node] VALUES (2,'Yasar Kahveci','Male');\nINSERT INTO [Personel_Node] VALUES (3,'Taj Shand','Male');\nINSERT INTO [Personel_Node] VALUES (4,'Archer Lamble','Male');\nINSERT INTO [Personel_Node] VALUES (5,'Piper Koch','FeMale');\nINSERT INTO [Personel_Node] VALUES (6,'Katie Darwin','FeMale');\n\nINSERT INTO [Company_Node] VALUES (1,'SQL Turkiye','IT','Istanbul');\nINSERT INTO [Company_Node] VALUES (2,'noSQLturkiye','IT','Istanbul');\nINSERT INTO [Company_Node] VALUES (3,'Fabrikam Land','Pharma','Jonesbough');\nINSERT INTO [Company_Node] VALUES (4,'Nod Publishers', 'IT','Jonesbough');\n\nINSERT INTO [City_Node] VALUES (1,'Istanbul','Atasehir');\nINSERT INTO [City_Node] VALUES (2,'Istanbul','Atasehir');\nINSERT INTO [City_Node] VALUES (3,'Jonesbough','Lancing');\nINSERT INTO [City_Node] VALUES (4,'Abbeville','Lancing');\nINSERT INTO [City_Node] VALUES (5,'Zortman','Wyoming');\nINSERT INTO [City_Node] VALUES (6,'Zortman','Wyoming');<\/pre>\n
To add data to the Edge table, we must provide values for $from_id and $to_id columns from both Nodes.<\/p>\n
INSERT INTO [WorksIn_Edge]  VALUES ((SELECT $node_id FROM [Personel_Node] WHERE ID = 1), \n       (SELECT $node_id FROM [Company_Node] WHERE ID = 1),2015);\nINSERT INTO [WorksIn_Edge] VALUES ((SELECT $node_id FROM [Personel_Node] WHERE ID = 2), \n      (SELECT $node_id FROM [Company_Node] WHERE ID = 2),2014);\nINSERT INTO [WorksIn_Edge] VALUES ((SELECT $node_id FROM [Personel_Node] WHERE ID = 3), \n      (SELECT $node_id FROM [Company_Node] WHERE ID = 3),2015);\nINSERT INTO [WorksIn_Edge] VALUES ((SELECT $node_id FROM [Personel_Node] WHERE ID = 4), \n      (SELECT $node_id FROM [Company_Node] WHERE ID = 3),2016);\nINSERT INTO [WorksIn_Edge] VALUES ((SELECT $node_id FROM [Personel_Node] WHERE ID = 5), \n      (SELECT $node_id FROM [Company_Node] WHERE ID = 3),2014);\n   INSERT INTO [WorksIn_Edge] VALUES ((SELECT $node_id FROM [Personel_Node] WHERE ID = 6), \n      (SELECT $node_id FROM [Company_Node] WHERE ID = 4),2014);\n\nInsert into LocatedIn_Edge values ((select $node_id FROM [Company_Node] WHERE ID = 1),\n(select $node_id FROM  [City_Node] where ID=2))\n\nInsert into LocatedIn_Edge values ((select $node_id FROM [Company_Node] WHERE ID = 2),\n(select $node_id FROM  [City_Node] where ID=1))\n\nInsert into LocatedIn_Edge values ((select $node_id FROM [Company_Node] WHERE ID = 3),\n(select $node_id FROM  [City_Node] where ID=3))\n\nInsert into LocatedIn_Edge values ((select $node_id FROM [Company_Node] WHERE ID = 4),\n(select $node_id FROM  [City_Node] where ID=2))\n\nInsert into LivesIn_Edge values ((select $node_id FROM [City_Node] WHERE ID = 1),\n(select $node_id FROM  [City_Node] where ID=6))\n\nInsert into LivesIn_Edge values ((select $node_id FROM [City_Node] WHERE ID = 2),\n(select $node_id FROM  [City_Node] where ID=5))\n\nInsert into LivesIn_Edge values ((select $node_id FROM [City_Node] WHERE ID = 3),\n(select $node_id FROM  [City_Node] where ID=4))\n\nInsert into LivesIn_Edge values ((select $node_id FROM [City_Node] WHERE ID = 4),\n(select $node_id FROM  [City_Node] where ID=2))\n\nInsert into LivesIn_Edge values ((select $node_id FROM [City_Node] WHERE ID = 5),\n(select $node_id FROM  [City_Node] where ID=3))\n\nInsert into LivesIn_Edge values ((select $node_id FROM [City_Node] WHERE ID = 6),\n(select $node_id FROM  [City_Node] where ID=1))<\/pre>\n
After insert, SELECT From Nodes;<\/p>\n
SELECT * FROM [Personel_Node]\n\nSELECT * FROM [Company_Node]\n\nSELECT * FROM [City_Node]<\/pre>\n
\"\"<\/p>\n
Select From Edge Tables;<\/p>\n
\"\"<\/p>\n
Now we need to write CQL and EXEC to get results from Graph. Our example is to get the names of employees working in a specific company. Accordingly, our CQL is;<\/p>\n
SELECT PN.name FROM [Personel_Node] PN, [WorksIn_Edge], [Company_Node] CN\nWHERE MATCH(PN-(WorksIn_Edge)->CN)\nAND CN.name='SQL Turkiye';<\/pre>\n
\"\"<\/p>\n
As seen in the graph above, we see that the query will need 1 index search.<\/p>\n
Now let’s work with different examples,<\/p>\n
SELECT CN.name FROM [Personel_Node] PN, [WorksIn_Edge], [Company_Node] CN\nWHERE MATCH(PN-(WorksIn_Edge)->CN)\nAND PN.name='Yusuf Kahveci';<\/pre>\n
\"\"<\/p>\n
select Personel_Node.name ,Company_Node.name\nFrom [Personel_Node] ,[WorksIn_Edge], [Company_Node] ,LocatedIn_Edge,[City_Node] \nwhere MATCH(Personel_Node-(WorksIn_Edge)->Company_Node and Company_Node-(LocatedIn_Edge)->City_Node )\nand WorksIn_Edge.year='2014' and Company_Node.name='Fabrikam Land'<\/pre>\n
\"\"<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"excerpt":{"rendered":"
What is GraphDB? GraphDB introduced in SQL Server 2017. We will examine GraphDB with examples in this article. At the end of the article, we will learn the architecture of GraphDB and how to query. In our article, we will also design a Normal table to address the difference between Relational DB and GraphDB. GraphDB …<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"author":483,"featured_media":14342,"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":[6914,6916,6918,6917,6905,6906,6908,6909,6903,6904,6912,6907,6915,6913,6911,6910],"class_list":["post-14331","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-mssql","tag-an-introduction-to-a-sql-server-2017-graph-database","tag-graph-database-sql-server","tag-graph-database-sql-server-2017","tag-graph-database-sql-server-example","tag-graph-db-in-sql-server","tag-graph-db-sql-server","tag-graph-sql","tag-graph-sql-database","tag-graphdb-in-sql-server","tag-graphdb-in-sql-server-2017","tag-sql-server-2017-graph-database-example","tag-sql-server-graph-database-example","tag-sql-server-graph-databases","tag-understanding-graph-databases-in-sql-server","tag-what-is-graph-db-in-sql-server","tag-what-is-graphdb-in-sql-server"],"aioseo_notices":[],"a3_pvc":{"activated":true,"total_views":255,"today_views":0},"yoast_head":"\nSQL Server 2017 GraphDB - Database Tutorials<\/title>\n<meta name=\"description\" content=\"SQL Server 2017 GraphDB\" \/>\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\/2019\/12\/23\/sql-server-2017-graphdb\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server 2017 GraphDB - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"SQL Server 2017 GraphDB\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2019\/12\/23\/sql-server-2017-graphdb\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-12-23T12:04:19+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-12-23T12:17:59+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-15.png\" \/>\n\t<meta property=\"og:image:width\" content=\"568\" \/>\n\t<meta property=\"og:image:height\" content=\"362\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Yusuf KAHVEC\u0130\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Yusuf KAHVEC\u0130\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/23\/sql-server-2017-graphdb\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/23\/sql-server-2017-graphdb\/\"},\"author\":{\"name\":\"Yusuf KAHVEC\u0130\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/695ad69b2bd896864842ba8772930150\"},\"headline\":\"SQL Server 2017 GraphDB\",\"datePublished\":\"2019-12-23T12:04:19+00:00\",\"dateModified\":\"2019-12-23T12:17:59+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/23\/sql-server-2017-graphdb\/\"},\"wordCount\":434,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/23\/sql-server-2017-graphdb\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-15.png\",\"keywords\":[\"An introduction to a SQL Server 2017 graph database\",\"graph database sql server\",\"graph database sql server 2017\",\"graph database sql server example\",\"Graph DB in sql server\",\"graph db sql server\",\"graph sql\",\"graph sql database\",\"GraphDB in sql server\",\"GraphDB in sql server 2017\",\"SQL Server 2017 Graph Database Example\",\"sql server graph database example\",\"SQL Server graph databases\",\"Understanding Graph Databases in SQL Server\",\"what is graph db in sql server\",\"what is graphdb in sql server\"],\"articleSection\":[\"MSSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/12\/23\/sql-server-2017-graphdb\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/23\/sql-server-2017-graphdb\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/23\/sql-server-2017-graphdb\/\",\"name\":\"SQL Server 2017 GraphDB - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/23\/sql-server-2017-graphdb\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/23\/sql-server-2017-graphdb\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-15.png\",\"datePublished\":\"2019-12-23T12:04:19+00:00\",\"dateModified\":\"2019-12-23T12:17:59+00:00\",\"description\":\"SQL Server 2017 GraphDB\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/23\/sql-server-2017-graphdb\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/12\/23\/sql-server-2017-graphdb\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/23\/sql-server-2017-graphdb\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-15.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-15.png\",\"width\":568,\"height\":362},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/23\/sql-server-2017-graphdb\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server 2017 GraphDB\"}]},{\"@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\/695ad69b2bd896864842ba8772930150\",\"name\":\"Yusuf KAHVEC\u0130\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/b7b4650ddb695869b13831d79f25c19ee915dc2151a7c8fcdf01538c295eb032?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/b7b4650ddb695869b13831d79f25c19ee915dc2151a7c8fcdf01538c295eb032?s=96&d=mm&r=g\",\"caption\":\"Yusuf KAHVEC\u0130\"},\"url\":\"https:\/\/dbtut.com\/index.php\/author\/yusufkahveci\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Server 2017 GraphDB - Database Tutorials","description":"SQL Server 2017 GraphDB","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\/2019\/12\/23\/sql-server-2017-graphdb\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server 2017 GraphDB - Database Tutorials","og_description":"SQL Server 2017 GraphDB","og_url":"https:\/\/dbtut.com\/index.php\/2019\/12\/23\/sql-server-2017-graphdb\/","og_site_name":"Database Tutorials","article_published_time":"2019-12-23T12:04:19+00:00","article_modified_time":"2019-12-23T12:17:59+00:00","og_image":[{"width":568,"height":362,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-15.png","type":"image\/png"}],"author":"Yusuf KAHVEC\u0130","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Yusuf KAHVEC\u0130","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/23\/sql-server-2017-graphdb\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/23\/sql-server-2017-graphdb\/"},"author":{"name":"Yusuf KAHVEC\u0130","@id":"https:\/\/dbtut.com\/#\/schema\/person\/695ad69b2bd896864842ba8772930150"},"headline":"SQL Server 2017 GraphDB","datePublished":"2019-12-23T12:04:19+00:00","dateModified":"2019-12-23T12:17:59+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/23\/sql-server-2017-graphdb\/"},"wordCount":434,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/23\/sql-server-2017-graphdb\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-15.png","keywords":["An introduction to a SQL Server 2017 graph database","graph database sql server","graph database sql server 2017","graph database sql server example","Graph DB in sql server","graph db sql server","graph sql","graph sql database","GraphDB in sql server","GraphDB in sql server 2017","SQL Server 2017 Graph Database Example","sql server graph database example","SQL Server graph databases","Understanding Graph Databases in SQL Server","what is graph db in sql server","what is graphdb in sql server"],"articleSection":["MSSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2019\/12\/23\/sql-server-2017-graphdb\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/23\/sql-server-2017-graphdb\/","url":"https:\/\/dbtut.com\/index.php\/2019\/12\/23\/sql-server-2017-graphdb\/","name":"SQL Server 2017 GraphDB - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/23\/sql-server-2017-graphdb\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/23\/sql-server-2017-graphdb\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-15.png","datePublished":"2019-12-23T12:04:19+00:00","dateModified":"2019-12-23T12:17:59+00:00","description":"SQL Server 2017 GraphDB","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/23\/sql-server-2017-graphdb\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2019\/12\/23\/sql-server-2017-graphdb\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/23\/sql-server-2017-graphdb\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-15.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-15.png","width":568,"height":362},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/23\/sql-server-2017-graphdb\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"SQL Server 2017 GraphDB"}]},{"@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\/695ad69b2bd896864842ba8772930150","name":"Yusuf KAHVEC\u0130","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/b7b4650ddb695869b13831d79f25c19ee915dc2151a7c8fcdf01538c295eb032?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b7b4650ddb695869b13831d79f25c19ee915dc2151a7c8fcdf01538c295eb032?s=96&d=mm&r=g","caption":"Yusuf KAHVEC\u0130"},"url":"https:\/\/dbtut.com\/index.php\/author\/yusufkahveci\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/14331","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\/483"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=14331"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/14331\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/14342"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=14331"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=14331"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=14331"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}