Music Knowledge Graph
A Chinook-style music store modeled as a Neo4j property graph - artists, albums, tracks, genres, media types and composers.
Source: Chinook CSVs · 6 node labels, 5 relationship types
5,007
Nodes
13,381
Relationships
6
Node types
5
Relationship types
Nodes by label
| Track | 3,503 |
| Composer | 852 |
| Album | 347 |
| Artist | 275 |
| Genre | 25 |
| MediaType | 5 |
Relationships by type
| CONTAINS | 3,503 |
| IN_GENRE | 3,503 |
| OF_MEDIA_TYPE | 3,503 |
| RELEASED | 347 |
| COMPOSED_BY | 2,525 |
Graph model
The schema at a glance: each label and the relationship types connecting them.
Graded questions (3a-3f)
The six required read queries, with results frozen from the graph build.
Jazz tracks composed by Miles Davis
Tracks in the Jazz genre whose composer is Miles Davis.
MATCH (g:Genre {name:'Jazz'})<-[:IN_GENRE]-(t:Track)-[:COMPOSED_BY]->(c:Composer {name:'Miles Davis'})
RETURN t.name AS track| track |
|---|
| 'Round Midnight |
| Black Satin |
| Bye Bye Blackbird |
| Compulsion |
| E.S.P. |
| Generique |
| Jean Pierre (Live) |
| Jeru |
| Little Church (Live) |
| Miles Runs The Voodoo Down |
Artists with an AAC-audio-file track
Artists who have at least one track distributed as an 'AAC audio file'.
MATCH (:MediaType {name:'AAC audio file'})<-[:OF_MEDIA_TYPE]-(:Track)<-[:CONTAINS]-(:Album)<-[:RELEASED]-(a:Artist)
RETURN DISTINCT a.name AS artist| artist |
|---|
| Aaron Goldberg |
| Aisha Duo |
| Habib Koité and Bamada |
| Karsh Kale |
| Luciana Souza/Romero Lubambo |
| Nicolaus Esterhazy Sinfonia |
| The Posies |
Artist(s) who released "Bongo Fury"
Artists linked by RELEASED to the album titled 'Bongo Fury'.
MATCH (a:Artist)-[:RELEASED]->(:Album {title:'Bongo Fury'})
RETURN a.name AS artist| artist |
|---|
| Frank Zappa & Captain Beefheart |
Tracks on Led Zeppelin's "Coda"
All tracks contained in Led Zeppelin's album 'Coda'.
MATCH (:Artist {name:'Led Zeppelin'})-[:RELEASED]->(:Album {title:'Coda'})-[:CONTAINS]->(t:Track)
RETURN DISTINCT t.name AS track| track |
|---|
| Bonzo's Montreux |
| Darlene |
| I Can't Quit You Baby |
| Ozone Baby |
| Poor Tom |
| Walter's Walk |
| We're Gonna Groove |
| Wearing And Tearing |
Albums with a track composed by "Alanis Morissette & Glenn Ballard"
Albums that contain at least one track composed by this writing duo.
MATCH (:Composer {name:'Alanis Morissette & Glenn Ballard'})<-[:COMPOSED_BY]-(t:Track)<-[:CONTAINS]-(a:Album)
RETURN DISTINCT a.title AS album| album |
|---|
| Jagged Little Pill |
Albums with a track that has no composer
Albums containing at least one track that lacks a COMPOSED_BY relationship.
MATCH (a:Album)-[:CONTAINS]->(t:Track)
WHERE NOT (t)-[:COMPOSED_BY]->()
RETURN DISTINCT a.title AS albumName| albumName |
|---|
| 20th Century Masters - The Millennium Collection: The Best of Scorpions |
| A Matter of Life and Death |
| Alcohol Fueled Brewtality Live! [Disc 1] |
| Alcohol Fueled Brewtality Live! [Disc 2] |
| Angel Dust |
| Appetite for Destruction |
| Aquaman |
| Arquivo Os Paralamas Do Sucesso |
| As Canções de Eu Tu Eles |
| Back to Black |
Explore the catalog
Only six queries were precomputed, yet the full graph ships with the page - so you can ask your own questions client-side (e.g. pick Rock to see all 1,297 rock tracks). No database, all in the browser.