A Fuzzy Valid-Time Model for Relational Databases within the Hibernate Framework

  • Jose Enrique Pons
  • Olga Pons Capote
  • Ignacio Blanco Medina
Part of the Lecture Notes in Computer Science book series (LNCS, volume 7022)


Time in databases has been studied for a long time. Valid time databases capture when the objects are true in the reality. The proposed model allows both representing and querying time in a fuzzy way. The representation and the underlying domain are defined as well as some fuzzy temporal operators. The implementation of the model is developed within the Hibernate framework. The Hibernate framework acts as an abstraction for the running database. Therefore, any relational database supported by the framework can now represent fuzzy valid time in its schema.


Relational Database Valid Time Fuzzy Operator Temporal Database Fuzzy Interval 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    Allen, J.F.: Maintaining knowledge about temporal intervals. Commun. ACM 26, 832–843 (1983)CrossRefzbMATHGoogle Scholar
  2. 2.
    Bohlen, M., Busatto, R., Jensen, C.: Point-versus interval-based temporal data models. In: Proceedings of the 14th International Conference on Data Engineering, pp. 192–200 (February 1998)Google Scholar
  3. 3.
    Van der Cruyssen, B., De Caluwe, R., De Tré, G.: A theoretical fuzzy time model based on granularities. In: EUFIT 1997, pp. 1127–1131 (September 1997)Google Scholar
  4. 4.
    De Tre, G., De Caluwe, R., Van Der Cruyssen, B., Van Gyseghem, N.: Towards temporal fuzzy and uncertain object-oriented database management systems. In: 1997 Annual Meeting of the North American Fuzzy Information Processing Society, NAFIPS 1997, pp. 68–72 (September 1997)Google Scholar
  5. 5.
    Dubois, D., Prade, H.: Processing fuzzy temporal knowledge. IEEE Transactions on Systems, Man and Cybernetics 19(4), 729–744 (1989)MathSciNetCrossRefGoogle Scholar
  6. 6.
    Dyreson, C., et al.: A consensus glossary of temporal database concepts. SIGMOD Rec. 23, 52–64 (1994)CrossRefGoogle Scholar
  7. 7.
    Fliegel, H.F., van Flandern, T.C.: Letters to the editor: a machine algorithm for processing calendar dates. Commun. ACM 11, 657 (1968)CrossRefGoogle Scholar
  8. 8.
    Galindo, J., Medina, J.: Ftsql2: Fuzzy time in relational databases. In: Proceedings EUSFLAT 2001, pp. 47–50 (2001)Google Scholar
  9. 9.
    Galindo, J., Medina, J.M., Pons, O., Cubero, J.: A server for fuzzy SQL queries. In: Andreasen, T., Christiansen, H., Larsen, H.L. (eds.) FQAS 1998. LNCS (LNAI), vol. 1495, pp. 164–174. Springer, Heidelberg (1998)CrossRefGoogle Scholar
  10. 10.
    Galindo, J., Urrutia, A., Piattini, M.: Fuzzy Databases: Modeling, Design and Implementation. Idea Group, Chocolate Avenue, Suite 200, Hershey PA 17033 (2006)Google Scholar
  11. 11.
    Garrido, C., Marin, N., Pons, O.: Fuzzy intervals to represent fuzzy valid time in a temporal relational database. International Journal of Uncertainty, Fuzziness and Knowlege-Based Systems 17(suppl. 1), 173–192 (2009)CrossRefzbMATHGoogle Scholar
  12. 12.
    Jensen, C.S., Mark, L., Roussopoulos, N.: Incremental implementation model for relational databases with transaction time. IEEE Trans. on Knowl. and Data Eng. 3, 461–473 (1991)CrossRefGoogle Scholar
  13. 13.
    King, G., Bauer, C., Andersen, M.R., Bernard, E., Ebersole, S., Ferentschik, H.: Hibernate Reference Documentation, 3.6.0.cr2 edn.,
  14. 14.
    Lin, H., Jensen, C.S., Ohlen, M.H.B., Busatto, R., Gregersen, H., Torp, K., Snodgrass, R.T., Datta, A., Ram, S.: Efficient conversion between temporal granularities (1997)Google Scholar
  15. 15.
    Rowe, L., Stonebreker, M.: The postgres papers (June 1987)Google Scholar
  16. 16.
    Martínez Cruz, C.: Sistema de gestión de bases de datos relacionales difusas multipropósito. Una ontología para la representación del conocimiento difuso. Ph.D. thesis, Universidad de Granada (2008)Google Scholar
  17. 17.
    Medina, J., Pons, O., Cubero, J.: Gefred. a generalized model of fuzzy relational databases. Information Sciences 76(1-2), 87–109 (1994)CrossRefGoogle Scholar
  18. 18.
    Melton, J., Simon, A.R.: Understanding the new SQL: a complete guide. Morgan Kaufmann Publishers Inc., San Francisco (1993)Google Scholar
  19. 19.
    Nagypál, G., Motik, B.: A fuzzy model for representing uncertain, subjective, and vague temporal knowledge in ontologies. In: Chung, S., Schmidt, D.C. (eds.) CoopIS 2003, DOA 2003, and ODBASE 2003. LNCS, vol. 2888, pp. 906–923. Springer, Heidelberg (2003)CrossRefGoogle Scholar
  20. 20.
    Nascimento, M.A., Eich, M.H.: Decision time in temporal databases. In: Proceedings of the Second International Workshop on Temporal Representation and Reasoning, pp. 157–162 (1995)Google Scholar
  21. 21.
    Pons, J.E., Pons, O., Blanco Medina, I.: An open source framework for fuzzy representation and querying in fuzzy databases. In: Nunes, M.B., Pedro Isaas, P. P. (eds.) Proceedings of the IADIS International Conference Informations Systems (March 2011)Google Scholar
  22. 22.
    ng, Y., Asmussen, K., Delafontaine, M., De Tré, G., Stichelbaut, B., De Maeyer, P., Van de Weghe, N.: Visualising rough time intervals in a two-dimensional space. In: Proceedings 2009 IFSA World Congress/EUSFLAT Conference (July 2001)Google Scholar
  23. 23.
    Schockaert, S., De Cock, M., Kerre, E.: Fuzzifying allen’s temporal interval relations. IEEE Transactions on Fuzzy Systems 16(2), 517–533 (2008)CrossRefGoogle Scholar
  24. 24.
    Snodgrass, R.: The temporal query language tquel. In: Proceedings of the 3rd ACM SIGACT-SIGMOD Symposium on Principles of Database Systems, PODS 1984, pp. 204–213. ACM, New York (1984)Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2011

Authors and Affiliations

  • Jose Enrique Pons
    • 1
  • Olga Pons Capote
    • 1
  • Ignacio Blanco Medina
    • 1
  1. 1.Department of Computer Science and Artificial IntelligenceUniversidad de Granada, Escuela Técnica Superior de Ingeniería InformáticaGranadaSpain

Personalised recommendations