Determining the popularity of a video with ratings and views

Posted by user295825 on Stack Overflow See other posts from Stack Overflow or by user295825
Published on 2010-03-17T16:27:11Z Indexed on 2010/03/17 16:31 UTC
Read the original article Hit count: 247

Filed under:

voting

|

statistics

|

mysql

|

postgresql

I am about to embark on a new project - a video website. Users will be able to register, and vote on videos by clicking "like" or "dislike", or something to that effect. In any event, it will be a 2-option voting system, not a 5-star system.

Every X number of days, I will be generating a "chart" of the most popular videos. So my question is: how should I determine the popularity of a given video?

If I went the route of tallying up the videos with the most views, this could have the effect of exceptionally bad videos making it to the of the charts (just because they're so bad).

If I go the route of a scoring system based on the amount of "like" and "dislike" votes (eg. 100 like votes, and 50 dislike votes equals a score of 2), videos with few views could appear on the top of the charts.

So, what I need to do is a combination of the two. Barring, of course, spammy views and votes.

What's your guys' thoughts on the subject?

© Stack Overflow or respective owner

Related posts about voting

Drupal - building a photo gallery for voting with Fivestar voting module.

as seen on Stack Overflow - Search for 'Stack Overflow'
How would I be able to use the Drupal Fivestar voting module for voting on photos in a gallery without each photo being a separate node. I've used the Fivestar module for voting on seperate nodes, but making each photo in a gallery a node doeasn't seem logical. thanks >>> More
Twitter API Voting System

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
So I blatantly got this idea from the MIX 10 event. At MIX they held a rockband talent competition type thing (I’m not quite sure of all the details). But the interesting part for me is how they collected votes. They used Twitter (what else, when you have a few thousand geeks available to you)… >>> More
Windows Azure Service Bus Scatter-Gather Implementation

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
One of the more challenging enterprise integration patterns that developers may wish to implement is the Scatter-Gather pattern. In this article I will show the basic implementation of a scatter-gather pattern using the topic-subscription model of the windows azure service bus. I’ll be using the implementation… >>> More
??11.2 RAC??OCR?Votedisk??ASM Diskgroup?????

as seen on Oracle Blogs - Search for 'Oracle Blogs'
????????Oracle Allstarts??????????ocr?votedisk?ASM diskgroup??11gR2 RAC cluster?????????,????«?11gR2 RAC???ASM DISK Path????»??????,??????CRS??????11.2??ASM???????, ????????????”crsctl start crs -excl -nocrs “; ?????????,??ASM????ocr?????votedisk?????,??11.2????ocr?votedisk???ASM?,?ASM… >>> More
??11.2 RAC??OCR?Votedisk??ASM Diskgroup?????

as seen on Oracle Blogs - Search for 'Oracle Blogs'
????????Oracle Allstarts??????????ocr?votedisk?ASM diskgroup??11gR2 RAC cluster?????????,????«?11gR2 RAC???ASM DISK Path????»??????,??????CRS??????11.2??ASM???????, ????????????”crsctl start crs -excl -nocrs “; ?????????,??ASM????ocr?????votedisk?????,??11.2????ocr?votedisk???ASM?,?ASM… >>> More

Related posts about statistics

SQL SERVER – When are Statistics Updated – What triggers Statistics to Update

as seen on SQL Authority - Search for 'SQL Authority'
If you are an SQL Server Consultant/Trainer involved with Performance Tuning and Query Optimization, I am sure you have faced the following questions many times. When is statistics updated? What is the interval of Statistics update? What is the algorithm behind update statistics? These are the puzzling… >>> More
SQL SERVER When are Statistics Updated What triggers Statistics to Update

as seen on Dot net Slackers - Search for 'Dot net Slackers'
If you are an SQL Server Consultant/Trainer involved with Performance Tuning and Query Optimization, I am sure you have faced the following questions many times.When is statistics updated? What is the interval of Statistics update? What is the algorithm behind update statistics? These are the puzzling… >>> More
New Whitepaper: Best Practices for Gathering EBS Database Statistics

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Most Oracle Applications DBAs and E-Business Suite users understand the importance of accurate database statistics. Missing, stale or skewed statistics can adversely affect performance. Oracle E-Business Suite statistics should only be gathered using FND_STATS or the Gather Statistics… >>> More
Incremental Statistics Maintenance – what statistics will be gathered after DML occurs on the table?

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Incremental statistics maintenance was introduced in Oracle Database 11g to improve the performance of gathering statistics on large partitioned table. When incremental statistics maintenance is enabled for a partitioned table, oracle accurately generated global level statistics by aggregating… >>> More
Lies, damned lies, and statistics Part 2

as seen on Oracle Blogs - Search for 'Oracle Blogs'
There was huge interest in our OOW session last year on Managing Optimizer Statistics. It seems statistics and the maintenance of them continues to baffle people. In order to help dispel the mysteries surround statistics management we have created a two part white paper series on Optimizer statistics… >>> More