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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Book on collaborative filtering?

Author  Topic 

aiken
Aged Yak Warrior

525 Posts

Posted - 2004-07-21 : 19:23:24
Hi, everyone. I need to get more educated about collaborative filtering and how to efficiently implement it in SQL server, using analysis services and or homegrown t-sql.

Can someone recommend a book? Are there any that are good for both explaining the basics, theory, and math, as well as implementation on SQL server?

Thanks
-b

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2004-07-21 : 20:51:05
Well, I didn't know what this was so I googled and wikipediad it to find out. Unfortunately, i don't have any first hand experience with CF, but i thought I'd pass on the links I found.

Since I didn't even know what collaborative filtering was (had an idea, turns out I was dead on). Anyway, wikipedia pointed me to this site with many links to research papers and such on the subject. unfortunately I didn't see anything detailing a SQL implementation.


http://pespmc1.vub.ac.be/COLLFILT.html


also check the wikipedia artcle here http://en.wikipedia.org/wiki/Collaborative_filtering and click the links to the non-commercial implementations of collaborative filtering. These sites then link you to more info on algorithms used and their implementation. Interesting stuff.


-ec
Go to Top of Page

aiken
Aged Yak Warrior

525 Posts

Posted - 2004-07-23 : 19:17:03
Thanks for the links!

I've got some hacked together implementations of collaborative filtering going, and they are working well in my application.

What I'm looking for is more of a SQL-server centric education. For instance, I believe the the decision trees OLAP algorithm can be used for CF; what I don't know is the relative merits of doing so versus a t-sql based implementation. And, I expect that there are CF specific issues with regards to indexing and query design.

Thanks again for the links; they'll definitely help in my hacking, but I'd love to hear if anyone knows a more formal reference for CF on SQL Server (I looked at amazon and stuff before posting, with no luck).

Cheers
-b
Go to Top of Page
   

- Advertisement -