Skip to main content
SpringerLink
Log in

Incorporating Fuzzy Logic in Object-Relational Mapping Layer for Flexible Medical Screenings

  • Chapter
  • First Online:
Intelligent Methods and Big Data in Industrial Applications

Part of the book series: Studies in Big Data ((SBD,volume 40))

  • 878 Accesses

Abstract

Introduction of fuzzy techniques in database querying allows for flexible retrieval of information and inclusion of imprecise expert knowledge into the retrieval process. This is especially beneficial while analyzing collections of patients’ biomedical data, in which similar results of laboratory tests may lead to the same conclusions, diagnoses, and treatment scenarios. Fuzzy techniques for data retrieval can be implemented in various layers of database client-server architecture. However, since in the last decade, the development of real-life database applications is frequently based on additional object-relational mapping (ORM) layers, inclusion of fuzzy logic in data analysis remains a challenge. In this paper, we show our extensions to the Doctrine ORM framework that supply application developers with the possibility of fuzzy querying against collections of crisp data stored in relational databases. Performance tests prove that these extensions do not introduce a significant slowdown while querying data and can be successfully used in development of applications that benefit from fuzzy information retrieval.

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 129.00
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 169.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info
Hardcover Book
USD 169.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. Appelgren Lara, G., Delgado, M., Marín, N.: Fuzzy multidimensional modelling for flexible querying of learning object repositories. In: Larsen, H.L., Martin-Bautista, M.J., Vila, M.A., Andreasen, T., Christiansen, H. (eds.) Flexible Query Answering Systems. FQAS 2013, LNCS, vol. 8132, pp. 112–123. Springer, Berlin (2013). https://doi.org/10.1007/978-3-642-40769-7_10

    Chapter  Google Scholar 

  2. Aras, F., Karakas, E., Bicen, Y.: Fuzzy logic-based user interface design for risk assessment considering human factor: a case study for high-voltage cell. Saf. Sci. 70, 387–396 (2014)

    Article  Google Scholar 

  3. Ben Hassine, M.A., Ounelli, H.: IDFQ: an interface for database flexible querying. In: Atzeni, P., Caplinskas, A., Jaakkola, H. (eds.) Advances in Databases and Information Systems. ADBIS 2008, LNCS, vol. 5207, pp. 112–126. Springer, Berlin (2008)

    Chapter  Google Scholar 

  4. Bordogna, G., Psaila, G.: Customizable flexible querying in classical relational databases. In: Galindo, J. (ed.) Handbook of Research on Fuzzy Information Processing in Databases, pp. 191–217. IGI Global (2008)

    Google Scholar 

  5. Bosc, P., Pivert, O.: SQLf query functionality on top of a regular relational database management system. In: Pons, O., Vila, M.A., Kacprzyk, J. (eds.) Knowledge Management in Fuzzy Databases, Studies in Fuzziness and Soft Computing, vol. 39, pp. 171–190. Physica HD, Heidelberg (2000)

    Chapter  Google Scholar 

  6. Bosc, P., Pivert, O.: On four noncommutative fuzzy connectives and their axiomatization. Fuzzy Sets Syst. 202, 42–60 (2012)

    Article  MathSciNet  Google Scholar 

  7. Bosc, P., Pivert, O., Rocacher, D.: About quotient and division of crisp and fuzzy relations. J. Intell. Inf. Syst. 29(2), 185–210 (2007)

    Article  Google Scholar 

  8. Bosc, P., Pivert, O., Smits, G.: On a fuzzy group-by and its use for fuzzy association rule mining. In: Catania, B., Ivanović, M., Thalheim, B. (eds.) Advances in Databases and Information Systems. ADBIS 2010, LNCS, vol. 6295, pp. 88–102. Springer, Berlin (2010)

    Chapter  Google Scholar 

  9. Cheng, S., Dong, R., Pedrycz, W.: A framework of fuzzy hybrid systems for modelling and control. Int. J. Gen. Syst. 39(2), 165–176 (2010). https://doi.org/10.1080/03081070903427358

    Article  MathSciNet  Google Scholar 

  10. Czajkowski, K., Olczyk, P.: Fuzzy interface for historical monuments databases. In: Kozielski, S., Mrozek, D., Kasprowski, P., Małysiak-Mrozek, B., Kostrzewa, D. (eds.) Beyond Databases, Architectures, and Structures. BDAS 2014, CCIS, vol. 424, pp. 271–279. Springer International Publishing, Cham (2014)

    Google Scholar 

  11. Furuta, H., Shiraishi, N.: Fuzzy Data Processing in Damage Assessment, pp. 381–392. Vieweg+Teubner Verlag, Wiesbaden (1988)

    Chapter  Google Scholar 

  12. Hudec, M.: An approach to fuzzy database querying, analysis and realisation. Comput. Sci. Inf. Syst. 12, 127–140 (2009)

    Article  Google Scholar 

  13. Kacprzyk, J., Ziólkowski, A.: Database queries with fuzzy linguistic quantifiers. IEEE Trans. Syst. Man Cybern. 16(3), 474–479 (1986)

    Article  Google Scholar 

  14. Kacprzyk, J., Zadrożny, S.: Data mining via fuzzy querying over the internet. In: Pons, O., Vila, M.A., Kacprzyk, J. (eds.) Knowledge Management in Fuzzy Databases, Studies in Fuzziness and Soft Computing, vol. 39, pp. 211–233. Physica HD, Heidelberg (2000)

    Chapter  Google Scholar 

  15. Kacprzyk, J., Zadrożny, S.: Queries with fuzzy linguistic quantifiers for data of variable quality using some extended OWA operators. In: Andreasen, T., et al. (eds.) Flexible Query Answering Systems 2015, Advances in Intelligent Systems and Computing, vol. 400, pp. 295–305. Springer, Cham (2016)

    Google Scholar 

  16. Macwan, N., Sajja, P.S.: Fuzzy logic: an effective user interface tool for decision support system. Int. J. Eng. Sci. Innov. Technol. 3(3), 278–283 (2014)

    Google Scholar 

  17. Małysiak, B., Mrozek, D., Kozielski, S.: Processing fuzzy SQL queries with flat, context-dependent and multidimensional membership functions. In: Hamza, M.H. (ed.) IASTED International Conference on Computational Intelligence, Calgary, Alberta, Canada, July 4–6, 2005. pp. 36–41. IASTED/ACTA Press (2005)

    Google Scholar 

  18. Małysiak, B., Momot, A., Kozielski, S., Mrozek, D.: On using energy signatures in protein structure similarity searching. In: Rutkowski, L., Tadeusiewicz, R., Zadeh, L.A., Zurada, J.M. (eds.) Artificial Intelligence and Soft Computing. ICAISC 2008, LNCS, vol. 5097, pp. 939–950. Springer, Berlin (2008)

    Google Scholar 

  19. Małysiak-Mrozek, B., Mrozek, D.: An improved method for protein similarity searching by alignment of fuzzy energy signatures. Int. J. Comput. Intell. Syst. 4(1), 75–88 (2011). https://doi.org/10.1080/18756891.2011.9727765

    Article  Google Scholar 

  20. Małysiak-Mrozek, B., Mrozek, D., Kozielski, S.: Data grouping process in extended SQL language containing fuzzy elements. In: Cyran, K.A., Kozielski, S., Peters, J.F., Stańczyk, U., Wakulicz-Deja, A. (eds.) Man-Machine Interactions, AISC, vol. 59, pp. 247–256. Springer, Berlin (2009). https://doi.org/10.1007/978-3-642-00563-3_25

    Chapter  Google Scholar 

  21. Małysiak-Mrozek, B., Kozielski, S., Mrozek, D.: Modern software tools for researching and teaching fuzzy logic incorporated into database systems. In: Proceedings of the iNEER International Conference on Engineering Education, Gliwice, Poland. pp. 1–8. iNEER (2010). http://www.ineer.org/Events/ICEE2010/papers/T11D/Paper_954_1141.pdf

  22. Małysiak-Mrozek, B., Mrozek, D., Kozielski, S.: Processing of crisp and fuzzy measures in the fuzzy data warehouse for global natural resources. In: García-Pedrajas, N., Herrera, F., Fyfe, C., Benítez, J.M., Ali, M. (eds.) Trends in Applied Intelligent Systems. IEA/AIE 2010, LNCS, vol. 6098, pp. 616–625. Springer, Berlin (2010). https://doi.org/10.1007/978-3-642-13033-5_63

    Chapter  Google Scholar 

  23. Mrozek, D., Małysiak, B., Kozielski, S.: EAST: energy alignment search tool. In: Wang, L., Jiao, L., Shi, G., Li, X., Liu, J. (eds.) Fuzzy Systems and Knowledge Discovery. FSKD 2006, LNCS, vol. 4223, pp. 696–705. Springer, Berlin (2006). https://doi.org/10.1007/11881599_85

    Chapter  Google Scholar 

  24. Mrozek, D., Małysiak, B., Kozielski, S.: An optimal alignment of proteins energy characteristics with crisp and fuzzy similarity awards. In: 2007 IEEE International Fuzzy Systems Conference, pp. 1513–1518 (2007)

    Google Scholar 

  25. Mrozek, D., Malysiak-Mrozek, B., Kozielski, S., Swierniak, A.: The Energy Distribution Data Bank: collecting energy features of protein molecular structures. In: 2009 Ninth IEEE International Conference on Bioinformatics and BioEngineering, pp. 301–306 (2009)

    Google Scholar 

  26. Myszkorowski, K.: Inference rules for fuzzy functional dependencies in possibilistic databases. In: Kozielski, S., Mrozek, D., Kasprowski, P., Małysiak-Mrozek, B., Kostrzewa, D. (eds.) Beyond Databases, Architectures and Structures. Advanced Technologies for Data Mining and Knowledge Discovery. BDAS 2016, CCIS, vol. 613, pp. 181–191. Springer International Publishing, Cham (2016)

    Google Scholar 

  27. Pivert, O., Bosc, P.: Fuzzy Preference Queries to Relational Databases. Imperial College Press, London (2012)

    Book  Google Scholar 

  28. Portinale, L., Montani, S.: A fuzzy logic approach to case matching and retrieval suitable to SQL implementation. In: Proceedings of the 2008 20th IEEE International Conference on Tools with Artificial Intelligence, vol. 02, pp. 241–245. ICTAI ’08, IEEE Computer Society, Washington, DC, USA (2008)

    Google Scholar 

  29. Ribeiro, R.A., Moreira, A.M.: Fuzzy query interface for a business database. Int. J. Hum. Comput. Stud. 58(4), 363–391 (2003)

    Article  Google Scholar 

  30. Smits, G., Pivert, O., Girault, T.: Towards reconciling expressivity, efficiency and user-friendliness in database flexible querying. In: 2013 IEEE International Conference on Fuzzy Systems (FUZZ-IEEE), pp. 1–8 (2013)

    Google Scholar 

  31. Zadeh, L.: Fuzzy sets. Inf. Control 8, 338–353 (1965)

    Article  Google Scholar 

  32. Zadeh, L.: Fuzzy logic. Computer 21(4), 83–93 (1988)

    Article  Google Scholar 

Download references

Acknowledgements

This work was supported by Statutory Research funds of Institute of Informatics, Silesian University of Technology, Gliwice, Poland (grant No BK-230/RAu2/2017).

Author information

Authors and Affiliations

  1. Institute of Informatics, Silesian University of Technology, ul. Akademicka 16, 44-100, Gliwice, Poland

    Bożena Małysiak-Mrozek, Hanna Mazurkiewicz & Dariusz Mrozek

Authors
  1. Bożena Małysiak-Mrozek
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Hanna Mazurkiewicz
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Dariusz Mrozek
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Dariusz Mrozek .

Editor information

Editors and Affiliations

  1. Institute of Computer Science, Warsaw University of Technology, Warsaw, Poland

    Robert Bembenik

  2. Institute of Computer Science, Warsaw University of Technology, Warsaw, Poland

    Łukasz Skonieczny

  3. Institute of Computer Science, Warsaw University of Technology, Warsaw, Poland

    Grzegorz Protaziuk

  4. Institute of Computer Science, Warsaw University of Technology, Warsaw, Poland

    Marzena Kryszkiewicz

  5. Institute of Computer Science, Warsaw University of Technology, Warsaw, Poland

    Henryk Rybinski

Rights and permissions

Reprints and permissions

Copyright information

© 2019 Springer International Publishing AG, part of Springer Nature

About this chapter

Check for updates. Verify currency and authenticity via CrossMark

Cite this chapter

Małysiak-Mrozek, B., Mazurkiewicz, H., Mrozek, D. (2019). Incorporating Fuzzy Logic in Object-Relational Mapping Layer for Flexible Medical Screenings. In: Bembenik, R., Skonieczny, Ł., Protaziuk, G., Kryszkiewicz, M., Rybinski, H. (eds) Intelligent Methods and Big Data in Industrial Applications. Studies in Big Data, vol 40. Springer, Cham. https://doi.org/10.1007/978-3-319-77604-0_16

Download citation

Publish with us

Policies and ethics

Search

Navigation