SQL/Model for Customers Who Bought This Item Also Bought

Rails
1

Hello.

We have a decent size Rails application that has worked great for us
using ActiveRecord with minimal custom SQL here and there. However, now
we need to develop a feature very similar to Amazon’s “Customers Who
Bought This Item Also Bought” feature.

I’m looking for suggestions on best ways to handle this, via real-time
using the actual table or a periodic process that updates a different
table (e.g. nightly).

Any suggestions on how to design one or more tables would be greatly
appreciated!

Thanks in advance.

2

On Nov 10, 12:39 pm, Ben K. [email protected]
wrote:

Any suggestions on how to design one or more tables would be greatly
appreciated!

Thanks in advance.

Posted viahttp://www.ruby-forum.com/.

i searched on “rails +collaborative +filtering” and didn’t find much,
but there are lots of papers on methodology.