Item Based Collaborative Filtering

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Jen (anonymous_at_discussions.microsoft.com)
Date: 06/07/04 

Date: Mon, 7 Jun 2004 10:51:06 -0700

Has anyone used SQL Server to perform Item Based Collaborative Filtering? The concern is the columns per table limitations in computing the initial reference table. The table schema for the computational algorithm is item1...item1000+ columns and customers in the rows. Once the initial computation is in place, SQL Server is fine. I'm thinking about using horizontal partions items1-1000 table1, items1001-2000 table 2 etc...any other approaches, insight, shared experiences are appreciated!

Thanks.
Jen