Yes and yes. No. That is...

We have to track every single vote otherwise there would be no way for the system to work the way it does (preventing you from voting on the same node twice, etc.). Each vote record must record who voted and what node was voted on. They also record how you voted (++ or --) and when. After a long run of amazing abuses of the voting system, we added the node author (the "votee") to these records and added a couple of indices. Now it is somewhat fast and easy to review how someone has been voting or what votes have recently been received by someone (or to summarize information such as what percentage of recent votes were downvotes or what percentage of recent downvotes were cast by the top N down-voters, etc.). We had to do this to get the abuses under control. I still do this occasionally when I see complaints, in part to try to figure out how to improve things.

Each node has a 'reputation' that is the sum of ++ votes minus the sum of -- votes and a 'votescast' that is the sum of all votes. From these two values it is easy to compute the number of just ++ votes and the number of just -- votes. 

rep = up - down;           cast = up + down
up = rep + down;           down = cast - up
up = rep + cast - up;      down = cast - rep - down
2*up = rep + cast;         2*down = cast - rep
up = ( rep + cast ) / 2;   down = ( cast - rep ) / 2

[download]

- tye        

In reply to Re^4: Possible changes to Voting/XP (schema) by tye
in thread Possible changes to Voting/XP by theonetwo

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.