Abstract
We present how the paradigm of computing with words may contribute to user-friendliness and effectiveness of database querying. We illustrate our exposition with the latest version of our FQUERY for Access system, a fuzzy querying user-friendly interface to Microsoft Access. The system accommodates fuzzy (imprecise) terms and linguistic quantifiers allowing for more human-consistent queries. The system employs Zadeh’s (1983) fuzzy logic based calculus of linguistically quantified propositions. Alternatively, Yager’s (1988) ordered weighted averaging (OWA) operators may be used to deal with fuzzy linguistic quantifiers.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Literature
Bordogna G., P. Carrara and G. Pasi (1995) Fuzzy approaches to extend Boolean information retrieval. In: P. Bosc and J. Kacprzyk (Eds.) Fuzziness in Database Management Systems, Physica-Verlag, Heidelberg, pp. 231–274.
Bosc P., M. Galibourg and G. Hauron (1988) Fuzzy querying with SQL: extensions and implementations aspects. Fuzzy Sets and Systems 28, 333–349.
Bosc P. and J. Kacprzyk, Eds. (1995) Fuzziness in Database Management Systems. Physica-Verlag, Heidleberg
Bosc P. and O. Pivert (1992) Fuzzy querying in conventional databases. In L.A. Zadeh and J. Kacprzyk (Eds.): Fuzzy Logic for the Management of Uncertainty. Wiley, New York, pp. 645–671.
Bosc P. and O. Pivert (1994) SGLf: a relational database language for fuzzy querying. IEEE Trans. on Fuzzy Systems (to appear).
Bosc P., L. Lietard and O. Pivert (1995) Quantified statements and database fuzzy querying. In P. Bosc and J. Kacprzyk (Eds.): Fuzziness in Database Management Systems. Physica-Verlag, Heidelberg, pp. 275–308.
Buckles B.P. and Petry F.E. (1982) A fuzzy representation of data for relational databases. Fuzzy Sets and Syst. 7, 213–226.
Chang S.K. and Ke J.S. (1978) Database skeleton and its application to fuzzy query translation. IEEE Trans. on Software Eng. SE-4, 31–43.
Chang S.K. and Ke J.S. (1979) Translation of fuzzy queries for relational database systems. IEEE Trans. on Pattern Anal. and Machine. Intel. PAMI-1, 281–294.
Kacprzyk J. (1995) Fuzzy logic in DBMSs and querying, in N.K. Kasabov and G. Coghill (Eds.): Proceedings of Second New Zealand International Two-Stream Conference on Artificial Neural Networks and Expert Systems (Dunedin, New Zealand), IEEE Computer Society Press, Los Alamitos, CA, USA, pp. 106–109.
Kacprzyk J. and S. Zadrozny (1994a) Fuzzy querying for Microsoft Access. Proceedings of the Third IEEE Conference on Fuzzy Systems (Orlando, USA), Vol. 1, pp. 167–171.
Kacprzyk J. and S. Zadrozny (1994b) Fuzzy queries in Microsoft Access: toward a `more intelligent’ use of Microsoft Windows based DBMSs, Proceedings of the 1994 Second Australian and New Zealand Conference on Intelligent Information Systems–ANZIIS’94 ( Brisbane, Australia ), pp. 492–496.
Kacprzyk J. and S. Zadrozny (1995a) FQUERY for Access: fuzzy querying for a Windows-based DBMS. In: P. Bosc and J. Kacprzyk (Eds.) Fuzziness in Database Management Systems, Physica-Verlag, Heidelberg, pp. 415–433.
Kacprzyk J. and S. Zadrozny (1995b) Fuzzy queries in Microsoft Access v. 2, Proceedings of 6th International Fuzzy Systems Association World Congress (Sao Paolo, Brazil ), Vol. II, pp. 341–344.
Kacprzyk J. and S. Zadro6ny (1997a) Fuzzy queries in Microsoft Access v. 2, in D. Dubois, H. Prade and R.R. Yager (Eds.): Fuzzy Information Engineering–A Guided Tour of Applications, Wiley, New York, 1997, pp. 223–232.
Kacprzyk J. and S. Zadrozny (1997b) Implementation of OWA operators in fuzzy querying for Microsoft Access. In: R.R. Yager and J. Kacprzyk (Eds.) The Ordered Weighted Averaging Operators: Theory and Applications, Kluwer, Boston, 1997, pp. 293–306.
Kacprzyk and S. Zadrozny (1997c) Flexible querying using fuzzy logic: An implementation for Microsoft Access, in T. Andreasen, H. Christiansen and H.L. Larsen (eds.): Flexible Query Answering Systems, Kluwer, Boston, 1997, pp. 247–275.
Kacprzyk J., Zadrozny S. and Ziólkowski A. (1989) FQUERY III+: a ‘human consistent’ database querying system based on fuzzy logic with linguistic quantifiers. Information Systems 6, 443–453.
Kacprzyk J. and Ziólkowski A. (1986a) Retrieval from databases using queries with fuzzy linguistic quantifiers. In H. Prade and C.V. Negoita (Eds.) Fuzzy Logics in Knowledge Engineering. Verlag TÜV Rheinland, Cologne, pp. 4657.
Kacprzyk J. and Ziólkowski A. (1986b) Database queries with fuzzy linguistic quantifiers. IEEE Transactions on Systems, Man and Cybernetics SMC–16, 474–479.
Larsen H.L. and Yager R.R. (1993) The use of fuzzy relational thesauri for classificatory problem solving in information retrieval and expert systems. IEEE Trans. On Syst., Man and Cybern. SMC-23, 31–41.
Miyamoto S. (1990) Fuzzy Sets in Information Retrieval and Cluster Analysis. Kluwer Academic Publishers. Dordrecht, Boston, London.
Nomura T., Odaka T., Ohki N., Yokoyama T. And Matsuhita Y. (1992) Generating ambiguous attributes for fuzzy queries. Proceedings of IEEE International Conference on Fuzzy Systems (FUZZ-IEEE ‘82), 1992, pp. 753–760.
Petry F.E. (1996) Fuzzy Databases: Principles and Applications. Kluwer, Boston.
Tahani V. (1977) A conceptual framework for fuzzy query processing: a step toward very intelligent data systems. Inf. Proc and Management 13, 289–303.
Vila M.A., Cubero J.C., Medina J.M. and Pons O. (1994) Logic and fuzzy relational databases: a new language and a new definition. In Bosc P. and J. Kacprzyk (Eds.) Fuzziness in Database Management Systems. PhysicaVerlag, Heidleberg, pp. 114–138.
Yager R.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.R. and Kacprzyk J., Eds. (1997) The Ordered Weighted Averaging Operators: Theory and Applications. Kluwer, Boston.
Yazici A., R. George, B.P. Buckles and F.E. Petty (1992) A survey of conceptual and logical data models for uncertainty management. In L.A. Zadeh and J. Kacprzyk (Eds.): Fuzzy Logic for the Management of Uncertainty. Wiley, New York, pp. 607–643.
Yazici A. and R. George (1999) Fuzzy Database Modeling. Physica-Verlag, Heidelberg and New York.
Zadeh L.A. (1983) A computational approach to fuzzy quantifiers in natural languages. Computers and Maths. with Appls. 9, 149–184.
Zadrozny S. and J. Kacprzyk (1995) Fuzzy querying using the ‘query-by-example’ option in a Windows-based DBMS“, Proceedings of Third European Congress on Intelligent Techniques and Soft Computing–EUFIT’95 (Aachen, Germany), vol. 2, pp. 733–736.
Zadrozny S. and J. Kacprzyk (1996) Multi-valued fields and values in fuzzy querying via FQUERY for Access, Proceedings of FUZZ—lEEE’96–Fifth International Conference on Fuzzy Systems (New Orleans, USA), vol. 2, pp. 1351–1357.
Zemankova M. and J. Kacprzyk (1993) The roles of fuzzy logic and management of uncertainty in building intelligent information systems, Journal of Intelligent Information Systems 2, 311–317.
Zemankova-Leech M. and Kandel A. (1984) Fuzzy Relational Databases - a Key to Expert Systems. Verlag TÜV Rheinland, Cologne.
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 1999 Springer-Verlag Berlin Heidelberg
About this chapter
Cite this chapter
Kacprzyk, J., Zadrożny, S. (1999). The Paradigm of Computing with Words in Intelligent Database Querying. In: Zadeh, L.A., Kacprzyk, J. (eds) Computing with Words in Information/Intelligent Systems 2. Studies in Fuzziness and Soft Computing, vol 34. Physica, Heidelberg. https://doi.org/10.1007/978-3-7908-1872-7_18
Download citation
DOI: https://doi.org/10.1007/978-3-7908-1872-7_18
Publisher Name: Physica, Heidelberg
Print ISBN: 978-3-7908-2461-2
Online ISBN: 978-3-7908-1872-7
eBook Packages: Springer Book Archive