A Temporal Relational Database:Modeling and Language

  • Published : 1995.08.01

Abstract

A temporal database systems provides timing information and maintains history of data compared to the conventional database system. In this paper, we present a temporal relational database which use an interval-stamping method for instant-based events and for interval-based states. A set of temporal algebraic operators are developed on an instance of time and interval of time so that we can manipulate events and states at a same time. The set of operation is the basis for creating a relational algebra that is closed for temporal relations. And temporal SQL is also suggested as a temporal query relational language for our algebraic operations on temporal relations.

Keywords

References

  1. Communication of ACM v.26 Maintaining knowledge about temporal intervals Allen,J.F.
  2. Proceedings of the ACM SIGMOD Conference On an algebra for historical databases: Two views Clifford,J.;A.U.Tansel
  3. Methodologies for Intelligent System v.3 Dealing with time in diagnostic reasoning based on causal models Console,L.;A.Furno;P.Torasso;Ras,Z.W.(ed.);Saitta,L.(ed.)
  4. Proceedings of the Sixteeth Annual SCAMC An extend SQL for temporal data management in clinical decision-support systems Das,A.K.;S.W.Tu;G.P.Purcell;M.A.Musen
  5. Artificial Intelligence v.49 Temporal constraint networks Dechter,R.;Meiri,I.;J.Pearl
  6. Information Sciences v.54 Inadequacy of interval timestamps in temporal databases Gadia,S.K.;C.S.Yeung
  7. Information Systems v.19 Database Models for Infinite and Indefinite Temporal Information Koubarakis,M.
  8. DATABASE v.25 Temporal Database : Model Design and Commercialization Prospects Lai,V.S.;J.P.Kuiboer;J.L.Guynes
  9. Information System v.13 Extending relational algebra to manipulate temporal data Lorentzos,N.;R.Johnson
  10. IEEE Trans. on Knowledge and Data Eng. v.3 Temporal da a management systems: A comparative view Maiocchi,R;B.Pernici
  11. ACM Computing Survey v.23 Evaluation of relational algeba incorporating the time dimension in databases McKenzie,L.E.;R.T.Snodgrass
  12. Information Sciences v.49 A temporal relational model and a query language Navathe,S.B.;R.Ahmed
  13. Informaton Systems v.17 Temporal Semantics in Information Systems-A Survey Roddick,J.F.;J.D.Patrick
  14. IEEE Trans. on Knowledge and Data Eng v.2 Extensions to SQL for historical databases Sarda,N.L.
  15. Lecture Notes in Computer Science v.339 The representation of a temporal data model in the relational environment Segev,A.;A.Shoshani
  16. Artifical Intelligence v.33 Temporal logic in AI: Semaotical and ontological considerations Shoham,Y.
  17. IEEE Computer v.19 Temporal database Snodgrass,R.;I.Ahn
  18. Principles of Database and Knowledge-Base System v.1 Ulman,J.D.
  19. Lecture Notes in Computer Science v.398 Dealing with granularity of time in temporal databases Wiederhold,G.;S.Jajodia;W.Litwin
  20. Semantic Database Design Wiederhold,G.