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--Label==
==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--Track==
==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