Graph of Thrones, Azure Cosmos DB vs. The Seven Kingdoms
summary
Uses Azure Cosmos DB's Gremlin API to model Game of Thrones: screen-scrapes the wiki into a ~9,500-line JSON, imports via a console app into a graph with 872 vertices and 2,095 edges (660 characters, 164 allegiances, 38 cultures, 10 religions). Shows the import pipeline, uses autoscale up to 4,000 RUs, hits a few import errors but completes, runs traversals to get grandchildren, group-counts (e.g. House Stark 86, House Targaryen 84) and a friend-recommendation query that returns Petyr Baelish — 10 shared connections.
AI-written summary · about
chapters (21)
- 0:00Introduction
- 0:26About me
- 0:49Azure Cosmos DB
- 1:01Global Distribution
- 1:28Database Models
- 1:56Architecture
- 2:49Gremlin Creature
- 3:13Neo4J
- 3:56Community Competition
- 4:25Cosmos DB
- 4:47Traditional Databases
- 5:36Relational Databases
- 7:12Graph Databases
- 8:17Graph Traversal
- 9:02No SQL
- 12:19Azure Portal
- 13:31Visual Studio
- 15:43Game of Thrones Graph
- 17:14Querying Game of Thrones
- 21:47Exploring Relationships
- 25:17Outro
related talks
57mGraphing Your Way Through the Cosmos: Common Data Problems Solved with Graphs
01h 00mWho’s Afraid of Graphs?
46mGraph Algorithms: Predict Real-World Behavior
01h 25mNetwork Science, Game of Thrones and US Airports
29mThinking in Graphs – An Intro to Graph Databases & Applications
46mGraph Databases: Talking about your Data Relationships with Python
52mDungeons, Dragons, and Graph Databases
32mGraph Databases, and Dungeons and Dragons