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.
This is a preview of subscription content, log in via an institution to check access.
Similar content being viewed by others
References
Bosc, P., & Kacprzyk, J. (Eds.) (1995). Fuzziness in database management systems. Heidelberg: Physica-Verlag.
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., & 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., & Pivert, O. (1995). SQLf: A relational database language for fuzzy querying. IEEE Transactions on Fuzzy Systems, 3(1), 1–17.
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.
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
Filev, D., & Yager, R. (1995). Analytic properties of maximum entropy OWA operators. Information Sciences, 85, 11–27.
Filev, D., & Yager, R. (1998). On the issue of obtaining OWA operator weights. Fuzzy Sets and Systems, 94, 157–169.
Fuller, R., & Majlender, P. (2001). An analytic approach for obtaining maximal entropy OWA operator weights. Fuzzy Sets and Systems, 124(1), 53–57.
Fuller, R., & Majlender, P. (2003). On obtaining minimal variability OWA operator weights. Fuzzy Sets and Systems, 136(2), 203–215.
Galindo, J. (Ed.) (2008). Handbook of research on fuzzy information processing in databases. Hershey: Idea Group.
ISO/ANSI (2003). Database Languages – SQL, ISO/IEC 9075-*:2003.
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. (2001). Computing with words in intelligent database querying: Standalone and internet-based applications. Information Sciences, 134(1–4), 71–109.
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.
Kacprzyk, J., & Ziółkowski, A. (1986). Database queries with fuzzy linguistic quantifiers. IEEE Transactions on System, Man and Cybernetics, 16(3), 474–479.
Larsen, H. L. (1999). Importance weighted OWA aggregation of multicriteria queries. In Proceedings of the NAFIPS’99 conference (pp. 740–744). New York.
Liu, X., & Chen, L. (2004). On the properties of parametric geometric OWA operator. International Journal of Approximate Reasoning, 35, 163–178.
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.
Sonalysts Inc. (2003). Fuzzy Query for Windows. http://fuzzy.sonalysts.com/fuzzyquery.htm.
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.
Takahashi, Y. (1993). Fuzzy database query languages and their relational completeness theorem. IEEE Transactions on Knowledge and Data Engineering, 5(1), 122–125.
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.
Yager, R. (1988). On ordered weighted averaging aggregation operators in multi-criteria decision making. IEEE Transactions on Systems, Man and Cybernetics, 18, 183–190.
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. (2004). Uncertainty modeling and decision support. Reliability Engineering & System Safety, 85(1–3), 341–354.
Yager, R., & Kacprzyk, J. (Eds.) (1997). The ordered weighted averaging operators: Theory and applications. Boston: Kluwer.
Zadeh, L. (1983). A computational approach to fuzzy quantifiers in natural languages. Computers and Mathematics with Applications, 9, 149–184.
Author information
Authors and Affiliations
Corresponding author
Rights and permissions
About this article
Cite this article
Zadrożny, S., Kacprzyk, J. Issues in the practical use of the OWA operators in fuzzy querying. J Intell Inf Syst 33, 307–325 (2009). https://doi.org/10.1007/s10844-008-0068-1
Accepted:
Published:
Issue Date:
DOI: https://doi.org/10.1007/s10844-008-0068-1