On the issue of valid time(s) in temporal databases

ABSTRACT

Recent research activities in the area of Temporal Databases have revealed some problems related to the definition of time. In this paper we discuss the problem arising from the definition of valid time and the assumptions about valid time, which exist in current Temporal Database approaches. For this problem we propose a solution, while we identify some consistency problems that may appear in Temporal Databases, and which require further investigation.

REFERENCES

• 1: [1] I. Ahn, SQL+T: A Temporal Query Language. in Proceedings of the International Workshop on an Infrastructure for Temporal Databases, Arlington, TX, June 1993.
• 2: [2] E.V. Ioannidis, C.D. Spyropoulos et al, TIMERx: a Kernel for Managing Temporal Reference in a RDBMS. Working Paper, N.C.S.R. "Demokritos" Aghia Paraskevi, Greece, 1994.
• 3: [3] C.S. Jensen et al, A Consensus Glossary of Temporal Database Concepts. Technical Report R 93-2035, Aalborg University, Nov. 1993.
• 4: Stavros Kokkotos , Constantine D. Spyropoulos, A Framework for Developing Temporal Databases, Proceedings of the 5th International Conference on Database and Expert Systems Applications, p.236-245, September 07-09, 1994
• 5: [5] N.A. Lorentzos and Y.G. Mitsopoulos, IXSQL: An Interval Extension to SQL. in Proceediogs of the International Workshop on an Infrastructure for Temporal Databases, Arlington, TX, June 1993.
• 6: L. Edwin McKenzie, Jr. , Richard Thomas Snodgrass, Evaluation of relational algebras incorporating the time dimension in databases, ACM Computing Surveys (CSUR), v.23 n.4, p.501-543, Dec. 1991 [doi>10.1145/125137.125166]
• 7: [7] N. Pissinou, R. Snodgrass et al, Towards an Infrastructure for Temporal Databases, Report of an Invitational ARPA/NSF Workshop. Technical Report 94-01, University of Arizona, Tucson, AZ, Mar. 1994.
• 8: Niki Pissinou , Richard Thomas Snodgrass , Ramez Elmasri , Inderpal S. Mumick , Tamer Özsu , Barbara Pernici , Arie Segev , Babis Theodoulidis , Umeshwar Dayal, Towards an infrastructure for temporal databases: report of an invitational ARPA/NSF workshop, ACM SIGMOD Record, v.23 n.1, p.35-51, March 1994 [doi>10.1145/181550.181557]
• 9: Richard Snodgrass , Ilsoo Ahn, A taxonomy of time databases, Proceedings of the 1985 ACM SIGMOD international conference on Management of data, p.236-246, May 1985, Austin, Texas, United States
• 10: Richard Snodgrass , Ilsoo Ahn, Temporal Databases, Computer, v.19 n.9, p.35-42, September 1986 [doi>10.1109/MC.1986.1663327]
• 11: [11] R. Snodgrass, An Overview of TQUEL. Chapter 6, Temporal Databases: Theory, Design and Implementation, Benjamin/Cummings, 1993, 141-182.

INDEX TERMS

Primary Classification:
  H. Information Systems
  H.2 DATABASE MANAGEMENT

General Terms:
Design, Management, Measurement, Theory