Re: Item Based Collaborative Filtering

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Peter Kim [MS] (peterkim_at_online.microsoft.com)
Date: 06/07/04

  • Next message: Jen: "Thank you Re: Item Based Collaborative Filtering"
    Date: Mon, 7 Jun 2004 11:27:23 -0700
    
    

    In SQL Server 2000 data mining, we support a nested table column to model
    exactly what you just mentioned. Collaborative filtering on tens of
    thousands of items are just no problem at all. The FAQ in
    (http://groups.msn.com/AnalysisServicesDataMining/faq.msnw) has entries to
    show how to use a nested table columns (in model definition and prediction
    input) and how to perform a collaborative filtering task using
    Microsoft_Decision_Trees.

    -- 
    Peter Kim
    This posting is provided "AS IS" with no warranties, and confers no rights.
    "Jen" <anonymous@discussions.microsoft.com> wrote in message 
    news:EA1AB5A5-D902-4F40-B7D0-AE16C7E896E1@microsoft.com...
    >
    > 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 
    

  • Next message: Jen: "Thank you Re: Item Based Collaborative Filtering"

    Relevant Pages

    • Re: stored procedure question
      ... Erland, ... regarding computing and large insert be done directly in the database. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
      (comp.databases.ms-sqlserver)
    • Left outer join bug on computed scalar columns?
      ... the query plan for SQL Server picks an incorrect path for computing a scalar ... The scalar column value is computed too late in the plan. ... results of the COMPUTE_SCALAR column should be and then see what SQL Server ...
      (microsoft.public.sqlserver.programming)
    • Re: Can anyone help with waittype 0x0044?
      ... computing its value from another column in the table. ... will you some progress information. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
      (comp.databases.ms-sqlserver)
    • Re: stored procedure question
      ... regarding computing and large insert be done directly in the database. ... The root problem is that SQL Server does not give any progress information. ... Books Online for SQL Server 2005 at ...
      (comp.databases.ms-sqlserver)