History:Next Generation Schema/Release Relationships Conversion: Difference between revisions
(→Album--URL: add a note about discogs.com/master/XXX URLs) |
Reosarevok (talk | contribs) m (Next Generation Schema/Release Relationships Conversion moved to History:Next Generation Schema/Release Relationships Conversion) |
||
(17 intermediate revisions by 4 users not shown) | |||
Line 1: | Line 1: | ||
== |
== 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 |
|||
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) |
|||
! NGS |
|||
! Comment |
|||
{| border="1" |
|||
! 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) |
| 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 |
| 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 |
| samples from artist |
||
| Album-Artist |
|||
| align="center" style="background:lightgreen" | Artist-Release |
|||
| |
|||
| align="center" style="background:green" | OK |
|||
|- |
|- |
||
| composer |
| composer |
||
| Album-Artist |
|||
| align="center" style="background:lightgreen" | Artist-Release |
|||
| |
|||
| align="center" style="background:green" | OK |
|||
|- |
|- |
||
| librettist |
| librettist |
||
| Album-Artist |
|||
| align="center" style="background:lightgreen" | Artist-Release |
|||
| |
|||
| align="center" style="background:green" | OK |
|||
|- |
|- |
||
| arranger, instrumentator & orchestrator |
| arranger, instrumentator & orchestrator |
||
| Album-Artist |
|||
| align="center" style="background:lightgreen" | Artist-Release |
|||
| |
|||
| align="center" style="background:green" | OK |
|||
|- |
|- |
||
| lyricist |
| 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) |
| 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 |
| 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 |
| artists and repertoire |
||
| Album-Artist |
|||
| align="center" style="background:lightblue" | Artist-ReleaseGroup |
|||
| |
|||
| align="center" style="background:green" | OK |
|||
|- |
|- |
||
| creative direction |
| 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 |
| 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 |
| publishing |
||
| Album-Artist |
|||
| align="center" style="background:lightgreen" | Artist-Release |
|||
| |
|||
| align="center" style="background:green" | OK |
|||
|- |
|- |
||
| merchandise |
| merchandise |
||
| Album-Artist |
|||
| align="center" style="background:lightgreen" | Artist-Release |
|||
| |
|||
| align="center" style="background:green" | OK |
|||
|- |
|- |
||
| liner notes |
| 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 |
==Album-Label== |
||
{| |
{| width='80%' |
||
! AR Type |
|||
! Now |
|||
! NGS |
|||
! Comment |
|||
! Status in migration scripts |
|||
|- |
|- |
||
| publishing |
| publishing |
||
| Album-Label |
|||
| align="center" style="background:lightgreen" | Label-Release |
|||
| |
|||
| align="center" style="background:green" | OK |
|||
|} |
|} |
||
==Album |
==Album-Track== |
||
{| |
{| width='80%' |
||
! AR Type |
|||
! Now |
|||
! NGS |
|||
! Comment |
|||
! Status in migration scripts |
|||
|- |
|- |
||
| samples material |
| samples material |
||
| Album-Track |
|||
| align="center" style="background:lightgreen" | Release-Track |
|||
| |
|||
| align="center" style="background:green" | OK |
|||
|} |
|} |
||
==Album |
==Album-URL== |
||
{| |
{| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| IMDb, ibdb, iobdb |
||
| Album-URL |
|||
| align="center" style="background:lightblue" | ReleaseGroup-URL |
|||
| ok |
|||
| align="center" style="background:green" | OK |
|||
|- |
|- |
||
| wikipedia |
| wikipedia |
||
| Album-URL |
|||
| align="center" style="background:lightblue" | ReleaseGroup-URL |
|||
| ok |
|||
| align="center" style="background:green" | OK |
|||
|- |
|- |
||
| rowspan="2"| discogs |
| rowspan="2"| discogs |
||
| rowspan="2"| |
| rowspan="2"| Album-URL |
||
| |
| align="center" style="background:lightgreen" | Release-URL for discogs.com/release/XXX urls |
||
| partially automatic matching using label/cat# |
| 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 |
||
| ok |
| ok |
||
| align="center" style="background:green" | OK |
|||
|- |
|- |
||
| musicmoz |
|||
| musicmoz || album--url || release--url ? || add to all releases and manual fixing |
|||
| 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. |
|||
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. --[[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)