My Other Websites
Pazz N Jop Product Report Spec
Chuck Eddy suggested reviving the Pazz & Jop Product Report, a short-lived (1976-77) feature Robert Christgau ran at the Village Voice. Christgau recruited ten rock critics (Lester Bangs, Ken Emerson, Stephen Holden, Greil Marcus, Perry Meisel, Jim Miller, John Morthland, Wayne Robins, Susan Shapiro, and Ed Ward) and had them recommend up to ten records per month, assigning each points from 1-10 (except 4, 6, and 9). He also let them pick on up to four records per month, assigning them demerits of -1 through -4. Each month he tallied up the points, subtracted the demerits, and published a top-10 ranking of current records (defined as records that got a new vote during the month, although the totals were cumulative). An example of the published results is here.
Christgau's poll was intended to provide a carefully calibrated cross section of expert critical opinion. Chuck suggested that the poll be conducted by the group of (mostly) amateurs who coalesced in the comments section of Christgau's Expert Witness blog, and who continue to share news and opinions in the Facebook "Expert Witness" group: the results should be slightly more catholic than Christgau's own views but strongly oriented in that direction. (Since Christgau is no longer writing his blog, his grades have remained private aside from a few hints, so part of the utility of such a project would be to synthesize Christgau-like consumer guidance.)
Here's a quick design for such a system.
Table album: describes a virtual album, subject to rating. Multiple releases are collapsed into a single entry.
Table tag: An attribute linked to an album. One probable use for this would be to implement a genre system.
Table atag: Album-tag tuple joins.
Table user: An entry for each voter recognized by system.
Table vote: Vote table: