Difference between revisions of "History:Next Generation Schema/Release Relationships Conversion"

From MusicBrainz Wiki
(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