« Return to Thread: Next Generation Database Schema
Re: Next Generation Database Schema
by orion-6
::
Rate this Message:
OK, since you asked for them and I'm currently waiting for everyone else
to awake from their overeating induced slumber...
example 1:
http://avexnet.jp/item/3rdxm/disc/product/AVCD-30828.html
CD title:
3rd X'mas
CD artist:
released as 3rd X'mas featuring dream+長澤奈央+SweetS+星井七瀬+嘉陽愛子+
PARADISE GO!! GO!!+斉藤未知.
Tracks:
1. Giant X'mas～友情にリボン～
2. 希望の歌'05 ～Merry Christmas to you～
3. Giant X'mas～友情にリボン～ (Instrumental)
4. 希望の歌'05 ～Merry Christmas to you～ (Instrumental)
It's a collaboration between the groups dream, SweetS, & PARADISE GO!!
GO!! with the solo artists 長澤奈央, 星井七瀬, 嘉陽愛子, & 斉藤未知. 23
girls total on the song. Current policy depending on your
interpretation would be either randomly select one artist out of that
bunch and add the rest as feat. Otherwise add 3rd X'mas featuring
dream+長澤奈央+SweetS+星井七瀬+嘉陽愛子+PARADISE GO!! GO!!+斉藤未知 or
dream+長澤奈央+SweetS+星井七瀬+嘉陽愛子+PARADISE GO!! GO!!+斉藤未知 or
3rd X'mas and stick all their names in a feat. If any of the latter
three were used then collaborated ARs would have to be added from all
the groups and solo artists to the collaborative artist, although it's
not entirely clear if a single "dream collaborated on 3rd X'mas" AR
should be used for the whole group or if the individual members of dream
should be ARed to the collaboration one.
Also, it's "3rd X'mas" because this is their third year of doing a
Christmas super collaboration. The previous two years had similar but
smaller (only ~12 girls) ones
The label Avex is also confused about how to handle it, with this year's
one under "3rd X'mas featuring dream+長澤奈央+SweetS+星井七瀬+嘉陽愛子+
PARADISE GO!! GO!!+斉藤未知" but last year
http://avexnet.jp/item/dskxx/disc/product/AVCD-30677.html is under
"dream+SweetS+嘉陽愛子" in their artists list and two years ago
http://avexnet.jp/item/dfsxx/disc/product/AVCD-30551.html is under
"dream+フルーツポンチ+SweetS" even though all three have been released
under the "xx X'mas featuring <artists>" formatting.
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
to awake from their overeating induced slumber...
example 1:
http://avexnet.jp/item/3rdxm/disc/product/AVCD-30828.html
CD title:
3rd X'mas
CD artist:
released as 3rd X'mas featuring dream+長澤奈央+SweetS+星井七瀬+嘉陽愛子+
PARADISE GO!! GO!!+斉藤未知.
Tracks:
1. Giant X'mas～友情にリボン～
2. 希望の歌'05 ～Merry Christmas to you～
3. Giant X'mas～友情にリボン～ (Instrumental)
4. 希望の歌'05 ～Merry Christmas to you～ (Instrumental)
It's a collaboration between the groups dream, SweetS, & PARADISE GO!!
GO!! with the solo artists 長澤奈央, 星井七瀬, 嘉陽愛子, & 斉藤未知. 23
girls total on the song. Current policy depending on your
interpretation would be either randomly select one artist out of that
bunch and add the rest as feat. Otherwise add 3rd X'mas featuring
dream+長澤奈央+SweetS+星井七瀬+嘉陽愛子+PARADISE GO!! GO!!+斉藤未知 or
dream+長澤奈央+SweetS+星井七瀬+嘉陽愛子+PARADISE GO!! GO!!+斉藤未知 or
3rd X'mas and stick all their names in a feat. If any of the latter
three were used then collaborated ARs would have to be added from all
the groups and solo artists to the collaborative artist, although it's
not entirely clear if a single "dream collaborated on 3rd X'mas" AR
should be used for the whole group or if the individual members of dream
should be ARed to the collaboration one.
Also, it's "3rd X'mas" because this is their third year of doing a
Christmas super collaboration. The previous two years had similar but
smaller (only ~12 girls) ones
The label Avex is also confused about how to handle it, with this year's
one under "3rd X'mas featuring dream+長澤奈央+SweetS+星井七瀬+嘉陽愛子+
PARADISE GO!! GO!!+斉藤未知" but last year
http://avexnet.jp/item/dskxx/disc/product/AVCD-30677.html is under
"dream+SweetS+嘉陽愛子" in their artists list and two years ago
http://avexnet.jp/item/dfsxx/disc/product/AVCD-30551.html is under
"dream+フルーツポンチ+SweetS" even though all three have been released
under the "xx X'mas featuring <artists>" formatting.
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 |
