Fuzzy improvement of the SQL

Authors

  • Miroslav Hudec Institute of Informatics and Statistics, Bratislava, Slovakia

DOI:

https://doi.org/10.2298/YJOR1102239H

Keywords:

SQL, fuzzy query, generalized logical condition, database

Abstract

Structured Query Language (SQL) is used to obtain data from relational databases. Fuzzy improvement of SQL queries has advantages in cases when the user cannot unambiguously define selection criteria or when the user wants to examine data that almost meet the given criteria. In this paper we examine a realization of the fuzzy querying concept. For this purposes the fuzzy generalized logical condition for the WHERE part of the SQL is created. It allows users to create queries by linguistic terms. The proposed model is an extension of the SQL so that no modification inside databases has to be undertaken.

References

Bosc, P., and Pivert, O., "SQL query functionality on top of a regular relational database management system", in: O. Pons, M.A. Vila, and J. Kacprzyk (eds.), Knowledge Management in Fuzzy Databases, Physica Publisher, Heidelberg, 2000, 171-190.

Branco, A., Evsukoff, A., and Ebecken, N., “Generating fuzzy queries from weighted fuzzy classifier rules“, ICDM workshop on Computational Intelligence in Data Mining, (2005) 21-28.

Chamberlin, D., and Boyce R., “SEQUEL: A structured english query language”, ACM SIGMOD Workshop on Data Description, Access and Control, (1974) 249-264.

Cox E., Fuzzy Modeling and Genetic Algorithms for Data Mining and Exploration, Morgan Kaufman, San Francisco, 2005.

Galindo, J., Urrutia, A., and Piattini, M., Fuzzy Databases, Modeling, Design and Implementation, Idea Group Publishing, London, 2006.

Hudec, M., and Priehradníková, L., "Significance of the information system for support of regional development in the Slovak Republic", INFO-M, 17 (2006) 4-10.

Hudec, M., “Fuzzy improvement of the SQL”, 8th Balkan Conference on Operational Research, (2007) 255-265.

Kacprzyk, J., Pasi, G., Vojtáš, P., and Zadrożny, S., “Fuzzy querying: Issues and perspectives”, Kybernetika, 36 (2000) 605-616.

Siler, W., and Buckley, J., Fuzzy Expert Systems and Fuzzy Reasoning, John Wiley & Sons, Inc., New Jersey, 2005.

Wang, T.C., Lee, H.D., and Chen, C.M., "Intelligent queries based on fuzzy set theory and SQL", Joint Conference on Information Science, (2007) 1426-1432.

Werro, N., Meier, A., Mezger, C., and Schindler G., “Concept and implementation of a fuzzy classification query language”, DMIN (2005) 208-214.

Zadeh, L., “Fuzzy sets”, Information and Control, 8 (1965) 338-353.

Downloads

Published

2011-09-01

Issue

Vol. 21 No. 2 (2011)

Section

Research Articles

License

Copyright (c) 2011 YUJOR

Creative Commons License

This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License.