FUZZY TIME MANIPULATION IN A RELATIONAL DB

N. Marín, J. M. Medina, O. Pons, M. C. Garrido

Abstract

Temporal Databases (TDB) have as a primary aim to offer a common framework to those DB applications that need to store or handle temporal data of different nature or source, since they allow to unify the concept of time from the point of view of its meaning, its representation and its manipulation. Up to now, most of the efforts have been devoted to extend the relational model in order to be adapted to the new way of inserting, deleting and updating the DB, together with the integrity constraints involved. In this paper we deal with these problems when the time is imprecisely expressed by means of a fuzzy interval of dates. Along the text, we will see how the delete and the insert operations can be carried out and how different types of queries to such a fuzzy temporal database are solved.

References

  1. C. Bettini, X. Wang, S. Jajodia. A general framework for time granularities and its application to temporal reasoning. Annals of Mathematics and Artificial Intelligence, vol. 22, pp.29-58. (1998)
  2. R. de Caluwe, G. de Tr, G. Bordogna. (Eds.) SpatioTemporal Databases Flexible Querying and Reasoning. ISBN: 978-3-540-22214-9 (2004).
  3. P. Chountas, I. Petrounias Modeling and Representation of Uncertain Temporal Information. Requirements Eng. 5, pp. 144-156 (2005).
  4. Dubois D., Prade H. Fuzzy Numbers. An Overview. The Analysis of Fuzzy Information. Bezdek Ed. CRS Press, Boca Raton. (1985)
  5. R. Elmarsi, G. T. Wuu A Temporal Model and Query Language for ER Databases. (1990)
  6. O. Etzion, S.Jajodia, S. Sripada (Eds.) Temporal Databases; Research and Practice. Lecture Notes in Computer Science, vol. 1399. Springer. (1998).
  7. J. Galindo, J. M. Medina, O. Pons, J. C. Cubero A Server for Fuzzy SQL Queries. T. Andreasen, H. Christiansen, and H.L. Larsen (Eds.). FQAS'98, LNAI 1495, pp. 164-174. (1998).
  8. J. Galindo, A. Urrutia, M. Piattini Fuzzy Databases: Modeling, Design and Implementation. Idea Group Publishing, Hershey, USA. (2006).
  9. Goguen, J. A. L-Fuzzy Sets. Journ. of Math. Anal. and Applications, vol. 18, pp. 145-174. (1967)
  10. J. M. Medina, O. Pons, M. A. Vila GEFRED: A Generalized Model of Fuzzy Relational Databases. Information Sciences, vol. 76, pp. 87-109.(1994)
  11. J. M. Medina, J. C. Cubero, O. Pons, M. A. Vila Towards the Implementation of a Generalized Fuzzy Relational Database Model. Fuzzy Sets and Systems, vol. 75, pp. 273-289. (1995)
  12. R. T. Snodgrass (ed.), I Ahn, G. Ariav, D. S. Batory, et. Al The TSQL2 temporal query language. Kluwer Academic (1995).
  13. A. Tansel, J. Clifford, S. Gadia. Temporal Databases: Theory, Design and Implementation. Bejamin Cummings (1993).
  14. B. Van der Cruyssen, R. de Caluwe, G. de Tre. A Theoretical Time Model for Dealing with Crisp and Fuzzy Time. Proceeings of NAFIPS. (1997).
Download


Paper Citation


in Harvard Style

Marín N., M. Medina J., Pons O. and C. Garrido M. (2008). FUZZY TIME MANIPULATION IN A RELATIONAL DB . In Proceedings of the Third International Conference on Software and Data Technologies - Volume 3: ICSOFT, ISBN 978-989-8111-53-1, pages 91-97. DOI: 10.5220/0001870200910097


in Bibtex Style

@conference{icsoft08,
author={N. Marín and J. M. Medina and O. Pons and M. C. Garrido},
title={FUZZY TIME MANIPULATION IN A RELATIONAL DB},
booktitle={Proceedings of the Third International Conference on Software and Data Technologies - Volume 3: ICSOFT,},
year={2008},
pages={91-97},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0001870200910097},
isbn={978-989-8111-53-1},
}


in EndNote Style

TY - CONF
JO - Proceedings of the Third International Conference on Software and Data Technologies - Volume 3: ICSOFT,
TI - FUZZY TIME MANIPULATION IN A RELATIONAL DB
SN - 978-989-8111-53-1
AU - Marín N.
AU - M. Medina J.
AU - Pons O.
AU - C. Garrido M.
PY - 2008
SP - 91
EP - 97
DO - 10.5220/0001870200910097