Re: Possible Future Extensions

--===============0163456232==
Content-Type: multipart/alternative; boundary=f46d043c05f4de9fd20515cbaa67

--f46d043c05f4de9fd20515cbaa67
Content-Type: text/plain; charset=UTF-8

On 11 May 2015 at 11:08, Andre Wiethoff <[email protected]>
wrote:

>
> I have read through it and I even analysed the tables in a current
> snapshot of the Musicbrainz DB.
> I found the following:
>
> All tables called "_rating_raw" are empty!
> But on the other hand, the "_meta" tables does contain information!!
>
> artist_meta: 25215 ratings
> recording_meta: 219029 ratings
> work_meta: 1419 ratings
> label_meta: 602 ratings
> release_group_meta: 65150 ratings
>
> Most probably the "_rating_raw" tables are aggregated and then deleted
> afterwards?
> I assume that the exact editor/rating values are lost forever? This
> would really a pity to loose so many recording rating information
> (groupable to editors/users)...
>
> Would it be possible to not delete the rating information in the future?


Editors can get / set their individual ratings on the site and (I think)
through the webservice. So they aren't 'lost'.
As I understand it, user data like this gets removed from the downloadable
database. I think it's seen as a privacy issue.

--f46d043c05f4de9fd20515cbaa67
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div><br></div><div class=3D"gmail_extra"><br><div class=
=3D"gmail_quote">On 11 May 2015 at 11:08, Andre Wiethoff <span dir=3D"ltr">=
&lt;<a href=3D"mailto:[email protected]" target=3D"_blank">brain=
[email protected]</a>&gt;</span> wrote:<br><blockquote class=3D"gmail=
_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204=
,204);padding-left:1ex"><br>
I have read through it and I even analysed the tables in a current<br>
snapshot of the Musicbrainz DB.<br>
I found the following:<br>
<br>
All tables called &quot;_rating_raw&quot; are empty!<br>
But on the other hand, the &quot;_meta&quot; tables does contain informatio=
n!!<br>
<br>
artist_meta: 25215 ratings<br>
recording_meta: 219029 ratings<br>
work_meta: 1419 ratings<br>
label_meta: 602 ratings<br>
release_group_meta: 65150 ratings<br>
<br>
Most probably the &quot;_rating_raw&quot; tables are aggregated and then de=
leted<br>
afterwards?<br>
I assume that the exact editor/rating values are lost forever? This<br>
would really a pity to loose so many recording rating information<br>
(groupable to editors/users)...<br>
<br>
Would it be possible to not delete the rating information in the future?=C2=
=A0</blockquote><div><br>Editors can get / set their individual ratings on =
the site and (I think) through the webservice. So they aren&#39;t &#39;lost=
&#39;.<br>As I understand it, user data like this gets removed from the dow=
nloadable database. I think it&#39;s seen as a privacy issue.<br>=C2=A0</di=
v></div><br></div></div>

--f46d043c05f4de9fd20515cbaa67--


--===============0163456232==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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