daydreamer Posted November 13, 2010 Share Posted November 13, 2010 I have a database table of product titles. For each product, I want to link 10-20 similar products, ordered by relevance. For example: db.products IDTitle 1White Paint, Quick Dry 2Yellow light bulb >50000.... db.product_similarity IDPIDsimular_to_PIDrank 11221 213222 Anybody have any suggestions about how I could go about this? The main concern is quality/relevance and accuracy. thanks. Quote Link to comment Share on other sites More sharing options...
requinix Posted November 13, 2010 Share Posted November 13, 2010 What kind of similarity are you talking about? Similar titles? Similar items? Quote Link to comment Share on other sites More sharing options...
daydreamer Posted November 14, 2010 Author Share Posted November 14, 2010 similar items, so if a user is viewing one item i can suggest similar items to compare Quote Link to comment Share on other sites More sharing options...
BlueSkyIS Posted November 14, 2010 Share Posted November 14, 2010 imagine 'glasses'. what is relevant: eyewear or kitchen wear? how about shoes? for your feet or for brakes on your car? What I'm getting at is that there is no (simple) automated way to determine relevance based on words. Of course, it's done every day by google.com and amazon.com to name a couple. But there is no simple implementation of a "natural language relevancy engine" that I know of. Quote Link to comment Share on other sites More sharing options...
ignace Posted November 14, 2010 Share Posted November 14, 2010 "People who bought this item also bought.." is probably what you are looking for. You also could add tags to each product and find products which have the most similar tags that should be easily doable. Quote Link to comment Share on other sites More sharing options...
laffin Posted November 14, 2010 Share Posted November 14, 2010 The easiest way, is assign them to categories. glasses can go into kitchenware or wearables, if your good with db u can make subcategories so precisision of similar items can be found easily Quote Link to comment Share on other sites More sharing options...
daydreamer Posted November 15, 2010 Author Share Posted November 15, 2010 categories would be good, but i have to many products to manually sort... used sphinx search server in the end Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.