Re: Fuzzy Practical Uses

From: Earl Cox (earldcox1@home.com)
Date: Tue Aug 14 2001 - 17:08:52 MET DST

  • Next message: ICSC-NAIS: "Second Call For Papers NL2002"

    Well, of course, there is the entire realm of FuzzySQL, the ability to use
    fuzzy sets in database queries, allowing queries like,

    select *
    from projects
    where duration is Long
       and budget is very high
      and number_of_revisions is small
      and delta(planned_end,actual_end) is tiny;

    such fuzzy queries are much more robust and fault tolerant than traditional
    Boolean queries. They can also return a compatibility index indicating how
    closely the returned records match the intent of the query's semantics.
    Sonalysts markets a Fuzzy Query product for databases and Excel spread
    sheets. The code for a basic FuzzySQL processor can be found in my book
    Fuzzy Logic for Business and Industry.

    And, of course you can use fuzzy logic as part of database domain (or
    integrity) checks as well as triggers. Although I have read papers about
    storing fuzzy grades of memberships in a database, in the real world this is
    almost never practical due to the volatility of data. It is much better to
    let the query generate the memberships. Also, what is young to marketing
    might not be young to credit approval or human resources -- thus storing the
    fact that someone's "young" in a database removes flexibility and robustness
    and the ability to use the same data for multiple purposes.

    Why would you think that fuzzy logic would use any more computing resources
    than any other kind of computational intelligence system (heuristic
    searches, neural networks, genetic algorithms, etc.) There are many
    real-time fuzzy systems in everyday use involving hundreds of rules and
    dozens of fuzzy sets. I have built on-line fuzzy eCommerce cross-marketing
    and CRM analysis systems running as Java applets that analyze, partition,
    rank, and segment hundreds of incoming transactions per second in a web
    server or an application server (such as BEA WLS).

    Yes. And it has been since the early 1980's.

    I suggest that, instead of throwing such broad questions at the news group,
    that you do some preliminary research and then you can raise more focused
    issues.

    earl

    --
    Earl Cox
    VP, Research/Chief Scientist
    Panacya, Inc.
    134 National Business Parkway
    Annapolis Junction, MD 20701
    (410) 904-8741
    -------------------------------------------
    

    AUTHOR: "The Fuzzy Systems Handbook" (1994) "Fuzzy Logic for Business and Industry" (1995) "Beyond Humanity: CyberEvolution and Future Minds" (1996, with Greg Paul, Paleontologist/Artist) "The Fuzzy Systems Handbook, 2nd Ed." (1998) "Fuzzy Tools for Data Mining and Knowledge Discovery" (due Early Fall, 2001)

    "default" <default@default.com> wrote in message news:3B787E11.93523FAA@default.com... > Hello Everyone! > > How might a person use fuzzy theory in a database system or inside of an > application? > > Can fuzzy theory be used in a practical manner without using too much > computing time or too many computer resources? > > Is fuzzy theory something that is practical at this time? > > ===== > Fractal A. > fractala@yahoo.com > >

    ############################################################################ This message was posted through the fuzzy mailing list. (1) To subscribe to this mailing list, send a message body of "SUB FUZZY-MAIL myFirstName mySurname" to listproc@dbai.tuwien.ac.at (2) To unsubscribe from this mailing list, send a message body of "UNSUB FUZZY-MAIL" or "UNSUB FUZZY-MAIL yoursubscription@email.address.com" to listproc@dbai.tuwien.ac.at (3) To reach the human who maintains the list, send mail to fuzzy-owner@dbai.tuwien.ac.at (4) WWW access and other information on Fuzzy Sets and Logic see http://www.dbai.tuwien.ac.at/ftp/mlowner/fuzzy-mail.info (5) WWW archive: http://www.dbai.tuwien.ac.at/marchives/fuzzy-mail/index.html



    This archive was generated by hypermail 2b30 : Tue Aug 14 2001 - 17:28:34 MET DST