Implementation of fuzzy classification query language in relational databases using stored procedures

A framework of the fuzzy classification query language (fCQL) for data mining in information systems is presented. The fuzzy classification query language provides easy-to-use functionality for data extraction similar to the conventional non-fuzzy classification and SQL querying. The developed prototype is based on the stored procedures and database extensions of Microsoft SQL Server 2000. It can be used as data mining tool in large information systems and easily integrated with conventional relational databases. The benefits of using the presented approach include high flexibility for data analysis, user-friendly data presentation at the report generation phase and additional data security features due to the introduction of additional view-based data layer.