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

From MusicBrainz Wiki
Jump to navigationJump to search
 
(20 intermediate revisions by 5 users not shown)
Line 1: Line 1:
==Album--Album==
== Legend ==
{|
|-
| style="background:lightblue" | To ReleaseGroup
| style="background:lightgreen" | To Release
|}



{| border="1"
{|
|-
|-
| style="background:green" | The NGS migration scripts match the specification described in this document
| DJ-mix || album--album || release_group--release_group ? ||
|-
|-
| style="background:red" | The NGS migration scripts either don't handle this AR type or do something different
| earliest release || album--album || - || drop the link
|}

==Album-Album==

{| width='80%'
! AR Type
!     Now    
!     NGS    
!     Comment    
! Status in migration scripts
|-
|-
| DJ-mix
| live performance || album--album || release_group-release_group ? ||
| Album-Album
| align="center" style="background:lightblue" | ReleaseGroup-ReleaseGroup
|
| align="center" style="background:green" | OK
|-
|-
| earliest release
| remaster || album--album || release-release ? || will need manual fixing
| Album-Album
| align="center" style="background:lightgreen" | Release-Release
| Link should be dropped
| align="center" style="background:green" | OK
|-
|-
| live performance
| cover || album--album || release_group-release_group ||
| Album-Album
| align="center" style="background:lightblue" | ReleaseGroup-ReleaseGroup
|
| align="center" style="background:green" | OK
|-
|-
| remaster
| transl-tracklisting || album--album || release-release || partially automatic using release data
| Album-Album
| align="center" style="background:lightgreen" | Release-Release
| will need manual fixing
| align="center" style="background:green" | OK
|-
|-
| cover
| remix || album--album || release_group-release_group ||
| Album-Album
| align="center" style="background:lightblue" | ReleaseGroup-ReleaseGroup
|
| align="center" style="background:green" | OK
|-
|-
| transl-tracklisting
| mashes up || album--album || release_group-release_group ||
| Album-Album
| align="center" style="background:lightgreen" | Release-Release
| partially automatic using release data
| align="center" style="background:green" | OK
|-
|-
| remix
| part of set || album--album || - || merge the (NGS) releases and drop the link, partially automatic using release data
| Album-Album
| align="center" style="background:lightblue" | ReleaseGroup-ReleaseGroup
|
| align="center" style="background:green" | OK
|-
| mashes up
| Album-Album
| align="center" style="background:lightblue" | ReleaseGroup-ReleaseGroup
|
| align="center" style="background:green" | OK
|-
| part of set
| Album-Album
| align="center" style="background:lightgreen" | Release-Release
| Merge the (NGS) releases, partially automatic using release data. Link should be dropped once manual fixing has been done.
| align="center" style="background:green" | OK
|-
| single from
| Album-Album
| align="center" style="background:lightblue" | ReleaseGroup-ReleaseGroup
|
| align="center" style="background:green" | OK
|-
| supporting release
| Album-Album
| align="center" style="background:lightgreen" | Release-Release
|
| align="center" style="background:green" | OK
|}
|}


==Album-Artist==


For reference: [http://musicbrainz.org/edit/relationships/link_types.html?type=album-artist current AR tree for Album-Artist] (with links to each AR type documentation)


{| width='80%'
==Album--Artist==
! AR Type

!     Now    
{| border="1"
!     NGS    
!     Comment    
! Status in migration scripts
|-
|-
| compiler
| compiler || album--artist || artist--release ? || add to all releases and manual fixing?
| Album-Artist
| align="center" style="background:lightgreen" | Artist-Release
| add to all releases and manual fixing?
| align="center" style="background:green" | OK
|-
|-
| mix-DJ
| mix-DJ || album--artist || artist--release ? || add to all releases and manual fixing?
| Album-Artist
| align="center" style="background:lightgreen" | Artist-Release
| add to all releases and manual fixing?
| align="center" style="background:green" | OK
|-
|-
| performer (instrument or vocal) || album--artist || artist--release ? || add to all releases and manual fixing?
| performer (instrument or vocal)
| Album-Artist
| align="center" style="background:lightgreen" | Artist-Release
| add to all releases and manual fixing?
| align="center" style="background:green" | OK
|-
|-
| performing orchestra || album--artist || artist--release ? || add to all releases and manual fixing?
| performing orchestra
| Album-Artist
| align="center" style="background:lightgreen" | Artist-Release
| add to all releases and manual fixing?
| align="center" style="background:green" | OK
|-
|-
| conductor
| conductor || album--artist || artist--release ? || add to all releases and manual fixing?
| Album-Artist
| align="center" style="background:lightgreen" | Artist-Release
| add to all releases and manual fixing?
| align="center" style="background:green" | OK
|-
|-
| chorus master
| chorus master || album--artist || artist--release ? || add to all releases and manual fixing?
| Album-Artist
| align="center" style="background:lightgreen" | Artist-Release
| add to all releases and manual fixing?
| align="center" style="background:green" | OK
|-
|-
| tribute
| tribute || album--artist || artist--release_group ||
| Album-Artist
| align="center" style="background:lightblue" | Artist-ReleaseGroup
|
| align="center" style="background:green" | OK
|-
|-
| remixer
| remixer || album--artist || artist--release ? || add to all releases and manual fixing?
| Album-Artist
| align="center" style="background:lightgreen" | Artist-Release
| Add to all releases and manual fixing?
| align="center" style="background:green" | OK
|-
|-
| samples from artist || album--artist || artist--release ? ||
| samples from artist
| Album-Artist
| align="center" style="background:lightgreen" | Artist-Release
|
| align="center" style="background:green" | OK
|-
|-
| composer || album--artist || ||
| composer
| Album-Artist
| align="center" style="background:lightgreen" | Artist-Release
|
| align="center" style="background:green" | OK
|-
|-
| librettist || album--artist || ||
| librettist
| Album-Artist
| align="center" style="background:lightgreen" | Artist-Release
|
| align="center" style="background:green" | OK
|-
|-
| arranger, instrumentator & orchestrator || album--artist || ||
| arranger, instrumentator & orchestrator
| Album-Artist
| align="center" style="background:lightgreen" | Artist-Release
|
| align="center" style="background:green" | OK
|-
|-
| lyricist || album--artist || ||
| lyricist
| Album-Artist
| align="center" style="background:lightgreen" | Artist-Release
|
| align="center" style="background:green" | OK
|-
|-
| producer
| producer || album--artist || artist--release ? || add to all releases and manual fixing?
| Album-Artist
| align="center" style="background:lightgreen" | Artist-Release
| add to all releases and manual fixing?
| align="center" style="background:green" | OK
|-
|-
| engineer (and all subtypes) || album--artist || artist--release ? || add to all releases and manual fixing?
| engineer (and all subtypes)
| Album-Artist
| align="center" style="background:lightgreen" | Artist-Release
| add to all releases and manual fixing?
| align="center" style="background:green" | OK
|-
|-
| legal representation || album--artist || artist--release_group ||
| legal representation
| Album-Artist
| align="center" style="background:lightgreen" | Artist-Release
|
| align="center" style="background:green" | OK
|-
|-
| booking
| booking || album--artist || artist--release_group ||
| Album-Artist
| align="center" style="background:lightgreen" | Artist-Release
|
| align="center" style="background:green" | OK
|-
|-
| artists and repertoire || album--artist || ||
| artists and repertoire
| Album-Artist
| align="center" style="background:lightblue" | Artist-ReleaseGroup
|
| align="center" style="background:green" | OK
|-
|-
| creative direction || album--artist || artist--release_group ||
| creative direction
| Album-Artist
| align="center" style="background:lightblue" | Artist-ReleaseGroup
|
| align="center" style="background:green" | OK
|-
|-
| art direction
| art direction || album--artist || artist--release ? || add to all releases and manual fixing?
| Album-Artist
| align="center" style="background:lightgreen" | Artist-Release
| add to all releases and manual fixing?
| align="center" style="background:green" | OK
|-
|-
| design/illustration || album--artist || artist--release ? || add to all releases and manual fixing?
| design/illustration
| Album-Artist
| align="center" style="background:lightgreen" | Artist-Release
| add to all releases and manual fixing?
| align="center" style="background:green" | OK
|-
|-
| graphic design
| graphic design || album--artist || artist--release ? || add to all releases and manual fixing?
| Album-Artist
| align="center" style="background:lightgreen" | Artist-Release
| add to all releases and manual fixing?
| align="center" style="background:green" | OK
|-
|-
| photography
| photography || album--artist || artist--release ? || add to all releases and manual fixing?
| Album-Artist
| align="center" style="background:lightgreen" | Artist-Release
| add to all releases and manual fixing?
| align="center" style="background:green" | OK
|-
|-
| travel
| travel || album--artist || artist--release_group ||
| Album-Artist
| align="center" style="background:lightblue" | Artist-ReleaseGroup
|
| align="center" style="background:green" | OK
|-
|-
| publishing || album--artist || ||
| publishing
| Album-Artist
| align="center" style="background:lightgreen" | Artist-Release
|
| align="center" style="background:green" | OK
|-
|-
| merchandise || album--artist || ||
| merchandise
| Album-Artist
| align="center" style="background:lightgreen" | Artist-Release
|
| align="center" style="background:green" | OK
|-
|-
| liner notes || album--artist || ||
| liner notes
| Album-Artist
| 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
|}
|}


==Album--Label==
==Album-Label==


{| border="1"
{| width='80%'
! AR Type
!     Now    
!     NGS    
!     Comment    
! Status in migration scripts
|-
|-
| publishing || album--label || ?
| publishing
| Album-Label
| align="center" style="background:lightgreen" | Label-Release
|
| align="center" style="background:green" | OK
|}
|}


==Album--Track==
==Album-Track==


{| border="1"
{| width='80%'
! AR Type
!     Now    
!     NGS    
!     Comment    
! Status in migration scripts
|-
|-
| samples material || album--track || ?
| samples material
| Album-Track
| align="center" style="background:lightgreen" | Release-Track
|
| align="center" style="background:green" | OK
|}
|}


==Album--URL==
==Album-URL==


{| border="1"
{| width='80%'
! AR Type
!     Now    
!     NGS    
!     Comment    
! Status in migration scripts
|-
|-
| Amazon asin
| amazon asin || album--url || release-url || partially automatic matching using barcodes
| Album-URL
| align="center" style="background:lightgreen" | Release-URL
| partially automatic matching using barcodes
| align="center" style="background:green" | OK
|-
|-
| cover art link
| cover art link || album--url || release-url || add to all releases and manual fixing?
| Album-URL
| align="center" style="background:lightgreen" | Release-URL
| Add to all releases and manual fixing
| align="center" style="background:green" | OK
|-
|-
| review
| review || album--url || release_group--url || ok
| Album-URL
| align="center" style="background:lightblue" | ReleaseGroup-URL
|
| align="center" style="background:green" | OK
|-
|-
| purchase for mail-order || album--url || release--url || add to all releases and manual fixing?
| purchase for mail-order
| Album-URL
| align="center" style="background:lightgreen" | Release-URL
| add to all releases and manual fixing?
| align="center" style="background:green" | OK
|-
|-
| purchase for download || album--url || release--url || add to all releases and manual fixing?
| purchase for download
| Album-URL
| align="center" style="background:lightgreen" | Release-URL
| add to all releases and manual fixing?
| align="center" style="background:green" | OK
|-
|-
| download for free || album--url || release--url || add to all releases and manual fixing?
| download for free
| Album-URL
| align="center" style="background:lightgreen" | Release-URL
| add to all releases and manual fixing?
| align="center" style="background:green" | OK
|-
|-
| creative commons licensed download || album--url || release--url || add to all releases and manual fixing?
| creative commons licensed download
| Album-URL
| align="center" style="background:lightgreen" | Release-URL
| add to all releases and manual fixing?
| align="center" style="background:green" | OK
|-
|-
| IMDb, ibdb, iobdb || album--url || release_group-url || ok
| IMDb, ibdb, iobdb
| Album-URL
| align="center" style="background:lightblue" | ReleaseGroup-URL
| ok
| align="center" style="background:green" | OK
|-
|-
| wikipedia || album--url || release_group--url || ok
| wikipedia
| Album-URL
| align="center" style="background:lightblue" | ReleaseGroup-URL
| ok
| align="center" style="background:green" | OK
|-
|-
| rowspan="2"| discogs
| discogs || album--url || release--url || partially automatic matching using label/cat#
| rowspan="2"| Album-URL
| align="center" style="background:lightgreen" | Release-URL for discogs.com/release/XXX urls
| partially automatic matching using label/cat#
| align="center" style="background:green" | OK
|-
|-
| align="center" style="background:lightblue" | ReleaseGroup-URL for discogs.com/master/XXX urls
| musicmoz || album--url || release--url ? || add to all releases and manual fixing
| ok
| align="center" style="background:green" | OK
|-
| musicmoz
| Album-URL
| align="center" style="background:lightblue" | ReleaseGroup-URL
| add to all releases and manual fixing
| align="center" style="background:green" | OK
|-
| lyrics
| Album-URL
| align="center" style="background:lightblue" | ReleaseGroup-URL
| see below
| align="center" style="background:green" | OK
|-
| IMDb samples
| Album-URL
| align="center" style="background:lightgreen" | Release-URL
|
| align="center" style="background:green" | OK
|-
| recording studio
| Album-URL
| align="center" style="background:lightblue" | ReleaseGroup-URL
|
| align="center" style="background:green" | OK
|-
| score
| Album-URL
| align="center" style="background:lightblue" | ReleaseGroup-URL
|
| align="center" style="background:green" | OK
|-
| streaming music
| Album-URL
| align="center" style="background:lightgreen" | Release-URL
|
| align="center" style="background:green" | OK
|-
| vgmdb
| Album-URL
| align="center" style="background:lightgreen" | Release-URL
| add to all releases and manual fixing
| align="center" style="background:green" | OK
|}
|}


VGMDb should be release-URL, their entries are the same as Discogs and NGS releases.
===Discussion===
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".
* a covert art for release-group would be useful too, but I guess that could be done by choosing one of links of releases (without requiring an AR) -- [[User:murdos|murdos]] 11:28, 08 December 2008 (UTC)
There's only one album-URL score relationship, but I'd probably treat it the same as lyrics.
* purchase for mail-order, purchase for download, download for free, creative commons licensed download: I presume you mean "all releases (events) of the defunct album", not "all releases of the new release_group". -- [[User:murdos|murdos]] 11:28, 08 December 2008 (UTC)
** Sorry, I didn't notice this comment before. Yes, I mean release events of an album. In the initial import, "release event" == "release", "release (previously album)" == "release group", so that's the same thing. -- [[User:LukasLalinsky|LukasLalinsky]] 09:56, 20 January 2009 (UTC)
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. --[[User:Nikki|Nikki]] 19:17, 19 November 2010 (UTC)

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)