Re: Can Access use Fuzzy Logic

Larry Linson schreef:
"kaniest" <kaniest@xxxxxxxxxxxxxxx> wrote

Larry Linson wrote
Just because you have some data stored, and in someone's view it
constitutes a "database" does not mean it is even one step along the
path from raw, random data to a relational database.

The validity of the data in a rdbms does not guarantee its
relevance. The merits of solutions to import problems
compare to the (busines) risk of errors - manual intervention,
missing accounts, offended customers, etc.
Consider James' remark on connecting data. Of course
it requires expertise and skill - and analysis. Access isn't
that different from other tools.

Are you saying "GIGO" in a lot of words? That's been a given, ever
since the computers I used were made with vacuum tubes.

"Relevance" of data was not the subject of this thread... but a
specific question about using databases, especially Access with
"fuzzy logic" as a solution to a particular problem posed by the
original poster. "Fuzzy logic" or "fuzzy matching" are not native
features in Access and may, or may not, be useful for the o.p.'s
needs. Reminds me of some time I spent, about twenty years ago,
working with rule-based-systems in AI when all the pundits predicted
that the next year was going to be "the Year of Artificial
Intelligence", for several years running. None of those years
actually was "the Year of AI", and interest waned in the subject.

At the time we (being db guys) figured that if it really works,
it's not AI. It's one thing to offer the user a set of near matches
from a non-equi join (like a Levenhstein distance in another
thread), it's another thing to decide how to modify invalid import
data to make it pass validation.
BTW, analysis doesn't necessarily shows an experienced
developer or handler to make suboptimal choices, although
there may be surprises. Once most specs were decided from
"this is the best we can do for the money" proposals by
techies, now there's an increasing demand for transparent,
rational trade-offs in a wider scope.

--
Paul


.

Relevant Pages

  • Re: Totals Query
    ... relevance to this field?? ... There are 20% of everything in the database which are Male ... >>Diffent Colums from diffent table.... ... >>What is the source though what sort of thing would I be ...
    (microsoft.public.access.queries)
  • Re: Can Access use Fuzzy Logic
    ... random data to a relational database. ... "Relevance" of data was not the subject of this thread... ... Access is, in fact, the UI and development tool. ... can be the Jet database engine that comes with Access and is installed by ...
    (comp.databases.ms-access)
  • aspnet vs IUSR_COMPUTERNAME
    ... the web form acts as ASPNET when accessing a database. ... This used to be IUSR_COMPUTERNAME in old asp, so my question is what is the relevance of the anonymous IIS account IUSR_COMPUTERNAME - is it used anywhere in asp.net - should I forget about it? ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: How to make a numbering field to a field selection in SQL?
    ... number them, there won't be any relevance to anything in the database, ... rethink your design instead of trying to come up with arbitrary record ... I have a table in my database, from which I SELECT some fields. ... which can add an artificial field for numbering ...
    (microsoft.public.data.ado)
  • Re: POD speed
    ... > consider use of such a POD product to be without disadvantages. ... Enforcement of database constraints in application code is one solution generally ... > application-private data into a relational database on the suspicion ...
    (comp.lang.java.databases)