History:Next Generation Schema/Release Relationships Conversion: Difference between revisions
Reosarevok (talk | contribs) m (Next Generation Schema/Release Relationships Conversion moved to History:Next Generation Schema/Release Relationships Conversion) |
|||
(23 intermediate revisions by 5 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) |
|||
* First album release: I'm not sure merging release groups works for boxsets with reedition of original album + bonus tracks. See e.g. [http://musicbrainz.org/release/f22ddf00-f2b3-4a75-9e5d-bf78e3c3bb2d.html this release]. -- [[User:murdos|murdos]] 11:28, 08 December 2008 (UTC) |
|||
** Hmm, interesting case, this will definitely need to be filtered. -- [[User:LukasLalinsky|LukasLalinsky]] 09:56, 20 January 2009 (UTC) |
|||
{| width='80%' |
|||
* Part of set: What should be done when one of the discs has a different release artist ([http://musicbrainz.org/release/ea8aa1c5-460f-48a7-bb94-b898518c3ba3.html example])? -- [[User:murdos|murdos]] 01:44, 28 December 2008 (UTC) |
|||
! AR Type |
|||
** In ngs-playground, I have multiple artists per release, so it would be assigned to "Artist A / Artist B". We will probably have to do some compromise until we implement this. -- [[User:LukasLalinsky|LukasLalinsky]] 09:56, 20 January 2009 (UTC) |
|||
! Now |
|||
! NGS |
|||
! Comment |
|||
! Status in migration scripts |
|||
|- |
|||
| compiler |
|||
| Album-Artist |
|||
| align="center" style="background:lightgreen" | Artist-Release |
|||
| add to all releases and manual fixing? |
|||
| align="center" style="background:green" | OK |
|||
|- |
|||
| mix-DJ |
|||
| 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 |
|||
| align="center" style="background:lightgreen" | Artist-Release |
|||
| add to all releases and manual fixing? |
|||
| align="center" style="background:green" | OK |
|||
|- |
|||
| 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 |
|||
| Album-Artist |
|||
| align="center" style="background:lightgreen" | Artist-Release |
|||
| add to all releases and manual fixing? |
|||
| align="center" style="background:green" | OK |
|||
|- |
|||
| chorus master |
|||
| Album-Artist |
|||
| align="center" style="background:lightgreen" | Artist-Release |
|||
| add to all releases and manual fixing? |
|||
| align="center" style="background:green" | OK |
|||
|- |
|||
| tribute |
|||
| Album-Artist |
|||
| align="center" style="background:lightblue" | Artist-ReleaseGroup |
|||
| |
|||
| align="center" style="background:green" | OK |
|||
|- |
|||
| remixer |
|||
| 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 |
|||
| align="center" style="background:lightgreen" | Artist-Release |
|||
| |
|||
| align="center" style="background:green" | OK |
|||
|- |
|||
| composer |
|||
| Album-Artist |
|||
| align="center" style="background:lightgreen" | Artist-Release |
|||
| |
|||
| align="center" style="background:green" | OK |
|||
|- |
|||
| librettist |
|||
| Album-Artist |
|||
| align="center" style="background:lightgreen" | Artist-Release |
|||
| |
|||
| align="center" style="background:green" | OK |
|||
|- |
|||
| arranger, instrumentator & orchestrator |
|||
| Album-Artist |
|||
| align="center" style="background:lightgreen" | Artist-Release |
|||
| |
|||
| align="center" style="background:green" | OK |
|||
|- |
|||
| lyricist |
|||
| Album-Artist |
|||
| align="center" style="background:lightgreen" | Artist-Release |
|||
| |
|||
| align="center" style="background:green" | OK |
|||
|- |
|||
| producer |
|||
| 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 |
|||
| align="center" style="background:lightgreen" | Artist-Release |
|||
| add to all releases and manual fixing? |
|||
| align="center" style="background:green" | OK |
|||
|- |
|||
| legal representation |
|||
| Album-Artist |
|||
| align="center" style="background:lightgreen" | Artist-Release |
|||
| |
|||
| align="center" style="background:green" | OK |
|||
|- |
|||
| booking |
|||
| Album-Artist |
|||
| align="center" style="background:lightgreen" | Artist-Release |
|||
| |
|||
| align="center" style="background:green" | OK |
|||
|- |
|||
| artists and repertoire |
|||
| Album-Artist |
|||
| align="center" style="background:lightblue" | Artist-ReleaseGroup |
|||
| |
|||
| align="center" style="background:green" | OK |
|||
|- |
|||
| creative direction |
|||
| Album-Artist |
|||
| align="center" style="background:lightblue" | Artist-ReleaseGroup |
|||
| |
|||
| align="center" style="background:green" | OK |
|||
|- |
|||
| art direction |
|||
| 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 |
|||
| align="center" style="background:lightgreen" | Artist-Release |
|||
| add to all releases and manual fixing? |
|||
| align="center" style="background:green" | OK |
|||
|- |
|||
| graphic design |
|||
| Album-Artist |
|||
| align="center" style="background:lightgreen" | Artist-Release |
|||
| add to all releases and manual fixing? |
|||
| align="center" style="background:green" | OK |
|||
|- |
|||
| photography |
|||
| Album-Artist |
|||
| align="center" style="background:lightgreen" | Artist-Release |
|||
| add to all releases and manual fixing? |
|||
| align="center" style="background:green" | OK |
|||
|- |
|||
| travel |
|||
| Album-Artist |
|||
| align="center" style="background:lightblue" | Artist-ReleaseGroup |
|||
| |
|||
| align="center" style="background:green" | OK |
|||
|- |
|||
| publishing |
|||
| Album-Artist |
|||
| align="center" style="background:lightgreen" | Artist-Release |
|||
| |
|||
| align="center" style="background:green" | OK |
|||
|- |
|||
| merchandise |
|||
| Album-Artist |
|||
| align="center" style="background:lightgreen" | Artist-Release |
|||
| |
|||
| align="center" style="background:green" | OK |
|||
|- |
|||
| 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%' |
|||
TODO |
|||
! AR Type |
|||
! Now |
|||
==Album--Label== |
|||
! NGS |
|||
! Comment |
|||
{| border="1" |
|||
! 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 |
|||
| 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) |
|||
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)