학술논문

Category of Fuzzy Operators in SQL
Document Type
Conference
Source
2007 International Conference on Emerging Technologies Emerging Technologies, 2007. ICET 2007. International Conference on. :114-118 Nov, 2007
Subject
Bioengineering
Communication, Networking and Broadcast Technologies
Components, Circuits, Devices and Systems
Computing and Processing
Engineered Materials, Dielectrics and Plasmas
Engineering Profession
Fields, Waves and Electromagnetics
General Topics for Engineers
Fuzzy systems
Database systems
Object oriented modeling
Fuzzy set theory
Computer science
Prototypes
Merging
Database languages
Postal services
Mathematics
Fuzzy Databases
Fuzzy SQL
Fuzzy Operators
Language
Abstract
Current database management systems have their limitations when it comes to handling imprecise data. Several DBMS prototypes emerged in this regard by merging the laws of fuzzy set theory with different database models; but it has been observed that these systems could not gain much popularity because of the hesitation by users' to replace the conventional and reliable DBMS with them. Therefore, instead of developing a new fuzzy DBMS, the focus of this paper is to find a way to enhance the current database management systems, and enabling them to handle precise as well as imprecise data. The approach taken here for this purpose is to embed fuzziness in SQL language without changing its underlying structure. As a first step, a new category of operators is being introduced in SQL, naming Fuzzy Operators. The paper introduces two fuzzy operators - NEAR and NOT NEAR, explaining their working and the algorithms to implement them.