SQLAllFather on Nostr: I'm spending some of my holiday weekend working on my #MicrosoftFabric "Chainmail" ...
I'm spending some of my holiday weekend working on my #MicrosoftFabric "Chainmail" pet project. This morning's fun is finding a reliable way to identify what country a given artist is from.
This sounds like it should be a simple problem to solve, but the #MusicBrainz dataset I'm using allows an artist's area to be of any type (country, subdivision, county, municipality, city, district, or island) and their data model is... normalized to death.
Seriously, look at this:
https://wiki.musicbrainz.org/images/d/d4/area_entity_details.svg
https://musicbrainz.org/doc/Area
There's a ragged hierarchy between parent and child areas... and the mapping between them isn't included in any of the documented tables in their documentation.
1/
This sounds like it should be a simple problem to solve, but the #MusicBrainz dataset I'm using allows an artist's area to be of any type (country, subdivision, county, municipality, city, district, or island) and their data model is... normalized to death.
Seriously, look at this:
https://wiki.musicbrainz.org/images/d/d4/area_entity_details.svg
https://musicbrainz.org/doc/Area
There's a ragged hierarchy between parent and child areas... and the mapping between them isn't included in any of the documented tables in their documentation.
1/