How to Implement fuzzy logic on relational database?

I have already tables and I want to apply fuzzy logic on some attributes ( fuzzy sets , membership functions, fuzzification , defuzzification  ..etc) but I do not how to start. I have used SQL SERVER.
Abdullah AlshehriAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Vitor MontalvãoMSSQL Senior EngineerCommented:
Please give us more details. Usually, examples are good to help explain the requirements.
0
zephyr_hex (Megan)DeveloperCommented:
It depends on the version of SQL Server.  If you have a higher end version of SQL, you could use the Similarity function available in Master Data Services.

For SQL versions 2008 + that don't offer MDS,  you can use SOUNDEX() and/or DIFFERENCE()

Or, you could use the Fuzzy Lookup in SSIS, or use TSQL to perform various algorithms (Levenshtein, Jaccard, etc).  Many of these algorithms have example functions available on the web.

Here is a good general article that discusses both MDS and various fuzzy logic algorithms:  http://blog.hoegaerden.be/2011/02/05/finding-similar-strings-with-fuzzy-logic-functions-built-into-mds/

To get examples of these algorithms, just google for "TSQL Levenshtein", or whatever algorithm you're interested in.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.