History:Next Generation Schema/Release Relationships Conversion: Difference between revisions
From MusicBrainz Wiki
Jump to navigationJump to search
No edit summary |
Reosarevok (talk | contribs) m (Next Generation Schema/Release Relationships Conversion moved to History:Next Generation Schema/Release Relationships Conversion) |
||
| (9 intermediate revisions by 3 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 75: | Line 75: | ||
| align="center" style="background:lightgreen" | Release-Release |
| 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. |
| 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 |
| align="center" style="background:green" | OK |
||
|} |
|} |
||
==Album-Artist== |
==Album-Artist== |
||
| Line 93: | 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 99: | 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 105: | 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 111: | 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 117: | 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 123: | 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 135: | 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 141: | 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 153: | 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 159: | 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 165: | 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 171: | 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 177: | 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 183: | Line 193: | ||
| legal representation |
| legal representation |
||
| Album-Artist |
| Album-Artist |
||
| align="center" style="background: |
| align="center" style="background:lightgreen" | Artist-Release |
||
| |
| |
||
| align="center" style="background: |
| align="center" style="background:green" | OK |
||
|- |
|- |
||
| booking |
| booking |
||
| Album-Artist |
| Album-Artist |
||
| align="center" style="background: |
| align="center" style="background:lightgreen" | Artist-Release |
||
| |
| |
||
| align="center" style="background: |
| align="center" style="background:green" | OK |
||
|- |
|- |
||
| artists and repertoire |
| artists and repertoire |
||
| Album-Artist |
| Album-Artist |
||
| align="center" style="background: |
| align="center" style="background:lightblue" | Artist-ReleaseGroup |
||
| |
| |
||
| align="center" style="background:green" | OK |
| align="center" style="background:green" | OK |
||
| Line 203: | Line 213: | ||
| align="center" style="background:lightblue" | Artist-ReleaseGroup |
| align="center" style="background:lightblue" | Artist-ReleaseGroup |
||
| |
| |
||
| align="center" style="background: |
| 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 213: | 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 219: | 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 225: | 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 233: | Line 243: | ||
| align="center" style="background:lightblue" | Artist-ReleaseGroup |
| align="center" style="background:lightblue" | Artist-ReleaseGroup |
||
| |
| |
||
| align="center" style="background: |
| 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 243: | 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 249: | 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 361: | Line 377: | ||
| musicmoz |
| musicmoz |
||
| Album-URL |
| Album-URL |
||
| align="center" style="background: |
| 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: |
| 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: |
| 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: |
| align="center" style="background:green" | OK |
||
|- |
|- |
||
| recording studio |
| recording studio |
||
| Album-URL |
| Album-URL |
||
| align="center" style="background:lightblue" | ReleaseGroup-URL |
|||
| Release-URL? |
|||
| |
| |
||
| align="center" style="background: |
| 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: |
| align="center" style="background:green" | OK |
||
|- |
|- |
||
| streaming music |
| streaming music |
||
| Album-URL |
| Album-URL |
||
| align="center" style="background:lightgreen" | Release-URL |
|||
| ReleaseGroup-URL? |
|||
| |
| |
||
| align="center" style="background: |
| 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: |
| 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)
