Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Fuzzy logic
Message
De
22/07/2011 11:46:16
 
 
À
22/07/2011 11:33:56
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
01518913
Message ID:
01518914
Vues:
98
>A coworker wants me to build a routine that will search a dbf for duplicate addresses. A simple task if we were looking for an exact match. However he wants me to use "fuzzy" logic so that the match doesn't have to be exact, just "pretty close". I haven't a clue how to go about this. Is there a routine around that I could use as a sample to get started?

You need to establish a pointing system based on various criteria in matching related items. It took us several months to fine tune such routine in the earlier '90s for a project I worked on. Then, based on corelation with the data and the point system, you can decide the percentage of acceptance which would then be consider a duplicate. If you fine tune that a lot, you can obtain a 99.5% percentage of efficacity on those which will be removed.

This is usually applied on mailing list procedures.
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform