I am looking for some general guidance on how to develop a solution that is similar to a Market Basket analysis. I understand the question a Market Basket Analsis answers is....if a person bought product X they were also likely to buy product Y and/or Z. What I am trying to do is provide alternatives to product X. So, if a person inputs that they want to buy product X, the solution would provide alternative products based on similar product attributes. Is this something that a data mininig algorithm would solve(Market Basket Analyis or Association) or is this something that can be handled outside of any data mining product (I am looking for the easiest approach).
Currently I have the MS SQL Server 2008 product suite so I would like to develop such a solution using this toolset but would interested in hearing of any similar solutions built on other products.