History:Next Generation Schema/Release Relationships Conversion: Difference between revisions
(→Album-Artist: writer) |
Reosarevok (talk | contribs) m (Next Generation Schema/Release Relationships Conversion moved to History:Next Generation Schema/Release Relationships Conversion) |
||
(5 intermediate revisions by 2 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 87: | Line 87: | ||
| align="center" style="background:lightgreen" | Release-Release |
| align="center" style="background:lightgreen" | Release-Release |
||
| |
| |
||
| align="center" | |
| align="center" style="background:green" | OK |
||
|} |
|} |
||
Line 103: | 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 109: | 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 115: | 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 121: | 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 127: | 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 133: | 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 145: | 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 151: | 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 163: | 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 169: | 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 175: | 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 181: | 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 187: | 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 193: | 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 213: | 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 223: | 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 229: | 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 235: | 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 243: | 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 253: | 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 259: | 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 |
| align="center" style="background:green" | OK |
||
Line 265: | Line 265: | ||
| writer |
| writer |
||
| Album-Artist |
| Album-Artist |
||
| align="center" style="background:lightgreen" | Artist-Release |
| align="center" style="background:lightgreen" | Artist-Release |
||
| |
| |
||
| align="center" | |
| align="center" style="background:green" | OK |
||
|} |
|} |
||
Line 377: | 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)