Sunday, May 21, 2017

Azure Cosmos DB Graph APIs, Microsoft Graph API, SQL Graph

Introduction to Azure Cosmos DB Graph APIs | Microsoft Docs
"Azure Cosmos DB can be queried using Apache TinkerPop's graph traversal language, Gremlin, and integrates with other TinkerPop-compatible graph systems."
Gremlin, graph, and Azure Cosmos DB

Sample database showing persons, devices, and interests

Build an Azure Cosmos DB .NET application using the Graph API | Microsoft Docs
Visual graph explorer in Data Explorer in the Azure portal


Not to be confused with "Microsoft Graph API" that is superset of Azure AD and O365 APIs.
Overview - Documentation - Microsoft Graph
An image showing the primary resources and relationships that are part of the graph


Also not to be confused with new Graph features in SQL Server 2017
SQL Graph Architecture | Microsoft Docs

sql-graph-architecture

person-friends-tables



It will be interesting to see performance comparisons with native Graph databases like Neo4j
Usually to keep high performance graph databases run on single node with very large memory...
Microsoft so far implemented Gremlin language, while Neo4j has very good Cypher query language.

No comments: