Abstract
In most of fuzzy querying systems, items in query conditions are assumed to carry equal importance, although it might not actually to be the case. Issues for expressing users’ preferences to query conditions are presented here. Relative importance between query items is introduced. Standard SQL is extended to express weighted fuzzy queries, such as sub-queries, multi-table queries; set-oriented queries etc. which make the existing relational database systems more flexible and more intelligent to users.
This work is supported in part by the Science and technology developing plan of Jiangsu province, under Grant (BR2004012).
This is a preview of subscription content, log in via an institution to check access.
Preview
Unable to display preview. Download preview PDF.
Similar content being viewed by others
References
Hong, Z., Xiao-Ling, X., Le-yu, W.: The design of database query tool based on the fuzzy algorithm. Application research of computers 5, 15–17 (2001)
Rong, Z.: The research of query technique based on the fuzzy theory. Application research of computers 5, 8–29 (2003)
Bo, H.: The representation and implementation of fuzzy query based on extended SQL. Journal of Wuhan Technical university of Surveying and Mapping 21, 86–89 (1996)
Chen, S.-M., Lin, Y.-S.: A new method for fuzzy query processing in relational database system. Cybernetics and Systems 33, 447–482 (2002)
Takahashi, Y.: A fuzzy query language for relational database. IEEE transaction on systems, man, and cybernetics 21, 1576–1579 (1991)
Chen, S.-M., Jong, W.-T.: Fuzzy query translation for relational database. IEEE transaction on systems, man, and cybernetics-part B: Cybernetics 27, 714–721 (1997)
Zadeh, L.A.: A Fuzzy-Set-Theoretic Interpretation of Linguistic Hedges. Journal of Cybernetics 2, 4–34 (1972)
Paul, B.K.: The Logic of Weighted Queries. IEEE transaction on systems, man, and cybernetics SMC-11, 816–821 (1981)
Kacprzyk, J., Zadrozny, S., Ziolkowski, A.: Fquery III+:A “Human_Consistent” database querying system based on fuzzy logic with linguistic quantifiers. Information Sciences 14, 443–453 (1989)
Sanchez, E.: Importance in Knowledge Systems. Information Systems 14, 455–464 (1989)
Zadeh, L.A.: The concept of a linguistic variable and its application to approximate reasoning, Part I II. Information Science 8, 199-249, 301-357 (1975)
Bosc, P., Pivert, O.: SQLf: A relational Database Language for Fuzzy Querying. IEEE Transactions on Fuzzy Systems 3, 1–17 (1995)
Bosc, P.: On the permittivity of the division of fuzzy relations. Soft Computing 2, 35–47 (1998)
Bosc, P., Legrand, C., Pivert, O.: About Fuzzy Query Processing——The Example of the Division. In: 1999 IEEE International Fuzzy Systems Conference Proceedings II, pp. 592–597 (1999)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2005 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Zhang, YC., Chen, YF., Ye, Xl., Zheng, JL. (2005). Weighted Fuzzy Queries in Relational Databases. In: Wang, L., Jin, Y. (eds) Fuzzy Systems and Knowledge Discovery. FSKD 2005. Lecture Notes in Computer Science(), vol 3614. Springer, Berlin, Heidelberg. https://doi.org/10.1007/11540007_53
Download citation
DOI: https://doi.org/10.1007/11540007_53
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-28331-7
Online ISBN: 978-3-540-31828-6
eBook Packages: Computer ScienceComputer Science (R0)