Skip to main content
Top
Published in: Journal of Intelligent Information Systems 3/2009

01-12-2009

Issues in the practical use of the OWA operators in fuzzy querying

Authors: Sławomir Zadrożny, Janusz Kacprzyk

Published in: Journal of Intelligent Information Systems | Issue 3/2009

Log in

Activate our intelligent search to find suitable subject content or patents.

search-config
loading …

Abstract

Flexible querying of the relational databases is considered. The applicability of some non-standard, mainly linguistic quantifier driven aggregation, and via Yager’s ordered weighted averaging (OWA) operators in particular, is shown. Their handling is studied with a special emphasis on the selection and tuning of the OWA operator that is appropriate for the user needs. We start with an OWA operator and intend to tune it to increase its ORness, but keeping the changes as limited as possible, or to preserve consistency of the changes. These tasks are defined as optimization problems. The discussion is illustrated on the example of the authors’ FQUERY for Access system.

Dont have a licence yet? Then find out more about our products and how to get one now:

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!

Literature
go back to reference Bosc, P., & Kacprzyk, J. (Eds.) (1995). Fuzziness in database management systems. Heidelberg: Physica-Verlag.MATH Bosc, P., & Kacprzyk, J. (Eds.) (1995). Fuzziness in database management systems. Heidelberg: Physica-Verlag.MATH
go back to reference Bosc, P., & Lietard, L. (1997). Quantified statements and some interpretations for the OWA operators. In R. Yager & J. Kacprzyk (Eds.), The ordered weighted averaging operators: Theory and applications (pp. 241–257). Boston: Kluwer. Bosc, P., & Lietard, L. (1997). Quantified statements and some interpretations for the OWA operators. In R. Yager & J. Kacprzyk (Eds.), The ordered weighted averaging operators: Theory and applications (pp. 241–257). Boston: Kluwer.
go back to reference Bosc, P., Lietard, L., & Pivert, O. (1995). Quantified statements and database fuzzy querying. In P. Bosc & J. Kacprzyk (Eds.). Fuzziness in database management systems (pp. 275–308). Heidelberg: Physica-Verlag. Bosc, P., Lietard, L., & Pivert, O. (1995). Quantified statements and database fuzzy querying. In P. Bosc & J. Kacprzyk (Eds.). Fuzziness in database management systems (pp. 275–308). Heidelberg: Physica-Verlag.
go back to reference Bosc, P., & Pivert, O. (1995). SQLf: A relational database language for fuzzy querying. IEEE Transactions on Fuzzy Systems, 3(1), 1–17.CrossRefMathSciNet Bosc, P., & Pivert, O. (1995). SQLf: A relational database language for fuzzy querying. IEEE Transactions on Fuzzy Systems, 3(1), 1–17.CrossRefMathSciNet
go back to reference Bosc, P., & Prade, H. (1996). An introduction to the fuzzy set and possibility theory-based treatment of flexible queries and uncertain or imprecise databases. In Uncertainty management in information systems (pp. 285–324). Boston: Kluwer Academic. Bosc, P., & Prade, H. (1996). An introduction to the fuzzy set and possibility theory-based treatment of flexible queries and uncertain or imprecise databases. In Uncertainty management in information systems (pp. 285–324). Boston: Kluwer Academic.
go back to reference Dubois, D., & Prade, H. (1997). Using fuzzy sets in flexible querying: Why and how? In Flexible query answering systems (pp. 45–60). Norwell: Kluwer Academic Dubois, D., & Prade, H. (1997). Using fuzzy sets in flexible querying: Why and how? In Flexible query answering systems (pp. 45–60). Norwell: Kluwer Academic
go back to reference Filev, D., & Yager, R. (1995). Analytic properties of maximum entropy OWA operators. Information Sciences, 85, 11–27.MATHCrossRef Filev, D., & Yager, R. (1995). Analytic properties of maximum entropy OWA operators. Information Sciences, 85, 11–27.MATHCrossRef
go back to reference Filev, D., & Yager, R. (1998). On the issue of obtaining OWA operator weights. Fuzzy Sets and Systems, 94, 157–169.CrossRefMathSciNet Filev, D., & Yager, R. (1998). On the issue of obtaining OWA operator weights. Fuzzy Sets and Systems, 94, 157–169.CrossRefMathSciNet
go back to reference Fuller, R., & Majlender, P. (2001). An analytic approach for obtaining maximal entropy OWA operator weights. Fuzzy Sets and Systems, 124(1), 53–57.MATHCrossRefMathSciNet Fuller, R., & Majlender, P. (2001). An analytic approach for obtaining maximal entropy OWA operator weights. Fuzzy Sets and Systems, 124(1), 53–57.MATHCrossRefMathSciNet
go back to reference Fuller, R., & Majlender, P. (2003). On obtaining minimal variability OWA operator weights. Fuzzy Sets and Systems, 136(2), 203–215.MATHCrossRefMathSciNet Fuller, R., & Majlender, P. (2003). On obtaining minimal variability OWA operator weights. Fuzzy Sets and Systems, 136(2), 203–215.MATHCrossRefMathSciNet
go back to reference Galindo, J. (Ed.) (2008). Handbook of research on fuzzy information processing in databases. Hershey: Idea Group. Galindo, J. (Ed.) (2008). Handbook of research on fuzzy information processing in databases. Hershey: Idea Group.
go back to reference ISO/ANSI (2003). Database Languages – SQL, ISO/IEC 9075-*:2003. ISO/ANSI (2003). Database Languages – SQL, ISO/IEC 9075-*:2003.
go back to reference Kacprzyk, J., & Zadrożny, S. (1995). FQUERY for Access: Fuzzy querying for a windows-based DBMS. In P. Bosc & J. Kacprzyk (Eds.), Fuzziness in database management systems (pp. 415–433). Heidelberg: Physica-Verlag. Kacprzyk, J., & Zadrożny, S. (1995). FQUERY for Access: Fuzzy querying for a windows-based DBMS. In P. Bosc & J. Kacprzyk (Eds.), Fuzziness in database management systems (pp. 415–433). Heidelberg: Physica-Verlag.
go back to reference Kacprzyk, J., & Zadrożny, S. (2001). Computing with words in intelligent database querying: Standalone and internet-based applications. Information Sciences, 134(1–4), 71–109.MATHCrossRef Kacprzyk, J., & Zadrożny, S. (2001). Computing with words in intelligent database querying: Standalone and internet-based applications. Information Sciences, 134(1–4), 71–109.MATHCrossRef
go back to reference Kacprzyk, J., Zadrożny, S., & Ziółkowski, A. (1989). FQUERY III+: A “human consistent” database querying system based on fuzzy logic with linguistic quantifiers. Information Systems, 14(6), 443–453.CrossRef Kacprzyk, J., Zadrożny, S., & Ziółkowski, A. (1989). FQUERY III+: A “human consistent” database querying system based on fuzzy logic with linguistic quantifiers. Information Systems, 14(6), 443–453.CrossRef
go back to reference Kacprzyk, J., & Ziółkowski, A. (1986). Database queries with fuzzy linguistic quantifiers. IEEE Transactions on System, Man and Cybernetics, 16(3), 474–479.CrossRef Kacprzyk, J., & Ziółkowski, A. (1986). Database queries with fuzzy linguistic quantifiers. IEEE Transactions on System, Man and Cybernetics, 16(3), 474–479.CrossRef
go back to reference Larsen, H. L. (1999). Importance weighted OWA aggregation of multicriteria queries. In Proceedings of the NAFIPS’99 conference (pp. 740–744). New York. Larsen, H. L. (1999). Importance weighted OWA aggregation of multicriteria queries. In Proceedings of the NAFIPS’99 conference (pp. 740–744). New York.
go back to reference Liu, X., & Chen, L. (2004). On the properties of parametric geometric OWA operator. International Journal of Approximate Reasoning, 35, 163–178.MATHCrossRefMathSciNet Liu, X., & Chen, L. (2004). On the properties of parametric geometric OWA operator. International Journal of Approximate Reasoning, 35, 163–178.MATHCrossRefMathSciNet
go back to reference O’Hagan, M. (1988). Aggregating template or rule antecedents in real-time expert systems with fuzzy set logic. In Proceedings of the IEEE Asilomar Conference on Signals, Systems, Computers (pp. 81–89). Pacific Grove, USA. O’Hagan, M. (1988). Aggregating template or rule antecedents in real-time expert systems with fuzzy set logic. In Proceedings of the IEEE Asilomar Conference on Signals, Systems, Computers (pp. 81–89). Pacific Grove, USA.
go back to reference Tahani, V. (1977). A conceptual framework for fuzzy query processing: A step toward very intelligent database systems. Information Processing and Management, 13(5), 289–303.MATHCrossRef Tahani, V. (1977). A conceptual framework for fuzzy query processing: A step toward very intelligent database systems. Information Processing and Management, 13(5), 289–303.MATHCrossRef
go back to reference Takahashi, Y. (1993). Fuzzy database query languages and their relational completeness theorem. IEEE Transactions on Knowledge and Data Engineering, 5(1), 122–125.CrossRef Takahashi, Y. (1993). Fuzzy database query languages and their relational completeness theorem. IEEE Transactions on Knowledge and Data Engineering, 5(1), 122–125.CrossRef
go back to reference Vila, M. A., Cubero, J. C., Medina, J. M., & Pons, O. (1997). Using OWA operator in flexible query processing. In R. Yager & J. Kacprzyk (Eds.), The ordered weighted averaging operators: Theory and applications (pp. 258–274). Boston: Kluwer. Vila, M. A., Cubero, J. C., Medina, J. M., & Pons, O. (1997). Using OWA operator in flexible query processing. In R. Yager & J. Kacprzyk (Eds.), The ordered weighted averaging operators: Theory and applications (pp. 258–274). Boston: Kluwer.
go back to reference Yager, R. (1988). On ordered weighted averaging aggregation operators in multi-criteria decision making. IEEE Transactions on Systems, Man and Cybernetics, 18, 183–190.MATHCrossRefMathSciNet Yager, R. (1988). On ordered weighted averaging aggregation operators in multi-criteria decision making. IEEE Transactions on Systems, Man and Cybernetics, 18, 183–190.MATHCrossRefMathSciNet
go back to reference Yager, R. (2003). E-Z OWA weights. In T. Bilgiç, B. D. Baets & O. Kaynak (Eds.), Proceedings of the 10th IFSA World Congress (IFSA 2003), LNCS (Vol. 2715, pp. 39–42). Istanbul. Turkey: Springer. June 30–July 2, 2003. Yager, R. (2003). E-Z OWA weights. In T. Bilgiç, B. D. Baets & O. Kaynak (Eds.), Proceedings of the 10th IFSA World Congress (IFSA 2003), LNCS (Vol. 2715, pp. 39–42). Istanbul. Turkey: Springer. June 30–July 2, 2003.
go back to reference Yager, R. (2004). Uncertainty modeling and decision support. Reliability Engineering & System Safety, 85(1–3), 341–354.CrossRef Yager, R. (2004). Uncertainty modeling and decision support. Reliability Engineering & System Safety, 85(1–3), 341–354.CrossRef
go back to reference Yager, R., & Kacprzyk, J. (Eds.) (1997). The ordered weighted averaging operators: Theory and applications. Boston: Kluwer. Yager, R., & Kacprzyk, J. (Eds.) (1997). The ordered weighted averaging operators: Theory and applications. Boston: Kluwer.
go back to reference Zadeh, L. (1983). A computational approach to fuzzy quantifiers in natural languages. Computers and Mathematics with Applications, 9, 149–184.MATHCrossRefMathSciNet Zadeh, L. (1983). A computational approach to fuzzy quantifiers in natural languages. Computers and Mathematics with Applications, 9, 149–184.MATHCrossRefMathSciNet
Metadata
Title
Issues in the practical use of the OWA operators in fuzzy querying
Authors
Sławomir Zadrożny
Janusz Kacprzyk
Publication date
01-12-2009
Publisher
Springer US
Published in
Journal of Intelligent Information Systems / Issue 3/2009
Print ISSN: 0925-9902
Electronic ISSN: 1573-7675
DOI
https://doi.org/10.1007/s10844-008-0068-1

Other articles of this Issue 3/2009

Journal of Intelligent Information Systems 3/2009 Go to the issue

Premium Partner