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 <i xmlns:mml="http://www.w3.org/1998/Math/MathML" xmlns:xlink="http://www.w3.org/1999/xlink">Fuzzy</i> <i xmlns:mml="http://www.w3.org/1998/Math/MathML" xmlns:xlink="http://www.w3.org/1999/xlink">Operators</i> . The paper introduces two fuzzy operators - NEAR and NOT NEAR, explaining their working and the algorithms to implement them.

Talk to us

Join us for a 30 min session where you can share your feedback and ask us any queries you have

Schedule a call

Disclaimer: All third-party content on this website/platform is and will remain the property of their respective owners and is provided on "as is" basis without any warranties, express or implied. Use of third-party content does not indicate any affiliation, sponsorship with or endorsement by them. Any references to third-party content is to identify the corresponding services and shall be considered fair use under The CopyrightLaw.