Fuzzy Querying based Tool for Building Courses Evaluation Tests

Livia Borjas, Josué Ramírez, Rosseline Rodríguez, Leonid Tineo


In this paper, we present a tool intended for helping in exam configuration based on the reutilization of questions according to user preferences. It is a real life application of fuzzy querying that fulfils an actual need of academic personal at a high studies institution of Venezuela. This application uses the fuzzy querying language SQLf, on top of an existing relational DBMS by means a logic layer named SQLfi. Final users of our application are professors of any area without knowledge of fuzzy sets and databases. We use criteria for the test preparation that support fuzzy terms. These terms can be adjusted to user preferences. Graphic user interfaces are provided in order to perform such adjusts as well as exam configuration and any other fuzzy querying operation. We present here the Database Design, the process test construction and the management of preferences.


  1. Bosc, P., Pivert, O., 1995a. SQLf: A Relational Database Language for Fuzzy Querying. In: IEEE Transactions on Fuzzy Systems, Vol 3, No. 1.
  2. Bosc, P., Pivert, O., 1995b, On the Efficiency of the Alpha-cut Distribution Method to Evaluate Simple Fuzzy Relational Queries. In: Advances in Fuzzy Systems-Applications and Theory, Vol. 4, Fuzzy Logic and Soft Computing. Bouchon-Meunier, B., Yager, R. and Zadeh, L. (Eds.), Wold Scientific, pp. 251-260.
  3. Cadenas, J., Aguilera, A., Tineo, L., 2011. Rendimiento de consultas SQLf en arquitecturas débil y fuertemente acopladas. In: Multiciencias. Vol. 11, pp. 410-415.
  4. Cox, E., 1995. Relational Database Queries using Fuzzy Logic. In: Artificial Intelligent Expert, pp 23-29.
  5. Delgado, G., Aranda, V., Calero, J., Sánchez-Marañón, M., Serrano, J. M., Sánchez, D. and Vila, M. A., 2008. Building a fuzzy logic information network and a decision-support system for olive cultivation in Andalusia. In: Spanish Journal of Agricultural Research, Vol. 6, No. 2, pp. 252 - 263.
  6. Fernández, A., Tineo, L., Ortiz, J., Borjas, L., 2008. FBMS Application for a Survey on Educational Performance. In: LNCS. Vol. 5181, pp. 753-760.
  7. Galindo, J., 2005. New Characteristics in FSQL, a Fuzzy SQL for Fuzzy Databases. In: WSEAS Transactions on Information Science and Applications 2. Vol. 2, pp. 161-169.
  8. Galindo, J., 2008. Handbook of Research on Fuzzy Information Processing in Databases. Hershey, PA, USA: Information Science.
  9. Galindo, J., Urrutia, A., Piattini, M., 2006. Some Applications of Fuzzy Databases with FSQL, In: Fuzzy Databases: Modeling, Design and Implementation, Idea Group Inc.
  10. Goncalves, M., Tineo L., 2008. SQLfi and its Applications. In: Revista Avances en Sistemas e Informática, Vol. 5, No. 2, pp. 33-40.
  11. González, C., Goncalves, M., Tineo, L., 2009. 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.
  12. Kacpryzyk, J., Zadrozny, S., 1995. Fuzzy Queries in Microsoft AccessTM v.2. In: Proc. of Fuzzy IEEE'95 Workshop on Fuzzy Database Systems and Information Retrieval.
  13. Ma, Z. M., Yan, L., 2010. A Literature Overview of Fuzzy Conceptual Data Modeling. In: Journal of Information Science and Engineering, Vol. 26, No. 2, pp. 427-441.
  14. Nakajima H. et al, 1983. Fuzzy Database Language and Library-Fuzzy Extension to SQL. In: Proc. of Second IEEE International Conference on Fuzzy Systems. pp. 477-482.
  15. Pivert, O., Bosc, P., 2012. Fuzzy Preference Queries to Relational Databases. Imperial College Press.
  16. Yager, R., 2010. Soft Querying of Standard and Uncertain Databases. In: IEEE Transactions on Fuzzy Systems. Vol. 18, No. 2, pp. 336-347.
  17. Zadeh, L.A., 1965. Fuzzy sets. In: Information and Control 8. pp 338-353.
  18. Zhao, F.X., Ma, Z.M., 2009. Vague Query Based on Vague Relational Model. In: Yu W. and Sanchez (Eds.). Advances in Computational Intelligence, Vol. 61, pp. 229 - 238.

Paper Citation

in Harvard Style

Borjas L., Ramírez J., Rodríguez R. and Tineo L. (2012). Fuzzy Querying based Tool for Building Courses Evaluation Tests . In Proceedings of the 4th International Joint Conference on Computational Intelligence - Volume 1: FCTA, (IJCCI 2012) ISBN 978-989-8565-33-4, pages 343-349. DOI: 10.5220/0004151003430349

in Bibtex Style

author={Livia Borjas and Josué Ramírez and Rosseline Rodríguez and Leonid Tineo},
title={Fuzzy Querying based Tool for Building Courses Evaluation Tests},
booktitle={Proceedings of the 4th International Joint Conference on Computational Intelligence - Volume 1: FCTA, (IJCCI 2012)},

in EndNote Style

JO - Proceedings of the 4th International Joint Conference on Computational Intelligence - Volume 1: FCTA, (IJCCI 2012)
TI - Fuzzy Querying based Tool for Building Courses Evaluation Tests
SN - 978-989-8565-33-4
AU - Borjas L.
AU - Ramírez J.
AU - Rodríguez R.
AU - Tineo L.
PY - 2012
SP - 343
EP - 349
DO - 10.5220/0004151003430349