Abstract
This paper presents a flexible fuzzy-based approach for querying relational databases. Although, many fuzzy query approaches have been proposed, there is a need for a more flexible, simple and human-like query approach. Most of previously proposed fuzzy query approaches have a disadvantage that they interpret any fuzzy query statement into a crisp query statement then evaluate the resulted tuples to compute their matching degrees to the fuzzy query. The main objective of the proposed fuzzy query approach of this paper is to overcome the above disadvantage by evaluating each tuple directly through the use of stored database objects namely packages, procedures and functions. Consequently, the response time of executing a fuzzy query statement will be reduced. This proposed approach makes it easy to use fuzzy linguistic values in all clauses of a select statement. The added value of this proposed approach is to accelerate the execution of fuzzy query statements.
Access provided by Autonomous University of Puebla. Download to read the full chapter text
Chapter PDF
Similar content being viewed by others
References
Mishra, J.: Fuzzy Query Processing. International Journal of Research and Reviews in Next Generation Networks 1(1) (March 2011)
Grissa, A., Ben Hassine, M.: New Architecture of Fuzzy Database Management Systems. The International Arab Journal of Information Technology 6(3) (July 2009)
Qi, Y., et al.: Efficient Processing of Nested Fuzzy SQL Queries in a Fuzzy Database. IEEE Transactions on Knowledge and Data Engineering 13(6) (November/December 2001)
Abbaci, K., Lemos, F., Hadjali, A., Grigori, D., Liétard, L., Rocacher, D., Bouzeghoub, M.: Selecting and Ranking Business Processes with Preferences: An Approach Based on Fuzzy Sets. In: Meersman, R., Dillon, T., Herrero, P., Kumar, A., Reichert, M., Qing, L., Ooi, B.-C., Damiani, E., Schmidt, D.C., White, J., Hauswirth, M., Hitzler, P., Mohania, M., et al. (eds.) OTM 2011, Part I. LNCS, vol. 7044, pp. 38–55. Springer, Heidelberg (2011)
Singh, K., et al.: Study of Imperfect Information Representation and FSQL processing. International Journal of Scientific & Engineering Research 3(5) (May 2012)
Garg, A., Rishi, R.: Querying Capability Enhancement in Database Using Fuzzy Logic. Global Journal of Computer Science and Technology 12(6) (Version 1.0 March 2012)
Wahidin, I.: Fuzzy Control (2007)
Gadallah, A., Hefny, H.: An Efficient Database Query Processing Tool Based on Fuzzy Logic. In: The 37th Annual Conference on Statistics and Computer Science (2002)
Shawky, A., et al.: FRDBM: A Tool For Building Fuzzy Relational Databases. The Egyptian Computer Journal (2006)
Galindo, J., et al.: Handbook of Research on Fuzzy Information Processing in Databases. Chapter XI FSQL and SQLf: Towards a Standard in Fuzzy Databases (2008)
Bosc, P., Pivert, O.: SQLf Query Functionality on Top of a Regular Relational Database Management. In: Pons, O., Vila, M.A., Kacprzyk, J. (eds.) Proceedings of Knowledge Management in Fuzzy Databases. STUDFUZZ, vol. 39, pp. 171–190. Springer, Heidelberg (2000)
Moore, S.: Oracle Database PL/SQL Language Reference, 12c, p. 1 (2014)
Elmasri, R., Navathe, S.B.: Fundamental of Database Systems (2011)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2014 Springer International Publishing Switzerland
About this paper
Cite this paper
Sabour, A.A., Gadallah, A.M., Hefny, H.A. (2014). Flexible Querying of Relational Databases: Fuzzy Set Based Approach. In: Hassanien, A.E., Tolba, M.F., Taher Azar, A. (eds) Advanced Machine Learning Technologies and Applications. AMLTA 2014. Communications in Computer and Information Science, vol 488. Springer, Cham. https://doi.org/10.1007/978-3-319-13461-1_42
Download citation
DOI: https://doi.org/10.1007/978-3-319-13461-1_42
Publisher Name: Springer, Cham
Print ISBN: 978-3-319-13460-4
Online ISBN: 978-3-319-13461-1
eBook Packages: Computer ScienceComputer Science (R0)