Temporal database tables transitions between event model and state model

Aleksandra Werner


The fundamental concepts of temporal data models and the possibilities and reasons of title conversion are contained in this paper. Additionally the model influence to the time of executing sample queries is presented in this article. All tests were made on sample real-world hospital database.


temporal database; event model; state model; HOSPITAL database

Full Text:

PDF (Polski)


Bair J.: It’s about Time! Supporting Temporal Data in a warehouse. InfoDB, Vol. 10, No 1, 1997, http://www.dbaint.com/InfoDBDW.html

Beynon-Davies P.: Systemy baz danych. WNT, Warszawa 1998.

Chomicki J., Toman D.: Temporal Logic in Information Systems. Basic Research in Computer Science, 1997, http://www.brics.dk/LS/97/1/

Pissinou N., Snodgrass R.T., Elmasri R.: Towards an infrastructure for temporal databases. Report of an International ARPA/NSF Workshop, Arlington, Texas 1993.

Snodgrass R.T., Ahn I.: A Taxonomy of Time in Databases, ACM 0-89791-160-1/85/005/0236, 1985.

Steiner A.P: A Generalization Approach to Temporal Data Models and their Implementations, Informatik Dept. Zurich 1998, http://www.timeconsult.com

Tsichritzis D.C., Lochovsky F.H.: Modele danych. WNT, Warszawa 1990.

Tsotras V.J., Jensen C.S.: A Notation for Spatiotemporal Queries. TimeCenter Technical Report TR-10, 1997, http://www.cs.auc.dk/TimeCenter/

Ullman J.D., Widom J.: Podstawowy wykład z systemów baz danych, WNT, Warszawa 2000.

Werner A.: Semantyka danych temporalnych i zapytań. Konferencja SCR, Ustroń, 2002.

DOI: http://dx.doi.org/10.21936/si2004_v25.n3.609