Skip to main content
SpringerLink
Log in

A Comparative Study of Existing Fuzzy Query Systems of Database

  • Conference paper
  • First Online:
Distributed Sensing and Intelligent Systems

Part of the book series: Studies in Distributed Intelligence ((SDI))

  • 370 Accesses

Abstract

Relational Database Management Systems (RDBMS) have become, without a doubt, the core of any computer system. Besides, in many cases information is found to be naturally fuzzy or imprecise, that’s why fuzzy query systems have become indispensable to represent and manage this information and especially facilitate interrogation to a non-expert user, but the problem is that Boolean queries do not allow the user to use vague and imprecise language terms in the qualification criteria of the searched data or to express preferences between these criteria, which is often a request legitimate end user. Nowadays, there are many proposals that allow users to make fuzzy queries on relational databases. In this chapter, we will briefly review the main attempts to find a perfect solution to this problem, highlighting their advantages, disadvantages and difficulties encountered.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 239.00
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 309.00
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info
Hardcover Book
USD 299.99
Price excludes VAT (USA)
  • Durable hardcover edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

References

  1. Zemankova-Leech, M., & Kandel, A. (1984). Fuzzy relational databases—A key to expert systems. Verlag TUV Rheinland GmbH. B. Simpson et al. Title of paper goes here if known. unpublished.

    Google Scholar 

  2. Galindo, J., Urrutia, A., & Piattini, M. (2006). Fuzzy databases: Modeling, design and implementation. Idea Group Publishing.

    Book  Google Scholar 

  3. Mama, R., & Machkour, M. (2019). A study on fuzzy interrogation systems of database. In International conference of computer science and renewable energies (ICCSRE) (pp. 1–6).

    Google Scholar 

  4. Kacprzyk, J., Zadrozny, S., & De Tré, G. (2015). Fuzziness in database management systems. Fuzzy Sets and Systems, 281(C), 300–307.

    Article  Google Scholar 

  5. Buckles, B. P., & Petry, F. E. (1982). A fuzzy representation of data for relational databases. Fuzzy Sets and Systems, 7(3), 213–226.

    Article  Google Scholar 

  6. Umano, M., Hatono, I., & Tamura, H. (1995). Fuzzy database systems. In Proceedings of the FUZZIEEE/IFES’95 workshop on fuzzy database systems and information retrieval (pp. 53–36).

    Google Scholar 

  7. Prade, H., & Testemale, C. (1984). Generalizing database relational algebra for the treatment of incomplete or uncertain information and vague queries. Information Sciences, 34(2), 115–143.

    Article  Google Scholar 

  8. Zadeh, L. A. (1978). Fuzzy sets as a basis for a theory of possibility. Fuzzy Sets and Systems, 1(1), 3–28.

    Article  Google Scholar 

  9. Zadeh, L. A. (1981). Test-score semantics for natural languages and meaning representation via PRUF. In B. B. Rieger (Ed.), Empirical semantics (Vol. 1, pp. 281–349). Bochum Brockmeyer.

    Google Scholar 

  10. Zemankova, M., & Kandel, A. (1985). Implementing imprecision in information systems. Information Sciences, 37(1–3), 107–141.

    Article  Google Scholar 

  11. Medina, J. M., Pons, O., Vila, M. A., & GEFRED. (1994). A generalized model of fuzzy relational databases. Information Sciences, 76(1–2), 87–109.

    Article  Google Scholar 

  12. Galindo, J. (2005). New characteristics in FSQL: A fuzzy SQL for fuzzy databases. Computer Journal of WSEAS Transactions on Information Science and Applications, 2(2), 161–169.

    Google Scholar 

  13. Martinez-Cruz, C., Noguera, J. M., & Vila, M. A. (2016). Flexible queries on relational databases using fuzzy logic and ontologies, information sciences. Vol., 366(20), 150–164.

    Google Scholar 

  14. Bosc, P., & Pivert, O. (1995). SQLf: A relational database language for fuzzy querying. IEEE Transactions on Fuzzy Systems, 3(1), 1–17.

    Article  Google Scholar 

  15. Kacprzyk, J., & Zadrożny, S. (2001). SQLf and FQUERY for access. In Proceedings of the IFSA World Congress and 20th NAFIPS international conference (Vol. 4, pp. 2464–2469).

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Information Systems and Vision Laboratory, Faculty of Sciences, Ibn Zohr University, Agadir, Morocco

    Mama Rachid & Machkour Mustapha

Authors
  1. Mama Rachid
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Machkour Mustapha
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Mama Rachid .

Editor information

Editors and Affiliations

  1. College of Computer Information Technology, American University in the Emirates, Dubai, United Arab Emirates

    Mohamed Elhoseny

  2. Computer Science and Engineering, University of North Texas, Denton, TX, USA

    Xiaohui Yuan

  3. Faculty of Sciences, Ibn Zohr University, Agadir, Morocco

    Salah-ddine Krit

Rights and permissions

Reprints and permissions

Copyright information

© 2022 Springer Nature Switzerland AG

About this paper

Check for updates. Verify currency and authenticity via CrossMark

Cite this paper

Rachid, M., Mustapha, M. (2022). A Comparative Study of Existing Fuzzy Query Systems of Database. In: Elhoseny, M., Yuan, X., Krit, Sd. (eds) Distributed Sensing and Intelligent Systems. Studies in Distributed Intelligence . Springer, Cham. https://doi.org/10.1007/978-3-030-64258-7_40

Download citation

Publish with us

Policies and ethics

Search

Navigation