By: Scianta  09-12-2011

FuzzySQL is a powerful extension to the Structured Query Language (the defacto standard for accessing and maintaining data within a relational database system – as well as many row and column-oriented non-relational systems such as spreadsheets and many flat files). Conventional SQL joins tables and screens (or selects) rows based on comparisons using Boolean Logic and ordinary arithmetic. As an example,

Select projects
From project_database
Where budget > 1000
And duration < 30
And times_revised > 20
And StartDate >= “10/10/04”;

The relationships in the query leave little room for flexibility. If any one of the Where conditions is false, then that instance in the database is not selected. Such queries are, therefore, very brittle. FuzzySQL allows us to define semantic concepts on data elements. Thus we can define, for Budget, as an example, what values are Low, Medium, and High, The range of these values can overlap in a natural way, so that a value can be Low to some degree and also Medium to some degree. Using these fuzzy semantics we can now re-write the query as,

Select projects
From project_database
Where budget is High
And duration is  Short
And times_revised is
rather Large
And StartDate is
above around( “10/10/04”);

FuzzySQL is built into the Scianta Data Explorer and is also available as an integrated and coherent collection of Java J2EE classes consisting of  the abstract classes for general data adapters, the fuzzy set definition, management, and evaluation services, a fuzzy semantic net manager, the fuzzy full and partial equi-join engine, and the outcome record set ranking and filtering server.


For a more comprehensive overview of the features and capabilities of FuzzySQL as well as a discussion of Uniform Data Adapters see,

Contact Scianta

Email - none provided

Print this page

Other products and services from Scianta



Education forms one of the key components in our approach to both successfully implementing advanced technologies but also in giving all levels of an enterprise's management and staff a deep and real-world knowledge of current, new, and emerging technologies that will change the way business is done today and in the future.



Our vision of the future, our knowledge of technological, economic, and cultural trends, as well as our keen insights into the complex challenges facing executives in both the private and public sector provides our clients with solutions that address not just today’s problems but those of tomorrow and the near future.


Technology Assesments

From a more fundamental approach, we provide both public and private enterprises with a complete and thorough analysis of candidate technologies, vendors, and marketplace - including such critical factors as.


Investor Analysis and Research

From a more fundamental approach, we provide investors with a complete and thorough technology analysis of candidate companies, including such critical factors as. From our analysis of an emerging company’s business plan and management capabilities we can provide a balanced assessments of the enterprise’s. Investor Analysis and Research forms part of Scianta Intelligence’s Investor Services program.


Port Operations

The model is built on a combination of queuing theory, high dimensional optimization techniques and many state of the art machine intelligence capabilities - such as fuzzy logic and genetic algorithms. A Port Operations Model is built on Scianta Intelligence’s knowledge-base framework and includes both a complete stochastic event simulation system and a multi-objective.


The Adaptive Intelligence Platform

Through its collection of Autonomous Component Managers (nodes in the peer-to-peer network), the Intelligence Platform creates a dynamic grid technology system supporting not only remote application execution and remote data collection, but also cooperative problem resolution through shared resources and shared solution processing.


Crew Scheduling

The crew scheduler is an integrated and coherent collection of Java J2EE classes consisting of a master plan compiler, resource managers, job managers, calendar generators, precedence solvers, bounded and unbounded schedulers, elastic and elastic constraint handlers, and a final ranked collection of solutions.