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

01.12.2009

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

verfasst von: Sławomir Zadrożny, Janusz Kacprzyk

Erschienen in: Journal of Intelligent Information Systems | Ausgabe 3/2009

Einloggen

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

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.

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
Zurück zum Zitat 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
Zurück zum Zitat 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.
Zurück zum Zitat 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.
Zurück zum Zitat 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
Zurück zum Zitat 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.
Zurück zum Zitat 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
Zurück zum Zitat 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
Zurück zum Zitat 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
Zurück zum Zitat 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
Zurück zum Zitat 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
Zurück zum Zitat 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.
Zurück zum Zitat ISO/ANSI (2003). Database Languages – SQL, ISO/IEC 9075-*:2003. ISO/ANSI (2003). Database Languages – SQL, ISO/IEC 9075-*:2003.
Zurück zum Zitat 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.
Zurück zum Zitat 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
Zurück zum Zitat 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
Zurück zum Zitat 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
Zurück zum Zitat 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.
Zurück zum Zitat 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
Zurück zum Zitat 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.
Zurück zum Zitat 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
Zurück zum Zitat 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
Zurück zum Zitat 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.
Zurück zum Zitat 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
Zurück zum Zitat 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.
Zurück zum Zitat 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
Zurück zum Zitat 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.
Zurück zum Zitat 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
Metadaten
Titel
Issues in the practical use of the OWA operators in fuzzy querying
verfasst von
Sławomir Zadrożny
Janusz Kacprzyk
Publikationsdatum
01.12.2009
Verlag
Springer US
Erschienen in
Journal of Intelligent Information Systems / Ausgabe 3/2009
Print ISSN: 0925-9902
Elektronische ISSN: 1573-7675
DOI
https://doi.org/10.1007/s10844-008-0068-1

Weitere Artikel der Ausgabe 3/2009

Journal of Intelligent Information Systems 3/2009 Zur Ausgabe