Abstract
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.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Allen, J.F.: Maintaining knowledge about temporal intervals. Commun. ACM 26, 832–843 (1983)
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)
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)
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)
Dubois, D., Prade, H.: Processing fuzzy temporal knowledge. IEEE Transactions on Systems, Man and Cybernetics 19(4), 729–744 (1989)
Dyreson, C., et al.: A consensus glossary of temporal database concepts. SIGMOD Rec. 23, 52–64 (1994)
Fliegel, H.F., van Flandern, T.C.: Letters to the editor: a machine algorithm for processing calendar dates. Commun. ACM 11, 657 (1968)
Galindo, J., Medina, J.: Ftsql2: Fuzzy time in relational databases. In: Proceedings EUSFLAT 2001, pp. 47–50 (2001)
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)
Galindo, J., Urrutia, A., Piattini, M.: Fuzzy Databases: Modeling, Design and Implementation. Idea Group, Chocolate Avenue, Suite 200, Hershey PA 17033 (2006)
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)
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)
King, G., Bauer, C., Andersen, M.R., Bernard, E., Ebersole, S., Ferentschik, H.: Hibernate Reference Documentation, 3.6.0.cr2 edn., http://www.hibernate.org/docs
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)
Rowe, L., Stonebreker, M.: The postgres papers (June 1987)
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)
Medina, J., Pons, O., Cubero, J.: Gefred. a generalized model of fuzzy relational databases. Information Sciences 76(1-2), 87–109 (1994)
Melton, J., Simon, A.R.: Understanding the new SQL: a complete guide. Morgan Kaufmann Publishers Inc., San Francisco (1993)
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)
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)
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)
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)
Schockaert, S., De Cock, M., Kerre, E.: Fuzzifying allen’s temporal interval relations. IEEE Transactions on Fuzzy Systems 16(2), 517–533 (2008)
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)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2011 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Pons, J.E., Pons Capote, O., Blanco Medina, I. (2011). 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) Flexible Query Answering Systems. FQAS 2011. Lecture Notes in Computer Science(), vol 7022. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-24764-4_37
Download citation
DOI: https://doi.org/10.1007/978-3-642-24764-4_37
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-24763-7
Online ISBN: 978-3-642-24764-4
eBook Packages: Computer ScienceComputer Science (R0)