« Return to Thread: Next Generation Database Schema
Re: Next Generation Database Schema
by orion-6
::
Rate this Message:
Example 2:
http://www.amazon.co.jp/exec/obidos/ASIN/B000BK6Y1I (linking amazon
because their label's website is entirely flash based abomination.)
CD title:
青春アミーゴ
CD artist:
修二と彰
tracklist:
1．青春アミーゴ
2．カラフル
3．絆
The single is a collaboration between 亀梨和也 from the boyband KAT-TUN
and 山下智久 from the boyband NEWS. 修二と彰 means "修二 & 彰" - the
main song is the theme song for the show "野ブタ。をプロデュース" where
亀梨和也 plays the character 修二 and 山下智久 plays the character 彰.
To make it more fun, tracks 2 and 3 are solo songs - 2 is by 山下智久
and is from the show ドラゴン桜 while 3 is by 亀梨和也 and for the show
ごくせん. Issues would be:
- whether or not to add the collaboration artist or stick it under one
half of the name.
- if adding the collaboration artist, do you stick collaboration ARs
direct to their real names or do you add those ARs to the 修二 and 彰
character names with further "performs as" ARs to their real names.
- clearly indicating that while the single is released and credited
under the double name collaboration 2 of the 3 songs aren't - in other
words, make it clear that while the release artist of the whole single
is 修二と彰 the track artists are 修二と彰, 山下智久, and 亀梨和也
respectively.
Don Redman wrote:
> Hi everybody,
>
> Robert and me have met in Hamburg and are trying to do as much
> preparing work for the summit as possible. We have gathered all the
> excelent ideas for database changes that are flying around on the wiki,
> and it looks like we will come up with a pretty cool proposal for the
> next generation schema. This should solve the major PsITA like SG5 (the
> dreaded FeatruingArtistStyle), the mess around
> DontCreateRelationshipClusters, the cludgy special
> VariousArtistsAlbums, and even a lot of InterNationalization issues.
>
> The full proposal is still in our brains, but we will write it up soon.
> In order to do that, however,
>
> WE NEED YOUR HELP !
>
> We need two kinds of things to strain-test the schema:
>
> * Examples of Albums, Artists and Tracks with all their weird facts
> and connections that the current database schema cannot represent, but
> the new one should.
> * Usage cases: What do you want MusicBrainz to be able to do?
>
> Please give us your examples and usage cases. Reply to this post on
> mb-users with one example/usage case per mail. If you have described
> such an example in the past discussions, please dig that mail out and
> forward it here (e.g Orion had some pretty detailed examples, and the
> current thread on MakingMusicBrainzUsefulForCollectors contains some
> important usage cases).
>
> I will reply to this mail and add an example and a usage case myself so
> that you get an idea of what we need.
>
> Rob and me will meet again on tuesday, it would be great if we had a
> set of at least a dozen of Artists/Albums/Tracks that we could try to
> apply to the new schema.
>
> Thanks in advance,
>
> DonRedman
>
_______________________________________________
MusicBrainz-users mailing list
MusicBrainz-users@...
http://lists.musicbrainz.org/mailman/listinfo/musicbrainz-users
http://www.amazon.co.jp/exec/obidos/ASIN/B000BK6Y1I (linking amazon
because their label's website is entirely flash based abomination.)
CD title:
青春アミーゴ
CD artist:
修二と彰
tracklist:
1．青春アミーゴ
2．カラフル
3．絆
The single is a collaboration between 亀梨和也 from the boyband KAT-TUN
and 山下智久 from the boyband NEWS. 修二と彰 means "修二 & 彰" - the
main song is the theme song for the show "野ブタ。をプロデュース" where
亀梨和也 plays the character 修二 and 山下智久 plays the character 彰.
To make it more fun, tracks 2 and 3 are solo songs - 2 is by 山下智久
and is from the show ドラゴン桜 while 3 is by 亀梨和也 and for the show
ごくせん. Issues would be:
- whether or not to add the collaboration artist or stick it under one
half of the name.
- if adding the collaboration artist, do you stick collaboration ARs
direct to their real names or do you add those ARs to the 修二 and 彰
character names with further "performs as" ARs to their real names.
- clearly indicating that while the single is released and credited
under the double name collaboration 2 of the 3 songs aren't - in other
words, make it clear that while the release artist of the whole single
is 修二と彰 the track artists are 修二と彰, 山下智久, and 亀梨和也
respectively.
Don Redman wrote:
> Hi everybody,
>
> Robert and me have met in Hamburg and are trying to do as much
> preparing work for the summit as possible. We have gathered all the
> excelent ideas for database changes that are flying around on the wiki,
> and it looks like we will come up with a pretty cool proposal for the
> next generation schema. This should solve the major PsITA like SG5 (the
> dreaded FeatruingArtistStyle), the mess around
> DontCreateRelationshipClusters, the cludgy special
> VariousArtistsAlbums, and even a lot of InterNationalization issues.
>
> The full proposal is still in our brains, but we will write it up soon.
> In order to do that, however,
>
> WE NEED YOUR HELP !
>
> We need two kinds of things to strain-test the schema:
>
> * Examples of Albums, Artists and Tracks with all their weird facts
> and connections that the current database schema cannot represent, but
> the new one should.
> * Usage cases: What do you want MusicBrainz to be able to do?
>
> Please give us your examples and usage cases. Reply to this post on
> mb-users with one example/usage case per mail. If you have described
> such an example in the past discussions, please dig that mail out and
> forward it here (e.g Orion had some pretty detailed examples, and the
> current thread on MakingMusicBrainzUsefulForCollectors contains some
> important usage cases).
>
> I will reply to this mail and add an example and a usage case myself so
> that you get an idea of what we need.
>
> Rob and me will meet again on tuesday, it would be great if we had a
> set of at least a dozen of Artists/Albums/Tracks that we could try to
> apply to the new schema.
>
> Thanks in advance,
>
> DonRedman
>
_______________________________________________
MusicBrainz-users mailing list
MusicBrainz-users@...
http://lists.musicbrainz.org/mailman/listinfo/musicbrainz-users
« Return to Thread: Next Generation Database Schema
| Free embeddable forum powered by Nabble | Forum Help |
