Building a Fuzzy Valid Time Support Module on a Fuzzy Object-Relational Database

  • Carlos D. Barranco
  • Juan Miguel Medina
  • José Enrique Pons
  • Olga Pons
Part of the Lecture Notes in Computer Science book series (LNCS, volume 8132)


In this work we present the implementation of a Fuzzy Valid Time Support Module on top of a Fuzzy Object-Relational Database System, based on a model to deal with imprecision in valid-time databases. The integration of these modules allows to perform queries that combines fuzzy valid time constraints with fuzzy predicates. Both modules can be deployed in Oracle Relational Database Management System 10.2 and higher. The module implements the mechanisms that overload the SQL sentences: Insert, Update, Delete and Select to allow fuzzy temporal handling. The implementation described supports the crisp valid time model as a particular case of its fuzzy valid time support provided.


Fuzzy Databases Fuzzy Object-Relational Data Base System Fuzzy Temporal Databases 


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    Barranco, C.D., Campaña, J.R., Medina, J.M.: Towards a fuzzy object-relational database model. In: Galindo, J. (ed.) Handbook of Research on Fuzzy Information Processing in Databases, pp. 435–461. IGI Global (2008)Google Scholar
  2. 2.
    Buckles, B.P., Petry, F.E.: A fuzzy representation of data for relational databases. Fuzzy Sets and Systems 7(3), 213–226 (1982)zbMATHCrossRefGoogle Scholar
  3. 3.
    Codd, E.F.: Extending the database relational model to capture more meaning. ACM Transactions on Database Systems 4, 397–434 (1979)CrossRefGoogle Scholar
  4. 4.
    Cubero, J.C., Marín, N., Medina, J.M., Pons, O., Vila, M.A.: Fuzzy object management in an object-relational framework. In: Proc. 10th Int. Conf. on Information Processing and Management of Uncertainty in Knowledge-Based Systems, IPMU 2004, pp. 1767–1774 (2004)Google Scholar
  5. 5.
    Dubois, D., Prade, H.: Possibility Theory: An Approach to Computerized Processing of Uncertainty. Plenum Press, New York (1988)zbMATHCrossRefGoogle Scholar
  6. 6.
    Dubois, D., Prade, H.: Processing fuzzy temporal knowledge. IEEE Transactions on Systems, Man, and Cybernetics 19, 729–744 (1989)MathSciNetCrossRefGoogle Scholar
  7. 7.
    Dyreson, C., Grandi, F.E.A.: A consensus glossary of temporal database concepts. SIGMOD Rec. 23, 52–64 (1994)CrossRefGoogle Scholar
  8. 8.
    Galindo, J., Medina, J.M.: Ftsql2: Fuzzy time in relational databases. In: EUSFLAT Conf. 2001, pp. 47–50 (2001)Google Scholar
  9. 9.
    Garrido, C., Marin, N., Pons, O.: Fuzzy intervals to represent fuzzy valid time in a temporal relational database. Int. J. Uncertainty Fuzziness Knowlege-Based Syst. 17, 173–192 (2009)zbMATHCrossRefGoogle Scholar
  10. 10.
    Jensen, C.S., Mark, L., Roussopoulos, N.: Incremental implementation model for relational databases with transaction time. IEEE Trans. Knowl. Data Eng. 3, 461–473 (1991)CrossRefGoogle Scholar
  11. 11.
    Kurutach, W.: Modelling fuzzy interval-based temporal information: a temporal database perspective. Fuzzy Systems 2, 741–748 (1995)Google Scholar
  12. 12.
    Medina, J., Pons, O., Cubero, J.: GEFRED. a generalized model of fuzzy relational databases. Information Sciences 76, 87–109 (1994)CrossRefGoogle Scholar
  13. 13.
    Mitra, D., Srinivasan, P., Gerard, M., Hands, A.: A possibilistic interval constraint problem: Fuzzy temporal reasoning. In: Proc. of the Third IEEE Conference on IEEE World Congress on Computational Intelligence Fuzzy Systems, vol. 2, pp. 1434–1439 (June 1994)Google Scholar
  14. 14.
    Nascimento, M.A., Eich, M.H.: Decision time in temporal databases. In: Proceedings of the 2nd Int. Workshop on Temporal Representation and Reasoning, pp. 157–162 (1995)Google Scholar
  15. 15.
    Oracle: Oracle database 11g. workspace manager overview (2012)Google Scholar
  16. 16.
    Oracle: Sql language reference. In: Oracle Database v. 11.2. Documentation, pp. 1–1522 (July 2012),
  17. 17.
    Pons, J.E., Billiet, C., Pons Capote, O., De Tré, G.: A possibilistic valid-time model. In: Greco, S., Bouchon-Meunier, B., Coletti, G., Fedrizzi, M., Matarazzo, B., Yager, R.R. (eds.) IPMU 2012, Part I. CCIS, vol. 297, pp. 420–429. Springer, Heidelberg (2012)CrossRefGoogle Scholar
  18. 18.
    Pons, J.E., Marín, N., Pons Capote, O., Billiet, C., de Tre, G.: A relational model for the possibilistic valid-time approach. International Journal of Computational Intelligence Systems 5(6), 1068–1088 (2012)CrossRefGoogle Scholar
  19. 19.
    Pons, J.E., Pons Capote, O., Blanco Medina, I.: A fuzzy valid-time model for relational databases within the hibernate framework. In: Christiansen, H., De Tré, G., Yazici, A., Zadrozny, S., Andreasen, T., Larsen, H.L. (eds.) FQAS 2011. LNCS, vol. 7022, pp. 424–435. Springer, Heidelberg (2011)CrossRefGoogle Scholar
  20. 20.
    Prade, H., Testemale, C.: Generalizing database relational algebra for the treatment of incomplete or uncertain information and vague queries. Information Sciences 34(2), 115–143 (1984)MathSciNetzbMATHCrossRefGoogle Scholar
  21. 21.
    Snodgrass, R.: The temporal query language tquel. In: Proceedings of the 3rd ACM SIGACT-SIGMOD, pp. 204–213. ACM, New York (1984)Google Scholar
  22. 22.
    Umano, M., Fukami, S.: Retrieval processing from fuzzy databases. Technical Reports of IECE of Japan 80(204), 45–54 (1980)Google Scholar
  23. 23.
    Zemankova-Leech, M., Kandel, A.: Fuzzy relational databases - a key to expert systems. Journal of the American Society for Information Science 37, 272–273 (1984)Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2013

Authors and Affiliations

  • Carlos D. Barranco
    • 1
  • Juan Miguel Medina
    • 2
  • José Enrique Pons
    • 2
  • Olga Pons
    • 2
  1. 1.Division of Computer Science, School of EngineeringPablo de Olavide UniversitySevilleSpain
  2. 2.Department of Computer Science and Artificial IntelligenceUniversity of GranadaGranadaSpain

Personalised recommendations