Stavros Kokkotos
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.
- [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.Google Scholar
- [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.Google Scholar
- [3] C.S. Jensen et al, A Consensus Glossary of Temporal Database Concepts. Technical Report R 93-2035, Aalborg University, Nov. 1993.Google Scholar
- [4] S. Kokkotos and C.D. Spyropoulos, A Framework for Developing Temporal Databases. in Proceedings of the DEXA '94 International Conference, Athens, Greece, Sep. 1994, Lecture Notes in Computer Science 856, Springer-Verlag, Berlin, 1994, 236-245. Google ScholarDigital Library
- [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.Google Scholar
- [6] E. McKenzie and R. Snodgrass, An Evaluation of Relational Algebras Incorporating the Time Dimension in Databases. ACM Computing Surveys 23(4), Dec. 1991, 501-543. Google ScholarDigital Library
- [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.Google Scholar
- [8] N. Pissinou, R. Snodgrass et al, Towards an Infrastructure for Temporal Databases, Report of an Invitational ARPA/NSF Workshop. SIGMOD RECORD, 23(1), Mar. 1994, 35-51. Google ScholarDigital Library
- [9] R. Snodgrass and I. Ahn, A Taxonomy of Time in Databases. in Proceedings of the ACM International Conference on Management of Data, Austin, TX, May 1985, 236-246. Google ScholarDigital Library
- [10] R. Snodgrass and I. Ahn, Temporal Databases. IEEE Computer 19(9), Sep. 1986, 35-42. Google ScholarDigital Library
- [11] R. Snodgrass, An Overview of TQUEL. Chapter 6, Temporal Databases: Theory, Design and Implementation, Benjamin/Cummings, 1993, 141-182.Google Scholar
Index Terms
- On the issue of valid time(s) in temporal databases
Recommendations
Temporal and Real-Time Databases: A Survey
A temporal database contains time-varying data. In a real-time database transactions have deadlines or timing constraints. In this paper we review the substantial research in these two previously separate areas. First we characterize the time domain; ...
Valid-Time Indeterminacy in Temporal Relational Databases: A Family of Data Models
TIME '10: Proceedings of the 2010 17th International Symposium on Temporal Representation and ReasoningValid-time indeterminacy concerns not knowing exactly when a fact holds in the modeled reality. In this paper, we first propose a reference approach (data model and algebra) in which all possible temporal scenarios induced by valid-time indeterminacy ...
Transformation of Relational Databases to Transaction-Time Temporal Databases
ECBS-EERC '11: Proceedings of the 2011 Second Eastern European Regional Conference on the Engineering of Computer Based SystemsIn recent years, versioning has emerged as a very popular operating system feature for file systems. Some of these systems can provide user friendly â go back in timeâ feature, where the user can see exactly how file system looked on the dates he ...
Comments