Skip to main content

2019 | OriginalPaper | Buchkapitel

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

verfasst von : Bożena Małysiak-Mrozek, Hanna Mazurkiewicz, Dariusz Mrozek

Erschienen in: Intelligent Methods and Big Data in Industrial Applications

Verlag: Springer International Publishing

Aktivieren Sie unsere intelligente Suche, um passende Fachinhalte oder Patente zu finden.

search-config
loading …

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.

Sie haben noch keine Lizenz? Dann Informieren Sie sich jetzt über unsere Produkte:

Springer Professional "Wirtschaft+Technik"

Online-Abonnement

Mit Springer Professional "Wirtschaft+Technik" erhalten Sie Zugriff auf:

  • über 102.000 Bücher
  • über 537 Zeitschriften

aus folgenden Fachgebieten:

  • Automobil + Motoren
  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Elektrotechnik + Elektronik
  • Energie + Nachhaltigkeit
  • Finance + Banking
  • Management + Führung
  • Marketing + Vertrieb
  • Maschinenbau + Werkstoffe
  • Versicherung + Risiko

Jetzt Wissensvorsprung sichern!

Springer Professional "Technik"

Online-Abonnement

Mit Springer Professional "Technik" erhalten Sie Zugriff auf:

  • über 67.000 Bücher
  • über 390 Zeitschriften

aus folgenden Fachgebieten:

  • Automobil + Motoren
  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Elektrotechnik + Elektronik
  • Energie + Nachhaltigkeit
  • Maschinenbau + Werkstoffe




 

Jetzt Wissensvorsprung sichern!

Springer Professional "Wirtschaft"

Online-Abonnement

Mit Springer Professional "Wirtschaft" erhalten Sie Zugriff auf:

  • über 67.000 Bücher
  • über 340 Zeitschriften

aus folgenden Fachgebieten:

  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Finance + Banking
  • Management + Führung
  • Marketing + Vertrieb
  • Versicherung + Risiko




Jetzt Wissensvorsprung sichern!

Literatur
1.
Zurück zum Zitat 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_10CrossRef 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_​10CrossRef
2.
Zurück zum Zitat 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)CrossRef 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)CrossRef
3.
Zurück zum Zitat 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)CrossRef 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)CrossRef
4.
Zurück zum Zitat 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) 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)
5.
Zurück zum Zitat 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)CrossRef 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)CrossRef
6.
Zurück zum Zitat Bosc, P., Pivert, O.: On four noncommutative fuzzy connectives and their axiomatization. Fuzzy Sets Syst. 202, 42–60 (2012)MathSciNetCrossRef Bosc, P., Pivert, O.: On four noncommutative fuzzy connectives and their axiomatization. Fuzzy Sets Syst. 202, 42–60 (2012)MathSciNetCrossRef
7.
Zurück zum Zitat Bosc, P., Pivert, O., Rocacher, D.: About quotient and division of crisp and fuzzy relations. J. Intell. Inf. Syst. 29(2), 185–210 (2007)CrossRef Bosc, P., Pivert, O., Rocacher, D.: About quotient and division of crisp and fuzzy relations. J. Intell. Inf. Syst. 29(2), 185–210 (2007)CrossRef
8.
Zurück zum Zitat 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)CrossRef 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)CrossRef
10.
Zurück zum Zitat 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) 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)
11.
Zurück zum Zitat Furuta, H., Shiraishi, N.: Fuzzy Data Processing in Damage Assessment, pp. 381–392. Vieweg+Teubner Verlag, Wiesbaden (1988)CrossRef Furuta, H., Shiraishi, N.: Fuzzy Data Processing in Damage Assessment, pp. 381–392. Vieweg+Teubner Verlag, Wiesbaden (1988)CrossRef
12.
Zurück zum Zitat Hudec, M.: An approach to fuzzy database querying, analysis and realisation. Comput. Sci. Inf. Syst. 12, 127–140 (2009)CrossRef Hudec, M.: An approach to fuzzy database querying, analysis and realisation. Comput. Sci. Inf. Syst. 12, 127–140 (2009)CrossRef
13.
Zurück zum Zitat Kacprzyk, J., Ziólkowski, A.: Database queries with fuzzy linguistic quantifiers. IEEE Trans. Syst. Man Cybern. 16(3), 474–479 (1986)CrossRef Kacprzyk, J., Ziólkowski, A.: Database queries with fuzzy linguistic quantifiers. IEEE Trans. Syst. Man Cybern. 16(3), 474–479 (1986)CrossRef
14.
Zurück zum Zitat 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)CrossRef 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)CrossRef
15.
Zurück zum Zitat 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) 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)
16.
Zurück zum Zitat 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) 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)
17.
Zurück zum Zitat 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) 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)
18.
Zurück zum Zitat 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) 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)
20.
Zurück zum Zitat 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_25CrossRef 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_​25CrossRef
22.
Zurück zum Zitat 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_63CrossRef 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_​63CrossRef
23.
24.
Zurück zum Zitat 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) 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)
25.
Zurück zum Zitat 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) 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)
26.
Zurück zum Zitat 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) 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)
27.
Zurück zum Zitat Pivert, O., Bosc, P.: Fuzzy Preference Queries to Relational Databases. Imperial College Press, London (2012)CrossRef Pivert, O., Bosc, P.: Fuzzy Preference Queries to Relational Databases. Imperial College Press, London (2012)CrossRef
28.
Zurück zum Zitat 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) 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)
29.
Zurück zum Zitat Ribeiro, R.A., Moreira, A.M.: Fuzzy query interface for a business database. Int. J. Hum. Comput. Stud. 58(4), 363–391 (2003)CrossRef Ribeiro, R.A., Moreira, A.M.: Fuzzy query interface for a business database. Int. J. Hum. Comput. Stud. 58(4), 363–391 (2003)CrossRef
30.
Zurück zum Zitat 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) 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)
Metadaten
Titel
Incorporating Fuzzy Logic in Object-Relational Mapping Layer for Flexible Medical Screenings
verfasst von
Bożena Małysiak-Mrozek
Hanna Mazurkiewicz
Dariusz Mrozek
Copyright-Jahr
2019
DOI
https://doi.org/10.1007/978-3-319-77604-0_16