History:Next Generation Schema/Release Relationships Conversion: Difference between revisions
From MusicBrainz Wiki
Jump to navigationJump to search
No edit summary |
(add status from actual migration scripts) |
||
Line 13: | Line 13: | ||
! NGS |
! NGS |
||
! Comment |
! Comment |
||
! Status in migration scripts |
|||
|- |
|- |
||
| DJ-mix |
| DJ-mix |
||
Line 18: | Line 19: | ||
| align="center" style="background:lightblue" | ReleaseGroup-ReleaseGroup ? |
| align="center" style="background:lightblue" | ReleaseGroup-ReleaseGroup ? |
||
| |
| |
||
| align="center" style="background:green" | OK |
|||
|- |
|- |
||
| earliest release |
| earliest release |
||
Line 23: | Line 25: | ||
| align="center" style="background:lightgreen" | Release-Release |
| align="center" style="background:lightgreen" | Release-Release |
||
| Link should be dropped |
| Link should be dropped |
||
| align="center" style="background:green" | OK |
|||
|- |
|- |
||
| live performance |
| live performance |
||
| Album-Album |
| Album-Album |
||
| align="center" style="background:lightblue" | ReleaseGroup-ReleaseGroup |
| align="center" style="background:lightblue" | ReleaseGroup-ReleaseGroup |
||
| |
| |
||
| align="center" style="background:green" | OK |
|||
|- |
|- |
||
| remaster |
| remaster |
||
| Album-Album |
| Album-Album |
||
| align="center" style="background:lightgreen" | Release-Release |
| align="center" style="background:lightgreen" | Release-Release |
||
| will need manual fixing |
| will need manual fixing |
||
| align="center" style="background:green" | OK |
|||
|- |
|- |
||
| cover |
| cover |
||
Line 38: | Line 43: | ||
| align="center" style="background:lightblue" | ReleaseGroup-ReleaseGroup |
| align="center" style="background:lightblue" | ReleaseGroup-ReleaseGroup |
||
| |
| |
||
| align="center" style="background:green" | OK |
|||
|- |
|- |
||
| transl-tracklisting |
| transl-tracklisting |
||
Line 43: | Line 49: | ||
| align="center" style="background:lightgreen" | Release-Release |
| align="center" style="background:lightgreen" | Release-Release |
||
| partially automatic using release data |
| partially automatic using release data |
||
| align="center" style="background:green" | OK |
|||
|- |
|- |
||
| remix |
| remix |
||
Line 48: | Line 55: | ||
| align="center" style="background:lightblue" | ReleaseGroup-ReleaseGroup |
| align="center" style="background:lightblue" | ReleaseGroup-ReleaseGroup |
||
| |
| |
||
| align="center" style="background:green" | OK |
|||
|- |
|- |
||
| mashes up |
| mashes up |
||
Line 53: | Line 61: | ||
| align="center" style="background:lightblue" | ReleaseGroup-ReleaseGroup |
| align="center" style="background:lightblue" | ReleaseGroup-ReleaseGroup |
||
| |
| |
||
| align="center" style="background:green" | OK |
|||
|- |
|- |
||
| part of set |
| part of set |
||
Line 58: | Line 67: | ||
| 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 |
|||
|} |
|} |
||
Line 71: | Line 81: | ||
! NGS |
! NGS |
||
! Comment |
! Comment |
||
! Status in migration scripts |
|||
|- |
|- |
||
| compiler |
| compiler |
||
Line 76: | Line 87: | ||
| 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 |
|||
|- |
|- |
||
| mix-DJ |
| mix-DJ |
||
Line 81: | Line 93: | ||
| 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 |
|||
|- |
|- |
||
| performer (instrument or vocal) |
| performer (instrument or vocal) |
||
Line 86: | Line 99: | ||
| 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 |
|||
|- |
|- |
||
| performing orchestra |
| performing orchestra |
||
Line 91: | Line 105: | ||
| 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 |
|||
|- |
|- |
||
| conductor |
| conductor |
||
Line 96: | Line 111: | ||
| 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 |
|||
|- |
|- |
||
| chorus master |
| chorus master |
||
Line 101: | Line 117: | ||
| 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 |
|||
|- |
|- |
||
| tribute |
| tribute |
||
Line 106: | Line 123: | ||
| align="center" style="background:lightblue" | Artist-ReleaseGroup |
| align="center" style="background:lightblue" | Artist-ReleaseGroup |
||
| |
| |
||
| align="center" style="background:green" | OK |
|||
|- |
|- |
||
| remixer |
| remixer |
||
Line 111: | Line 129: | ||
| 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 |
|||
|- |
|- |
||
| samples from artist |
| samples from artist |
||
Line 116: | Line 135: | ||
| align="center" style="background:lightgreen" | Artist-Release ? |
| align="center" style="background:lightgreen" | Artist-Release ? |
||
| |
| |
||
| align="center" style="background:green" | OK |
|||
|- |
|- |
||
| composer |
| composer |
||
| Album-Artist |
| Album-Artist |
||
| align="center" style="background:lightgreen" | Artist-Release ? |
|||
⚫ | |||
| |
| |
||
| align="center" style="background:green" | OK |
|||
|- |
|- |
||
| librettist |
| librettist |
||
| Album-Artist |
| Album-Artist |
||
| align="center" style="background:lightgreen" | Artist-Release ? |
|||
| |
|||
| |
| |
||
| align="center" style="background:green" | OK |
|||
|- |
|- |
||
| arranger, instrumentator & orchestrator |
| arranger, instrumentator & orchestrator |
||
| Album-Artist |
| Album-Artist |
||
| align="center" style="background:lightgreen" | Artist-Release ? |
|||
| |
|||
| |
| |
||
| align="center" style="background:green" | OK |
|||
|- |
|- |
||
| lyricist |
| lyricist |
||
| Album-Artist |
| Album-Artist |
||
| align="center" style="background:lightgreen" | Artist-Release ? |
|||
| |
|||
| |
| |
||
| align="center" style="background:green" | OK |
|||
|- |
|- |
||
| producer |
| producer |
||
Line 141: | Line 165: | ||
| 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 |
|||
|- |
|- |
||
| engineer (and all subtypes) |
| engineer (and all subtypes) |
||
Line 146: | Line 171: | ||
| 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 |
|||
|- |
|- |
||
| legal representation |
| legal representation |
||
Line 151: | Line 177: | ||
| align="center" style="background:lightblue" | Artist-ReleaseGroup |
| align="center" style="background:lightblue" | Artist-ReleaseGroup |
||
| |
| |
||
| align="center" style="background:red" | Artist-Release |
|||
|- |
|- |
||
| booking |
| booking |
||
Line 156: | Line 183: | ||
| align="center" style="background:lightblue" | Artist-ReleaseGroup |
| align="center" style="background:lightblue" | Artist-ReleaseGroup |
||
| |
| |
||
| align="center" style="background:red" | Artist-Release |
|||
|- |
|- |
||
| artists and repertoire |
| artists and repertoire |
||
| Album-Artist |
| Album-Artist |
||
| align="center" style="background:lightgreen" | Artist-Release ? |
|||
⚫ | |||
| |
| |
||
| align="center" style="background:green" | OK |
|||
|- |
|- |
||
| creative direction |
| creative direction |
||
Line 166: | Line 195: | ||
| align="center" style="background:lightblue" | Artist-ReleaseGroup |
| align="center" style="background:lightblue" | Artist-ReleaseGroup |
||
| |
| |
||
| align="center" style="background:red" | Artist-Release |
|||
|- |
|- |
||
| art direction |
| art direction |
||
Line 171: | Line 201: | ||
| 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 |
|||
|- |
|- |
||
| design/illustration |
| design/illustration |
||
Line 176: | Line 207: | ||
| 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 |
|||
|- |
|- |
||
| graphic design |
| graphic design |
||
Line 181: | Line 213: | ||
| 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 |
|||
|- |
|- |
||
| photography |
| photography |
||
Line 186: | Line 219: | ||
| 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 |
|||
|- |
|- |
||
| travel |
| travel |
||
Line 191: | Line 225: | ||
| align="center" style="background:lightblue" | Artist-ReleaseGroup |
| align="center" style="background:lightblue" | Artist-ReleaseGroup |
||
| |
| |
||
| align="center" style="background:red" | Artist-Release |
|||
|- |
|- |
||
| publishing |
| publishing |
||
| Album-Artist |
| Album-Artist |
||
| align="center" style="background:lightgreen" | Artist-Release ? |
|||
| |
|||
| |
| |
||
| align="center" style="background:green" | OK |
|||
|- |
|- |
||
| merchandise |
| merchandise |
||
| Album-Artist |
| Album-Artist |
||
| align="center" style="background:lightgreen" | Artist-Release ? |
|||
| |
|||
| |
| |
||
| align="center" style="background:green" | OK |
|||
|- |
|- |
||
| liner notes |
| liner notes |
||
| Album-Artist |
| Album-Artist |
||
| align="center" style="background:lightgreen" | Artist-Release ? |
|||
| |
|||
| |
| |
||
| align="center" style="background:green" | OK |
|||
|} |
|} |
||
==Album |
==Album-Label== |
||
{| width='80%' |
{| width='80%' |
||
Line 215: | Line 253: | ||
! NGS |
! NGS |
||
! Comment |
! Comment |
||
! Status in migration scripts |
|||
|- |
|- |
||
| publishing |
| publishing |
||
| Album-Label |
| Album-Label |
||
| align="center" style="background:lightgreen" | Label-Release |
|||
| ? |
|||
| |
| |
||
| align="center" style="background:green" | OK |
|||
|} |
|} |
||
==Album |
==Album-Track== |
||
{| width='80%' |
{| width='80%' |
||
Line 229: | Line 269: | ||
! NGS |
! NGS |
||
! Comment |
! Comment |
||
! Status in migration scripts |
|||
|- |
|- |
||
| samples material |
| samples material |
||
| Album-Track |
| Album-Track |
||
| align="center" style="background:lightgreen" | Release-Track |
|||
| ? |
|||
| |
| |
||
| align="center" style="background:green" | OK |
|||
|} |
|} |
||
Line 243: | Line 285: | ||
! NGS |
! NGS |
||
! Comment |
! Comment |
||
! Status in migration scripts |
|||
|- |
|- |
||
| Amazon asin |
| Amazon asin |
||
Line 248: | Line 291: | ||
| align="center" style="background:lightgreen" | Release-URL |
| align="center" style="background:lightgreen" | Release-URL |
||
| partially automatic matching using barcodes |
| partially automatic matching using barcodes |
||
| align="center" style="background:green" | OK |
|||
|- |
|- |
||
| cover art link |
| cover art link |
||
Line 253: | Line 297: | ||
| align="center" style="background:lightgreen" | 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:green" | OK |
|||
|- |
|- |
||
| review |
| review |
||
Line 258: | Line 303: | ||
| align="center" style="background:lightblue" | ReleaseGroup-URL |
| align="center" style="background:lightblue" | ReleaseGroup-URL |
||
| |
| |
||
| align="center" style="background:green" | OK |
|||
|- |
|- |
||
| purchase for mail-order |
| purchase for mail-order |
||
Line 263: | Line 309: | ||
| align="center" style="background:lightgreen" | 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:green" | OK |
|||
|- |
|- |
||
| purchase for download |
| purchase for download |
||
Line 268: | Line 315: | ||
| align="center" style="background:lightgreen" | 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:green" | OK |
|||
|- |
|- |
||
| download for free |
| download for free |
||
Line 273: | Line 321: | ||
| align="center" style="background:lightgreen" | 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:green" | OK |
|||
|- |
|- |
||
| creative commons licensed download |
| creative commons licensed download |
||
Line 278: | Line 327: | ||
| align="center" style="background:lightgreen" | 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:green" | OK |
|||
|- |
|- |
||
| IMDb, ibdb, iobdb |
| IMDb, ibdb, iobdb |
||
Line 283: | Line 333: | ||
| align="center" style="background:lightblue" | ReleaseGroup-URL |
| align="center" style="background:lightblue" | ReleaseGroup-URL |
||
| ok |
| ok |
||
| align="center" style="background:green" | OK |
|||
|- |
|- |
||
| wikipedia |
| wikipedia |
||
Line 288: | Line 339: | ||
| align="center" style="background:lightblue" | ReleaseGroup-URL |
| align="center" style="background:lightblue" | ReleaseGroup-URL |
||
| ok |
| ok |
||
| align="center" style="background:green" | OK |
|||
|- |
|- |
||
| rowspan="2"| discogs |
| rowspan="2"| discogs |
||
Line 293: | Line 345: | ||
| align="center" style="background:lightgreen" | Release-URL for discogs.com/release/XXX urls |
| 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 |
| align="center" style="background:lightblue" | ReleaseGroup-URL for discogs.com/master/XXX urls |
||
| ok |
| ok |
||
| align="center" style="background:green" | OK |
|||
|- |
|- |
||
| musicmoz |
| musicmoz |
||
Line 301: | Line 355: | ||
| align="center" style="background:lightgreen" | 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:red" | KO |
|||
|- |
|- |
||
| lyrics |
| lyrics |
||
Line 306: | Line 361: | ||
| ? |
| ? |
||
| ? |
| ? |
||
| align="center" style="background:red" | KO |
|||
|- |
|- |
||
| IMDb samples |
| IMDb samples |
||
Line 311: | Line 367: | ||
| ? |
| ? |
||
| ? |
| ? |
||
| align="center" style="background:red" | KO |
|||
|- |
|- |
||
| recording studio |
| recording studio |
||
Line 316: | Line 373: | ||
| ? |
| ? |
||
| ? |
| ? |
||
| align="center" style="background:red" | KO |
|||
|- |
|- |
||
| score |
| score |
||
Line 321: | Line 379: | ||
| ? |
| ? |
||
| ? |
| ? |
||
| align="center" style="background:red" | KO |
|||
|- |
|- |
||
| streaming music |
| streaming music |
||
Line 326: | Line 385: | ||
| ? |
| ? |
||
| ? |
| ? |
||
| align="center" style="background:red" | KO |
|||
|- |
|||
| vgmdb |
|||
| Album-URL |
|||
⚫ | |||
⚫ | |||
| align="center" style="background:red" | KO |
|||
|} |
|} |
Revision as of 00:20, 19 November 2010
Legend
To ReleaseGroup | To Release |
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 |
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-ReleaseGroup | Artist-Release | |
booking | Album-Artist | Artist-ReleaseGroup | Artist-Release | |
artists and repertoire | Album-Artist | Artist-Release ? | OK | |
creative direction | Album-Artist | Artist-ReleaseGroup | Artist-Release | |
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 | Artist-Release | |
publishing | Album-Artist | Artist-Release ? | OK | |
merchandise | Album-Artist | Artist-Release ? | OK | |
liner notes | 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 | Release-URL ? | add to all releases and manual fixing | KO |
lyrics | Album-URL | ? | ? | KO |
IMDb samples | Album-URL | ? | ? | KO |
recording studio | Album-URL | ? | ? | KO |
score | Album-URL | ? | ? | KO |
streaming music | Album-URL | ? | ? | KO |
vgmdb | Album-URL | ? | ? | KO |