I have a table in my sql server database that contains the following columns...
Now, I need to add another column called, 'Categorisation' and this column will be used to filter out the different types of product.
Now my idea of doing this was to run some kind of algorithm over the table that will do some clever pattern matching for me over the 3 columns Name,Common Name and Description. I know it won't be 100% accurate but there are 1300 products and I was hoping to at least get some of these products categorised automatically categorised.
Using algorithms to analyse data is a complete new experience for me so a thorough explanation would be greatly appreciated. Thanks.