Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mike123
Master Smack Fu Yak Hacker
1462 Posts |
 Posted - 2008-10-21 : 06:03:40
|
| Hi,I have a couple tables as posted below. Basically users are paired up, and then voted on as a "winner" for each candidate.I am trying to see what advanced ranking mathematical systems are out there, to try and see if I can come up with any good ranking systems to integrate. Is there anything out there that exists already and would be recommended ? I have been googling for a bit and its quite complex.found this link for EUFA rankings, its interesting, and similar, but dont think it will work .. posted mainly because I thought was interesting and someone might get a kick out of it[url]http://www.xs4all.nl/~kassiesa/bert/uefa/calc.html[/url]The best thing Ive found so far is this link, there are a few methods inside here as well.[url]http://en.wikipedia.org/wiki/Condorcet_method[/url]However its pretty advanced, and doesnt include any SQL examples :)Anyone come across anything like this before?Thanks once again for any suggestions!mike123CREATE TABLE [dbo].[tblBattles]( [battleID] [int] IDENTITY(1,1) NOT NULL, [challenger_userID] [int] NOT NULL, [opponent_userID] [int] NOT NULL, [approvedBy_opponent] [tinyint] NOT NULL, [battleRequestDate] [datetime] NOT NULL, [battleApprovedDate] [datetime] NULL) ON [PRIMARY]CREATE TABLE [dbo].[tblBattle_Votes]( [voteID] [int] IDENTITY(1,1) NOT NULL, [battleID] [int] NOT NULL, [voter_userID] [int] NOT NULL, [winner_userID] [int] NOT NULL, [voteDate] [datetime] NOT NULL) ON [PRIMARY] |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
mike123
Master Smack Fu Yak Hacker
1462 Posts |
Posted - 2008-10-24 : 17:31:08
|
quote:
Originally posted by Peso
Maybe a Bayesian estimate is enough?http://www.imdb.com/chart/top
E 12°55'05.63"N 56°04'39.26"
Hey Peso,Thanks for this link, this looks like a great formula and will definately be using it and see how it does, but for something slight different.For this particular situation above it wont work, as we don't actually have ratings, we just have 'winners'.thanks!mike123 |
 |
|
|
|
|
|
|
|
advanced ranking calculations(condorcet method?)