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

From MusicBrainz Wiki
(Album-URL)
(update according to http://git.musicbrainz.org/gitweb/?p=musicbrainz-server.git;a=commitdiff;h=b94c477ba18a27dc7d0e9fe7649c3c6d538a2179)
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 195: Line 195:
 
|  align="center" style="background:lightgreen" | Artist-Release
 
|  align="center" style="background:lightgreen" | Artist-Release
 
|  
 
|  
|  align="center" style="background:green" | Artist-Release
+
|  align="center" style="background:green" | OK
 
|-
 
|-
 
|  booking   
 
|  booking   
Line 201: Line 201:
 
|  align="center" style="background:lightgreen" | Artist-Release  
 
|  align="center" style="background:lightgreen" | Artist-Release  
 
|  
 
|  
|  align="center" style="background:green" | Artist-Release
+
|  align="center" style="background:green" | OK
 
|-
 
|-
 
|  artists and repertoire   
 
|  artists and repertoire   
Line 207: Line 207:
 
|  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
 
|-
 
|-
 
|  creative direction   
 
|  creative direction   
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   
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   
Line 267: Line 267:
 
|  align="center" style="background:lightgreen" | Artist-Release
 
|  align="center" style="background:lightgreen" | Artist-Release
 
|   
 
|   
|  align="center" | ?
+
|  align="center" style="background:green" | OK
 
|}
 
|}
  
Line 379: Line 379:
 
|  align="center" style="background:lightblue" | ReleaseGroup-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  
Line 385: Line 385:
 
| align="center" style="background:lightblue" | 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  
Line 391: Line 391:
 
| align="center" style="background:lightgreen" | 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  
Line 397: Line 397:
 
| align="center" style="background:lightblue" | ReleaseGroup-URL
 
| align="center" style="background:lightblue" | ReleaseGroup-URL
 
|  
 
|  
|  align="center" style="background:red" | missing
+
|  align="center" style="background:green" | OK
 
|-
 
|-
 
| score  
 
| score  
Line 403: Line 403:
 
| align="center" style="background:lightblue" | 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  
Line 409: Line 409:
 
| align="center" style="background:lightgreen" | Release-URL
 
| align="center" style="background:lightgreen" | Release-URL
 
|  
 
|  
|  align="center" style="background:red" | missing
+
|  align="center" style="background:green" | OK
 
|-
 
|-
 
| vgmdb  
 
| vgmdb  
Line 415: Line 415:
 
| align="center" style="background:lightgreen" | 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
 
|}
 
|}
  

Revision as of 21:32, 14 March 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)