Graph of Thrones, Azure Cosmos DB vs. The Seven Kingdoms - Alan Smith
summary
Built a Game of Thrones graph by screen-scraping the Wiki into a 9,500-line JSON, loading it with a console app into Azure Cosmos DB Graph API (Gremlin) using an auto-scale 4,000 RU graph and partition key "key". Import finishes with 872 vertices and 2,095 edges (660 characters, 164 allegiances, 38 cultures, 10 religions). Demonstrated Gremlin traversals for parent/child chains, “who serves whom”, institution counts (House Stark 86, Targaryen 84) and a friend-recommendation example where Petyr Baelish shares 10 connections. Small import exceptions appear but queries and visual exploration work.
AI-written summary · about
chapters (22)
- 0:00Introduction
- 0:26About me
- 0:49Cosmos DB
- 1:01Global Distribution
- 1:28Database Models
- 1:56Architecture
- 2:49Gremlin Creature
- 3:13Neo4J
- 4:47Traditional Databases
- 5:36Relational Databases
- 7:12Graph Databases
- 8:18Graph Traversal
- 9:02No SQL
- 9:56Gathering Data
- 12:28Creating the Graph
- 13:31Visual Studio
- 14:24Console Application
- 15:43Graph of Thrones
- 17:14Querying the Graph
- 21:47Exploring Relationships
- 24:12Summary
- 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
43mGraphs are Everywhere
46mGraph Databases: Talking about your Data Relationships with Python
19mUnraveling the Web of Relationships: Understanding Graph Data