CFP last date
22 April 2024
Reseach Article

Handling of Fuzzy Queries using Relational DBMS

by Nishant Agrawal, Anubhav Manan, Akash Aggrawal, Rashmi Sharma
International Journal of Computer Applications
Foundation of Computer Science (FCS), NY, USA
Volume 68 - Number 22
Year of Publication: 2013
Authors: Nishant Agrawal, Anubhav Manan, Akash Aggrawal, Rashmi Sharma
10.5120/11714-7365

Nishant Agrawal, Anubhav Manan, Akash Aggrawal, Rashmi Sharma . Handling of Fuzzy Queries using Relational DBMS. International Journal of Computer Applications. 68, 22 ( April 2013), 34-40. DOI=10.5120/11714-7365

@article{ 10.5120/11714-7365,
author = { Nishant Agrawal, Anubhav Manan, Akash Aggrawal, Rashmi Sharma },
title = { Handling of Fuzzy Queries using Relational DBMS },
journal = { International Journal of Computer Applications },
issue_date = { April 2013 },
volume = { 68 },
number = { 22 },
month = { April },
year = { 2013 },
issn = { 0975-8887 },
pages = { 34-40 },
numpages = {9},
url = { https://ijcaonline.org/archives/volume68/number22/11714-7365/ },
doi = { 10.5120/11714-7365 },
publisher = {Foundation of Computer Science (FCS), NY, USA},
address = {New York, USA}
}
%0 Journal Article
%1 2024-02-06T21:28:38.603622+05:30
%A Nishant Agrawal
%A Anubhav Manan
%A Akash Aggrawal
%A Rashmi Sharma
%T Handling of Fuzzy Queries using Relational DBMS
%J International Journal of Computer Applications
%@ 0975-8887
%V 68
%N 22
%P 34-40
%D 2013
%I Foundation of Computer Science (FCS), NY, USA
Abstract

Handling crisp and precise data in SQL is an easy process but classical data models often suffer from their incapability of representing and manipulating imprecise and uncertain information which is found in many real world applications. Since the early 1980's, Zadeh'sfuzzy logic has been used to improve and modify various data models. This introduction of fuzzy logic in databases enhances the capability of classical models so that uncertain and imprecise information could easily be represented and manipulated. This paper proposes an algorithm with the help of which crisp values are converted into fuzzy values by calculating their membership value at the database level. The paper then uses a GUI through which the result of fuzzy queries can be obtained from the database. With the help of proposed algorithm, the calculated membership value will be stored in the database for differentpredefined categories (e. g. -child, young, middle age and old in case of ages). These membership values helps in fetching the result of fuzzy queries from the database with the help of developed GUI (the database used here is oracle 10g but other databases can also be used). The fuzzy queries have a wider retrieved space and can be used to identify the characteristic of an individual (marks in this case).

References
  1. Zadeh, L. A. (1971). Similarity relations and fuzzy orderings. Information Sciences, 3, 177-200.
  2. Umano, M. , &Fukami, S. (1994). Fuzzy relational algebra for possibilitydistribution- fuzzy-relation model of fuzzy data. Journal of Intelligent Information Systems, 3, 7-28.
  3. Zemankova-Leech, M. , &Kandel, A. (1984). Fuzzy relational databases: A key to expertsystems. Köln, Germany: Verlag TUV Rheinland. Fgf.
  4. Prade, H. , &Testemale, C. (1987a). Fuzzy relational databases: Representational issues and reduction using similarity measures. J. Am. Soc. Information Sciences, 38(2), 118-126.
  5. Y. Takahashi, "A fuzzy query language for relational databases,"IEEE Transactions onSystems, Man and Cybernetics, Vol. 21, 1991, pp. 1576-1579.
  6. D. A. Chiang, N. P. Lin, and C. C. Shis, "Matching strengths of answers in fuzzy relational databases," IEEE Transactions on Systems, Man, and Cybernetics-Part C:Applications and Reviews, Vol. 28, 1998, pp. 476-481.
  7. V. Cross, "Defining fuzzy relationships in object models: Abstraction and interpretation,"Fuzzy Sets and Systems, Vol. 140, 2003, pp. 5-27.
  8. V. Cross, "Fuzzy extensions for relationships in a generalized object model," InternationalJournal of Intelligent Systems, Vol. 16, 2001, pp. 843-861.
  9. G. Q. Chen, E. E. Kerre, and J. Vandenbulcke, "The dependency-preserving decomposition and a testing algorithm in a fuzzy relational data model," Fuzzy Sets and Systems, Vol. 72, 1995, pp. 27-37.
  10. L. A. Zadeh, The concept of a linguistic variable and its application to approximate reasoning. Information Sciences, Part 1: 8:199-249; Part 2:2:301-357; Part 3: 9:43-80, 1975.
  11. Galindo, J. , Urrutia, A. , Piattini, M. , Fuzzy Databases: modelling, Design and Implementation, Idea Group Publishing, Hershey, USA. (2006).
  12. B. Bhuniya and P. Niyogi, "Lossless join property in fuzzy relational databases," Data and Knowledge Engineering, Vol. 11, 1993, pp. 109-124.
  13. T. K. Bhattacharjee and A. K. Mazumdar, "Axiomatisation of fuzzy multivalued dependencies in a fuzzy relational data model," Fuzzy Sets and Systems, Vol. 96, 1998, pp. 343-352.
  14. G. Q. Chen, Fuzzy Logic in Data Modelling; Semantics, Constraints, and DatabaseDesign, Kluwer Academic Publisher, 1999.
  15. Z. M. Ma, W. J. Zhang, and F. Mili, "Fuzzy data compression based on data dependencies," International Journal of Intelligent Systems, Vol. 17, 2002, pp. 409-426.
  16. S. Y. Liao, H. Q. Wang, and W. Y. Liu, "Functional dependencies with null values, fuzzy values, and crisp values," IEEE Transactions on Fuzzy Systems, Vol. 7, 1999, pp. 97-103.
  17. K. H. Lee, First Course on Fuzzy Theory and Applications, Springer, 2004.
  18. M. Kamel, B. Hadfield, and M. Ismail, "Fuzzy query processing using clustering techniques," Information Processing and Management, Vol. 26, 1990, pp. 279-293.
  19. R. Intan and M. Mukaidono, "Fuzzy functional dependency and its application to approximate data querying," in Proceedings of International Database Engineering and Applications Symposium, 2000, pp. 47-54.
Index Terms

Computer Science
Information Sciences

Keywords

Handling Fuzzy