Abstract
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.
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.
Similar content being viewed by others
References
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)
Buckles, B.P., Petry, F.E.: A fuzzy representation of data for relational databases. Fuzzy Sets and Systems 7(3), 213–226 (1982)
Codd, E.F.: Extending the database relational model to capture more meaning. ACM Transactions on Database Systems 4, 397–434 (1979)
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)
Dubois, D., Prade, H.: Possibility Theory: An Approach to Computerized Processing of Uncertainty. Plenum Press, New York (1988)
Dubois, D., Prade, H.: Processing fuzzy temporal knowledge. IEEE Transactions on Systems, Man, and Cybernetics 19, 729–744 (1989)
Dyreson, C., Grandi, F.E.A.: A consensus glossary of temporal database concepts. SIGMOD Rec. 23, 52–64 (1994)
Galindo, J., Medina, J.M.: Ftsql2: Fuzzy time in relational databases. In: EUSFLAT Conf. 2001, pp. 47–50 (2001)
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)
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)
Kurutach, W.: Modelling fuzzy interval-based temporal information: a temporal database perspective. Fuzzy Systems 2, 741–748 (1995)
Medina, J., Pons, O., Cubero, J.: GEFRED. a generalized model of fuzzy relational databases. Information Sciences 76, 87–109 (1994)
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)
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)
Oracle: Oracle database 11g. workspace manager overview (2012)
Oracle: Sql language reference. In: Oracle Database v. 11.2. Documentation, pp. 1–1522 (July 2012), http://docs.oracle.com/cd/E11882_01/server.112/e26088.pdf
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)
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)
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)
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)
Snodgrass, R.: The temporal query language tquel. In: Proceedings of the 3rd ACM SIGACT-SIGMOD, pp. 204–213. ACM, New York (1984)
Umano, M., Fukami, S.: Retrieval processing from fuzzy databases. Technical Reports of IECE of Japan 80(204), 45–54 (1980)
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)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2013 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Barranco, C.D., Medina, J.M., Pons, J.E., Pons, O. (2013). Building a Fuzzy Valid Time Support Module on a Fuzzy Object-Relational Database. In: Larsen, H.L., Martin-Bautista, M.J., Vila, M.A., Andreasen, T., Christiansen, H. (eds) Flexible Query Answering Systems. FQAS 2013. Lecture Notes in Computer Science(), vol 8132. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-40769-7_39
Download citation
DOI: https://doi.org/10.1007/978-3-642-40769-7_39
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-40768-0
Online ISBN: 978-3-642-40769-7
eBook Packages: Computer ScienceComputer Science (R0)