Re: Next Generation Database Schema

On Fri, 25 Nov 2005 00:46:00 +0100, Orion wrote:

> OK, since you asked for them and I'm currently waiting for everyone else  
> to awake from their overeating induced slumber...

Thanks a lot. I am just asking some questions for clarification and adding  
qotes to your text, because all those japanese characters make me dizzy  
:-). Please review the quotes.

>>
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)
<<

Are these just the track titles or are these an artist and a track title?  
Eg. for track one is it:
Track title: "Giant X'mas～友情にリボン～"
or
Track artist: "Giant X'mas"
Track title: "～友情にリボン～"
or even
Track artist: "Giant X'mas"
Track title: "友情にリボン" (tildes removed, just decoration)

>>
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.
<<

Hmm, forget feat.
If we had a system that could show an arbitrary string as the album title  
and still link the album to a lot of different artists, what would _you_  
think is the correct 'artist' this should be attributed to?  And under  
which artist(s) should the album be listed?

I suppose it should be listed on the discographies of all these: "dream",  
"SweetS", & "PARADISE GO!! GO!!", "長澤奈央", "星井七瀬", "嘉陽愛子", and  
"斉藤未知".  In all cases it should still retain the correct attributed  
artist "3rd X'mas featuring dream+長澤奈央+SweetS+星井七瀬+嘉陽愛子
+PARADISE GO!! GO!!+斉藤未知".

>>
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.
<<

Does this mean this project has become sort of an institution? But IIUC it  
has no 'name' of its own. Still, I have to ask: Would it make sense to  
create a collaboration like "xx X'mas" and list all albums there? I  
suppose not or only additionally to relating each specific album to all  
the artists that took part on in.

   DonRedman

--
Words that are written in CamelCase refer to WikiPages:
Visit http://wiki.musicbrainz.org/ the best MusicBrainz documentation  
around! :-)
_______________________________________________
MusicBrainz-users mailing list
MusicBrainz-users@...
http://lists.musicbrainz.org/mailman/listinfo/musicbrainz-users