« Return to Thread: Next Generation Database Schema
Re: Next Generation Database Schema
by orion-6
::
Rate this Message:
Example 4:
One of these came up during the remix restructuring debate
http://lists.musicbrainz.org/pipermail/musicbrainz-style/2005-August/000305.html
and in the months since I've run into a similar second case.
First example is linked in that mail and is a 2 disc album where disc
two contains only a megamix of the first disc into 1 track.
Second similar example would be 野宮真貴's album "PARTY PEOPLE" from
October where track 10 was titled "PARTY PEOPLE MEGA-MIX" and consisted
of a 28 minute megamix of the previous 9 tracks/37 minutes.
Possibly more of an AR issue but definitely something that can't be
represented at the moment - for the first you can say disc 2 is a mix of
disc 1, but for the second you can't say that a disc is a mix of itself.
You need something at the track level to indicate that a track is a
mix of a disc but even then it becomes tricky when the track is on the
disc...
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
One of these came up during the remix restructuring debate
http://lists.musicbrainz.org/pipermail/musicbrainz-style/2005-August/000305.html
and in the months since I've run into a similar second case.
First example is linked in that mail and is a 2 disc album where disc
two contains only a megamix of the first disc into 1 track.
Second similar example would be 野宮真貴's album "PARTY PEOPLE" from
October where track 10 was titled "PARTY PEOPLE MEGA-MIX" and consisted
of a 28 minute megamix of the previous 9 tracks/37 minutes.
Possibly more of an AR issue but definitely something that can't be
represented at the moment - for the first you can say disc 2 is a mix of
disc 1, but for the second you can't say that a disc is a mix of itself.
You need something at the track level to indicate that a track is a
mix of a disc but even then it becomes tricky when the track is on the
disc...
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 |
