Abstract
In order to deal with user preferences and imperfect information in databases, a proposed solution is to apply fuzzy logic. It has given birth to fuzzy logic based extensions of SQL, such as SQLf. We present a real life application of fuzzy querying that fulfils an actual need of academic personal at a high studies institution. This application helps professors in tests preparation and configuration based on the reutilization of previously proposed questions. These questions are stored in a relational database keeping tracks of some interesting measures about difficult, answer time, correction time and so on. Queries as well as user preferences are specified using a graphic user interface. Thus professors must not directly deal with a query language and fuzzy logic concepts, but with an intuitive interface. The application is built on the SQLfi fuzzy querying engine that is a logic layer on top of existing relational DBMS.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Similar content being viewed by others
References
Bosc, P., Pivert, O.: SQLf: A Relational Database Language for Fuzzy Querying. IEEE Transactions on Fuzzy Systems 3(1) (1995)
Bosc, P., Pivert, O.: On the Efficiency of the Alpha-cut Distribution Method to Evaluate Simple Fuzzy Relational Queries. In: Bouchon-Meunier, B., Yager, R., Zadeh, L. (eds.) Advances in Fuzzy Systems-Applications and Theory. Fuzzy Logic and Soft Computing, vol. 4, pp. 251–260. World Scientific (1995)
Cadenas, J., Aguilera, A., Tineo, L.: Rendimiento de consultas SQLf en arquitecturas débil y fuertemente acopladas. Multiciencias 11, 410–415 (2011)
Cox, E.: Relational Database Queries using Fuzzy Logic. Artificial Intelligent Expert, 23–29 (1995)
Curiel, M., González, C., Tineo, L., Urrutia, A.: On the Performance of Fuzzy Data Querying. In: Greco, S., Lukasiewicz, T. (eds.) SUM 2008. LNCS (LNAI), vol. 5291, pp. 134–145. Springer, Heidelberg (2008)
Delgado, G., Aranda, V., Calero, J., Sánchez-Marañón, M., Serrano, J.M., Sánchez, D., Vila, M.A.: Building a fuzzy logic information network and a decision-support system for olive cultivation in Andalusia. Spanish Journal of Agricultural Research 6(2), 252–263 (2008)
Borjas, L., Fernández, A., Ortiz, J., Tineo, L.: FDBMS Application for a Survey on Educational Performance. In: Bhowmick, S.S., Küng, J., Wagner, R. (eds.) DEXA 2008. LNCS, vol. 5181, pp. 753–760. Springer, Heidelberg (2008)
Galindo, J.: New Characteristics in FSQL, a Fuzzy SQL for Fuzzy Databases. WSEAS Transactions on Information Science and Applications 2(2), 161–169 (2005)
Galindo, J.: Handbook of Research on Fuzzy Information Processing in Databases. Information Science, Hershey (2008)
Galindo, J., Urrutia, A., Piattini, M.: Some Applications of Fuzzy Databases with FSQL. In: Fuzzy Databases: Modeling, Design and Implementation. Idea Group Inc. (2006)
Goncalves, M., Tineo, L.: SQLfi and its Applications. Revista Avances en Sistemas e Informática 5(2), 33–40 (2008)
González, C., Goncalves, M., Tineo, L.: A New Upgrade to SQLf: Towards an Standard in Fuzzy Databases. In: 20th International Workshop on Database and Expert Systems Application Proceeding, pp. 442–446 (2009)
Kacpryzyk, J., Zadrozny, S.: Fuzzy Queries in Microsoft AccessTM v.2. In: Proc. of Fuzzy IEEE 1995 Workshop on Fuzzy Database Systems and Information Retrieval (1995)
Ma, Z.M., Yan, L.: A Literature Overview of Fuzzy Conceptual Data Modeling. Journal of Information Science and Engineering 26(2), 427–441 (2010)
Nakajima, H., et al.: Fuzzy Database Language and Library-Fuzzy Extension to SQL. In: Proc. of Second IEEE International Conference on Fuzzy Systems, pp. 477–482 (1983)
Pivert, O., Bosc, P.: Fuzzy Preference Queries to Relational Databases. Imperial College Press (2012)
Timarán, R.: Arquitecturas de Integración del Proceso de Descubrimiento de Conocimiento con Sistemas de Gestión de Bases de Datos: un Estado del Arte. Ingeniería y Competitividad 3(2) (2001)
Yager, R.: Soft Querying of Standard and Uncertain Databases. IEEE Transactions on Fuzzy Systems 18(2), 336–347 (2010)
Zadeh, L.A.: Fuzzy sets. Information and Control 8, 338–353 (1965)
Zhao, F.X., Ma, Z.M.: Vague Query Based on Vague Relational Model. In: Yu, W., Sanchez, E.N. (eds.) Advances in Computational Intelligence. AISC, vol. 61, pp. 229–238. Springer, Heidelberg (2009)
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2015 Springer International Publishing Switzerland
About this paper
Cite this paper
Borjas, L., Ramírez, J., Rodríguez, R., Tineo, L. (2015). Automated System for Tests Preparation and Configuration Using Fuzzy Queries. In: Madani, K., Correia, A., Rosa, A., Filipe, J. (eds) Computational Intelligence. IJCCI 2012. Studies in Computational Intelligence, vol 577. Springer, Cham. https://doi.org/10.1007/978-3-319-11271-8_13
Download citation
DOI: https://doi.org/10.1007/978-3-319-11271-8_13
Publisher Name: Springer, Cham
Print ISBN: 978-3-319-11270-1
Online ISBN: 978-3-319-11271-8
eBook Packages: EngineeringEngineering (R0)