Difference between revisions of "History:Next Generation Schema/Release Relationships Conversion"

From MusicBrainz Wiki
(Album-Album)
 
(6 intermediate revisions by 2 users not shown)
Line 25: Line 25:
 
|  DJ-mix   
 
|  DJ-mix   
 
|  Album-Album   
 
|  Album-Album   
|  align="center" style="background:lightblue" | ReleaseGroup-ReleaseGroup
+
|  align="center" style="background:lightblue" | ReleaseGroup-ReleaseGroup
 
|   
 
|   
 
|  align="center" style="background:green" | OK  
 
|  align="center" style="background:green" | OK  
Line 87: Line 87:
 
|  align="center" style="background:lightgreen" | Release-Release   
 
|  align="center" style="background:lightgreen" | Release-Release   
 
|   
 
|   
|  align="center" | not handled
+
|  align="center" style="background:green" | OK
 
|}
 
|}
  
Line 103: Line 103:
 
|  compiler   
 
|  compiler   
 
|  Album-Artist   
 
|  Album-Artist   
|  align="center" style="background:lightgreen" | Artist-Release
+
|  align="center" style="background:lightgreen" | Artist-Release  
 
|  add to all releases and manual fixing?
 
|  add to all releases and manual fixing?
 
|  align="center" style="background:green" | OK  
 
|  align="center" style="background:green" | OK  
Line 109: Line 109:
 
|  mix-DJ   
 
|  mix-DJ   
 
|  Album-Artist   
 
|  Album-Artist   
|  align="center" style="background:lightgreen" | Artist-Release
+
|  align="center" style="background:lightgreen" | Artist-Release
 
|  add to all releases and manual fixing?
 
|  add to all releases and manual fixing?
 
|  align="center" style="background:green" | OK  
 
|  align="center" style="background:green" | OK  
Line 115: Line 115:
 
|  performer (instrument or vocal)  
 
|  performer (instrument or vocal)  
 
|  Album-Artist   
 
|  Album-Artist   
|  align="center" style="background:lightgreen" | Artist-Release
+
|  align="center" style="background:lightgreen" | Artist-Release
 
| add to all releases and manual fixing?   
 
| add to all releases and manual fixing?   
 
|  align="center" style="background:green" | OK  
 
|  align="center" style="background:green" | OK  
Line 121: Line 121:
 
|  performing orchestra  
 
|  performing orchestra  
 
|  Album-Artist   
 
|  Album-Artist   
|  align="center" style="background:lightgreen" | Artist-Release
+
|  align="center" style="background:lightgreen" | Artist-Release
 
|  add to all releases and manual fixing?
 
|  add to all releases and manual fixing?
 
|  align="center" style="background:green" | OK  
 
|  align="center" style="background:green" | OK  
Line 127: Line 127:
 
|  conductor  
 
|  conductor  
 
|  Album-Artist   
 
|  Album-Artist   
|  align="center" style="background:lightgreen" | Artist-Release
+
|  align="center" style="background:lightgreen" | Artist-Release
 
|  add to all releases and manual fixing?
 
|  add to all releases and manual fixing?
 
|  align="center" style="background:green" | OK  
 
|  align="center" style="background:green" | OK  
Line 133: Line 133:
 
|  chorus master  
 
|  chorus master  
 
|  Album-Artist   
 
|  Album-Artist   
|  align="center" style="background:lightgreen" | Artist-Release
+
|  align="center" style="background:lightgreen" | Artist-Release
 
|  add to all releases and manual fixing?
 
|  add to all releases and manual fixing?
 
|  align="center" style="background:green" | OK  
 
|  align="center" style="background:green" | OK  
Line 145: Line 145:
 
|  remixer  
 
|  remixer  
 
|  Album-Artist   
 
|  Album-Artist   
|  align="center" style="background:lightgreen" | Artist-Release
+
|  align="center" style="background:lightgreen" | Artist-Release
 
|  Add to all releases and manual fixing?
 
|  Add to all releases and manual fixing?
 
|  align="center" style="background:green" | OK  
 
|  align="center" style="background:green" | OK  
Line 151: Line 151:
 
|  samples from artist  
 
|  samples from artist  
 
|  Album-Artist   
 
|  Album-Artist   
|  align="center" style="background:lightgreen" | Artist-Release
+
|  align="center" style="background:lightgreen" | Artist-Release
 
|   
 
|   
 
|  align="center" style="background:green" | OK  
 
|  align="center" style="background:green" | OK  
 
|-
 
|-
 
|  composer  
 
|  composer  
|  Album-Artist
+
|  Album-Artist  
|  align="center" style="background:lightgreen" | Artist-Release ?   
+
|  align="center" style="background:lightgreen" | Artist-Release
 
|   
 
|   
 
|  align="center" style="background:green" | OK  
 
|  align="center" style="background:green" | OK  
Line 163: Line 163:
 
|  librettist  
 
|  librettist  
 
|  Album-Artist   
 
|  Album-Artist   
|  align="center" style="background:lightgreen" | Artist-Release ?   
+
|  align="center" style="background:lightgreen" | Artist-Release  
 
|   
 
|   
 
|  align="center" style="background:green" | OK  
 
|  align="center" style="background:green" | OK  
Line 169: Line 169:
 
|  arranger, instrumentator & orchestrator  
 
|  arranger, instrumentator & orchestrator  
 
|  Album-Artist   
 
|  Album-Artist   
|  align="center" style="background:lightgreen" | Artist-Release ?   
+
|  align="center" style="background:lightgreen" | Artist-Release
 
|   
 
|   
 
|  align="center" style="background:green" | OK  
 
|  align="center" style="background:green" | OK  
Line 175: Line 175:
 
|  lyricist  
 
|  lyricist  
 
|  Album-Artist   
 
|  Album-Artist   
|  align="center" style="background:lightgreen" | Artist-Release ?   
+
|  align="center" style="background:lightgreen" | Artist-Release
 
|   
 
|   
 
|  align="center" style="background:green" | OK  
 
|  align="center" style="background:green" | OK  
Line 181: Line 181:
 
|  producer  
 
|  producer  
 
|  Album-Artist   
 
|  Album-Artist   
|  align="center" style="background:lightgreen" | Artist-Release
+
|  align="center" style="background:lightgreen" | Artist-Release
 
|  add to all releases and manual fixing?
 
|  add to all releases and manual fixing?
 
|  align="center" style="background:green" | OK  
 
|  align="center" style="background:green" | OK  
Line 187: Line 187:
 
|  engineer (and all subtypes)  
 
|  engineer (and all subtypes)  
 
|  Album-Artist   
 
|  Album-Artist   
|  align="center" style="background:lightgreen" | Artist-Release
+
|  align="center" style="background:lightgreen" | Artist-Release
 
|  add to all releases and manual fixing?
 
|  add to all releases and manual fixing?
 
|  align="center" style="background:green" | OK  
 
|  align="center" style="background:green" | OK  
Line 193: Line 193:
 
|  legal representation   
 
|  legal representation   
 
|  Album-Artist   
 
|  Album-Artist   
|  align="center" style="background:lightblue" | Artist-ReleaseGroup 
+
|  align="center" style="background:lightgreen" | Artist-Release
 
|  
 
|  
|  align="center" style="background:red" | Artist-Release
+
|  align="center" style="background:green" | OK
 
|-
 
|-
 
|  booking   
 
|  booking   
 
|  Album-Artist   
 
|  Album-Artist   
|  align="center" style="background:lightblue" | Artist-ReleaseGroup 
+
|  align="center" style="background:lightgreen" | Artist-Release
 
|  
 
|  
|  align="center" style="background:red" | Artist-Release
+
|  align="center" style="background:green" | OK
 
|-
 
|-
 
|  artists and repertoire   
 
|  artists and repertoire   
 
|  Album-Artist   
 
|  Album-Artist   
|  align="center" style="background:lightgreen" | Artist-Release ?    
+
|  align="center" style="background:lightblue" | Artist-ReleaseGroup    
 
|  
 
|  
 
|  align="center" style="background:green" | OK  
 
|  align="center" style="background:green" | OK  
Line 213: Line 213:
 
|  align="center" style="background:lightblue" | Artist-ReleaseGroup  
 
|  align="center" style="background:lightblue" | Artist-ReleaseGroup  
 
|  
 
|  
|  align="center" style="background:red" | Artist-Release
+
|  align="center" style="background:green" | OK
 
|-
 
|-
 
|  art direction   
 
|  art direction   
 
|  Album-Artist   
 
|  Album-Artist   
|  align="center" style="background:lightgreen" | Artist-Release
+
|  align="center" style="background:lightgreen" | Artist-Release
 
|  add to all releases and manual fixing?
 
|  add to all releases and manual fixing?
 
|  align="center" style="background:green" | OK  
 
|  align="center" style="background:green" | OK  
Line 223: Line 223:
 
|  design/illustration   
 
|  design/illustration   
 
|  Album-Artist   
 
|  Album-Artist   
|  align="center" style="background:lightgreen" | Artist-Release
+
|  align="center" style="background:lightgreen" | Artist-Release
 
|  add to all releases and manual fixing?
 
|  add to all releases and manual fixing?
 
|  align="center" style="background:green" | OK  
 
|  align="center" style="background:green" | OK  
Line 229: Line 229:
 
|  graphic design   
 
|  graphic design   
 
|  Album-Artist   
 
|  Album-Artist   
|  align="center" style="background:lightgreen" | Artist-Release
+
|  align="center" style="background:lightgreen" | Artist-Release
 
|  add to all releases and manual fixing?
 
|  add to all releases and manual fixing?
 
|  align="center" style="background:green" | OK  
 
|  align="center" style="background:green" | OK  
Line 235: Line 235:
 
|  photography   
 
|  photography   
 
|  Album-Artist   
 
|  Album-Artist   
|  align="center" style="background:lightgreen" | Artist-Release
+
|  align="center" style="background:lightgreen" | Artist-Release
 
|  add to all releases and manual fixing?
 
|  add to all releases and manual fixing?
 
|  align="center" style="background:green" | OK  
 
|  align="center" style="background:green" | OK  
Line 243: Line 243:
 
|  align="center" style="background:lightblue" | Artist-ReleaseGroup   
 
|  align="center" style="background:lightblue" | Artist-ReleaseGroup   
 
|  
 
|  
|  align="center" style="background:red" | Artist-Release
+
|  align="center" style="background:green" | OK
 
|-
 
|-
 
|  publishing   
 
|  publishing   
 
|  Album-Artist   
 
|  Album-Artist   
|  align="center" style="background:lightgreen" | Artist-Release
+
|  align="center" style="background:lightgreen" | Artist-Release
 
|  
 
|  
 
|  align="center" style="background:green" | OK  
 
|  align="center" style="background:green" | OK  
Line 253: Line 253:
 
|  merchandise   
 
|  merchandise   
 
|  Album-Artist   
 
|  Album-Artist   
|  align="center" style="background:lightgreen" | Artist-Release
+
|  align="center" style="background:lightgreen" | Artist-Release
 
|  
 
|  
 
|  align="center" style="background:green" | OK  
 
|  align="center" style="background:green" | OK  
Line 259: Line 259:
 
|  liner notes   
 
|  liner notes   
 
|  Album-Artist   
 
|  Album-Artist   
|  align="center" style="background:lightgreen" | Artist-Release
+
|  align="center" style="background:lightgreen" | Artist-Release
 
|  
 
|  
 +
|  align="center" style="background:green" | OK
 +
|-
 +
|  writer
 +
|  Album-Artist 
 +
|  align="center" style="background:lightgreen" | Artist-Release
 +
 
|  align="center" style="background:green" | OK  
 
|  align="center" style="background:green" | OK  
 
|}
 
|}
Line 371: Line 377:
 
|  musicmoz   
 
|  musicmoz   
 
|  Album-URL   
 
|  Album-URL   
|  align="center" style="background:lightgreen" | Release-URL
+
|  align="center" style="background:lightblue" | ReleaseGroup-URL
 
|  add to all releases and manual fixing
 
|  add to all releases and manual fixing
|  align="center" style="background:red" | missing
+
|  align="center" style="background:green" | OK
 
|-
 
|-
 
| lyrics  
 
| lyrics  
 
| Album-URL  
 
| Album-URL  
| ReleaseGroup-URL?
+
| align="center" style="background:lightblue" | ReleaseGroup-URL
 
| see below
 
| see below
|  align="center" style="background:red" | missing
+
|  align="center" style="background:green" | OK 
 
|-
 
|-
 
| IMDb samples  
 
| IMDb samples  
 
| Album-URL  
 
| Album-URL  
| Release-URL?
+
| align="center" style="background:lightgreen" | Release-URL
| ?
+
|  
|  align="center" style="background:red" | missing
+
|  align="center" style="background:green" | OK
 
|-
 
|-
 
| recording studio  
 
| recording studio  
 
| Album-URL  
 
| Album-URL  
| Release-URL?
+
| align="center" style="background:lightblue" | ReleaseGroup-URL
| ?
+
|  
|  align="center" style="background:red" | missing
+
|  align="center" style="background:green" | OK
 
|-
 
|-
 
| score  
 
| score  
 
| Album-URL  
 
| Album-URL  
| ReleaseGroup-URL?
+
| align="center" style="background:lightblue" | ReleaseGroup-URL
| ?
+
|  
|  align="center" style="background:red" | missing
+
|  align="center" style="background:green" | OK
 
|-
 
|-
 
| streaming music  
 
| streaming music  
 
| Album-URL  
 
| Album-URL  
| ReleaseGroup-URL?
+
| align="center" style="background:lightgreen" | Release-URL
| ?
+
|  
|  align="center" style="background:red" | missing
+
|  align="center" style="background:green" | OK
 
|-
 
|-
 
| vgmdb  
 
| vgmdb  
 
| Album-URL  
 
| Album-URL  
| Release-URL
+
| align="center" style="background:lightgreen" | Release-URL
 
| add to all releases and manual fixing
 
| add to all releases and manual fixing
|  align="center" style="background:red" | missing
+
|  align="center" style="background:green" | OK
 
|}
 
|}
  

Latest revision as of 18:33, 4 November 2011

Legend

To ReleaseGroup To Release


The NGS migration scripts match the specification described in this document
The NGS migration scripts either don't handle this AR type or do something different

Album-Album

AR Type     Now         NGS         Comment     Status in migration scripts
DJ-mix Album-Album ReleaseGroup-ReleaseGroup OK
earliest release Album-Album Release-Release Link should be dropped OK
live performance Album-Album ReleaseGroup-ReleaseGroup OK
remaster Album-Album Release-Release will need manual fixing OK
cover Album-Album ReleaseGroup-ReleaseGroup OK
transl-tracklisting Album-Album Release-Release partially automatic using release data OK
remix Album-Album ReleaseGroup-ReleaseGroup OK
mashes up Album-Album ReleaseGroup-ReleaseGroup OK
part of set Album-Album Release-Release Merge the (NGS) releases, partially automatic using release data. Link should be dropped once manual fixing has been done. OK
single from Album-Album ReleaseGroup-ReleaseGroup OK
supporting release Album-Album Release-Release OK

Album-Artist

For reference: current AR tree for Album-Artist (with links to each AR type documentation)

AR Type     Now         NGS         Comment     Status in migration scripts
compiler Album-Artist Artist-Release add to all releases and manual fixing? OK
mix-DJ Album-Artist Artist-Release add to all releases and manual fixing? OK
performer (instrument or vocal) Album-Artist Artist-Release add to all releases and manual fixing? OK
performing orchestra Album-Artist Artist-Release add to all releases and manual fixing? OK
conductor Album-Artist Artist-Release add to all releases and manual fixing? OK
chorus master Album-Artist Artist-Release add to all releases and manual fixing? OK
tribute Album-Artist Artist-ReleaseGroup OK
remixer Album-Artist Artist-Release Add to all releases and manual fixing? OK
samples from artist Album-Artist Artist-Release OK
composer Album-Artist Artist-Release OK
librettist Album-Artist Artist-Release OK
arranger, instrumentator & orchestrator Album-Artist Artist-Release OK
lyricist Album-Artist Artist-Release OK
producer Album-Artist Artist-Release add to all releases and manual fixing? OK
engineer (and all subtypes) Album-Artist Artist-Release add to all releases and manual fixing? OK
legal representation Album-Artist Artist-Release OK
booking Album-Artist Artist-Release OK
artists and repertoire Album-Artist Artist-ReleaseGroup OK
creative direction Album-Artist Artist-ReleaseGroup OK
art direction Album-Artist Artist-Release add to all releases and manual fixing? OK
design/illustration Album-Artist Artist-Release add to all releases and manual fixing? OK
graphic design Album-Artist Artist-Release add to all releases and manual fixing? OK
photography Album-Artist Artist-Release add to all releases and manual fixing? OK
travel Album-Artist Artist-ReleaseGroup OK
publishing Album-Artist Artist-Release OK
merchandise Album-Artist Artist-Release OK
liner notes Album-Artist Artist-Release OK
writer Album-Artist Artist-Release OK

Album-Label

AR Type     Now         NGS         Comment     Status in migration scripts
publishing Album-Label Label-Release OK

Album-Track

AR Type     Now         NGS         Comment     Status in migration scripts
samples material Album-Track Release-Track OK

Album-URL

AR Type     Now         NGS         Comment     Status in migration scripts
Amazon asin Album-URL Release-URL partially automatic matching using barcodes OK
cover art link Album-URL Release-URL Add to all releases and manual fixing OK
review Album-URL ReleaseGroup-URL OK
purchase for mail-order Album-URL Release-URL add to all releases and manual fixing? OK
purchase for download Album-URL Release-URL add to all releases and manual fixing? OK
download for free Album-URL Release-URL add to all releases and manual fixing? OK
creative commons licensed download Album-URL Release-URL add to all releases and manual fixing? OK
IMDb, ibdb, iobdb Album-URL ReleaseGroup-URL ok OK
wikipedia Album-URL ReleaseGroup-URL ok OK
discogs Album-URL Release-URL for discogs.com/release/XXX urls partially automatic matching using label/cat# OK
ReleaseGroup-URL for discogs.com/master/XXX urls ok OK
musicmoz Album-URL ReleaseGroup-URL add to all releases and manual fixing OK
lyrics Album-URL ReleaseGroup-URL see below OK
IMDb samples Album-URL Release-URL OK
recording studio Album-URL ReleaseGroup-URL OK
score Album-URL ReleaseGroup-URL OK
streaming music Album-URL Release-URL OK
vgmdb Album-URL Release-URL add to all releases and manual fixing OK

VGMDb should be release-URL, their entries are the same as Discogs and NGS releases. LyricWiki aren't consistent when it comes to creating separate pages or not, so sometimes there could be multiple links, but I think their pages are closer to release groups than releases. I'd currently suggest release-URL for IMDb samples and recording studio, since we're currently using artist-release for "samples from artist" and "recorded". There's only one album-URL score relationship, but I'd probably treat it the same as lyrics. For streaming music, I think that's also similar to lyrics in that it's just a set of tracks and not specific to a particular release (event), so I'd say release group for that too. --Nikki 19:17, 19 November 2010 (UTC)