PA database question

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   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?

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
russellk Members Profile Send Private Message Find Members Posts Add to Buddy List Reviewer page Prog Reviewer Joined: February 28 2005 Location: New Zealand Status: Offline Points: 782	Topic: PA database question 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?

Chris S Members Profile Send Private Message Find Members Posts Add to Buddy List Reviewer page Special Collaborator Honorary Collaborator Joined: June 09 2004 Location: Front Range Status: Offline Points: 7028	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]

russellk Members Profile Send Private Message Find Members Posts Add to Buddy List Reviewer page Prog Reviewer Joined: February 28 2005 Location: New Zealand Status: Offline Points: 782	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.

Easy Livin Members Profile Send Private Message Find Members Posts Add to Buddy List Reviewer page Special Collaborator Honorary Collaborator / Retired Admin Joined: February 21 2004 Location: Scotland Status: Offline Points: 15585	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 M@x with your exact requirements. He should be able to run a few queries for you and give you details.

russellk Members Profile Send Private Message Find Members Posts Add to Buddy List Reviewer page Prog Reviewer Joined: February 28 2005 Location: New Zealand Status: Offline Points: 782	Posted: August 29 2008 at 05:04
	Thank you, I'll do that.