Re: [mb-users] where to find ratings in db dump

Thank you very much Ian and Calvin!
So I was looking for ratings of users of tracks (explicit feedback) as I am writing my masters thesis about music recommendation and the million song contest is only playcounts (implicit feedback), so I was hopeful when I read "user submitted annotations, tags and ratings" - but I understand that this is not part of what you release. 
Are you aware of anything like this out there? (There is the yahoo kdd data but they don't include titles of anything, just IDs)
Thank you very much,
Marcel


Ian McEwen <[email protected]> schrieb am 19:24 Freitag, 13.Juni 2014:
 


On Fri, Jun 13, 2014 at 01:18:08PM -0400, Calvin Walton wrote:
> On Fri, 2014-06-13 at 01:22 +0100, Marcel Ackermann wrote:
> > Hi,
> >
> > I've downloaded and extracted the latest mbdump.tar.bz2, derived,
> > edit, editor, stats - but wasn't able to locate the ratings of (track,
> > album, artist).
> > In which archive and which file within this archive do I find those?
>
> I believe that the recording, release group, and artist ratings overall
> ratings can be found in the "recording_meta", "release_group_meta" and
> "artist_meta" tables, which should be included in the dump - these
> tables are probably in the -derived tar file along with other CC-NC
> licensed data.
>
> Note that we don't store track ratings, and 'album' is just a release
> type. Depending on what you want to use the data for, either of the
> "release" or "release group" ratings might be appropriate.
>

Releases don't have ratings, only release groups
(http://tickets.musicbrainz.org/browse/MBS-4816)

Otherwise all of this is correct.

> The rating data in MusicBrainz itself is, of course, notoriously
> incomplete. You have to be a registered editor to use ratings, and not
> many active editors do anything with them.
>
> I'm not sure about whether we include per-user information about ratings
> in the dumps - this is probably stripped out for privacy issues.
>

Yes; the *_rating_raw tables are not included in data dumps, only the
aggregate information in the *_meta tables, as noted above.


> --
> Calvin Walton <[email protected]>
>
>
> _______________________________________________
> MusicBrainz-users mailing list
> [email protected]
> http://lists.musicbrainz.org/mailman/listinfo/musicbrainz-users

_______________________________________________
MusicBrainz-users mailing list
[email protected]
http://lists.musicbrainz.org/mailman/listinfo/musicbrainz-users

_______________________________________________
MusicBrainz-users mailing list
[email protected]
http://lists.musicbrainz.org/mailman/listinfo/musicbrainz-users