I Have A Question For You......? - PA database question

Print Page | Close Window

PA database question

Printed From: Progarchives.com
Category: Topics not related to music
Forum Name: I Have A Question For You......?
Forum Description: Ask any question on any subject: if the admin team or any of our members can answer it we will.
URL: http://www.progarchives.com/forum/forum_posts.asp?TID=51370
Printed Date: February 26 2025 at 07:34
Software Version: Web Wiz Forums 11.01 - http://www.webwizforums.com

Topic: PA database question

Posted By: russellk
Subject: PA database question
Date Posted: August 28 2008 at 16:10

I'm working on a blog assessing the shape of prog as defined by PA. I'm very interested to analyse statistical details related to the number of albums per sub-genre, and the number of reviews per album per sub-genre. I want to answer the question: 'What have PA users, by their review activity, identified as the music of most interest/relevance to them on this site?'

I will understand if this is a) deemed commercially sensitive, or b) impossible/too difficult to extract. But if the information is easily retrieved, I'd rather not have to go through the database and record the number of reviews for each of 18,652 albums.

Can anyone help? Or should I leave this one alone?

Replies:

Posted By: Chris S
Date Posted: August 28 2008 at 16:16

Good questions.....at the very worst you could take a slice of say the top 100 most prolific reviewers and calculate via the pie charts? Still time consuming i know, hopefully there is some easy stas available...

-------------
<font color=Brown>Music - The Sound Librarian

...As I venture through the slipstream, between the viaducts in your dreams...[/COLOR]

Posted By: russellk
Date Posted: August 28 2008 at 16:18

I have a suspicion that the top reviewers cast their nets somewhat wider than the average user of the site, Chris. But what you suggest would be an excellent contrast to the broader statistics, and is well worth doing.

Posted By: Easy Livin
Date Posted: August 29 2008 at 04:54

I don't think any of what you are looking for would be considered sensitive. There is though no easy way to extract it.

I'd suggest you sent a PM to mailto:M@x - M@x with your exact requirements. He should be able to run a few queries for you and give you details.

Posted By: russellk
Date Posted: August 29 2008 at 05:04

Thank you, I'll do that.