This Article 
 Bibliographic References 
 Add to: 
Temporal Data Management
January/February 1999 (vol. 11 no. 1)
pp. 36-44

Abstract—A wide range of database applications manage time-varying information. Existing database technology currently provides little support for managing such data. The research area of temporal databases has made important contributions in characterizing the semantics of such information and in providing expressive and efficient means to model, store, and query temporal data. This paper introduces the reader to temporal data management, surveys state-of-the-art solutions to challenging aspects of temporal data management, and points to research directions.

[1] M.H. Böhlen, “Temporal Database System Implementations,” ACM SIGMOD Record, vol. 24, no. 4, pp. 53–60, 1995.
[2] Recent Advances in Temporal Databases: Proc. Int'l Workshop Temporal Databases," J. Clifford and A. Tuzhilin, eds., Workshops in Computing Series, Springer-Verlag, 1995.
[3] Temporal Databases: Research and Practice, O. Etzion, S. Jajodia, and S. Sripada, eds., Lecture Notes in Computer Science 1399, Springer-Verlag, 1998.
[4] S.K. Gadia and G. Bargava, "SQL-Like Seamless Query of Temporal Data," in [15].
[5] H. Gregersen and C.S. Jensen, "Temporal Entity-Relationship Models—A Survey," IEEE Trans. Knowledge and Data Eng., to appear.
[6] H. Gunadhi and A. Segev, "A Framework for Query Optimization in Temporal Databases," Proc. Fifth Conf. Statistical and Sci-entific and Databases Management, pp. 131-147,Charlotte, N.C., Apr. 1990.
[7] W.H. Inmon, Building the Data Warehouse, John Wiley and Sons, 1992.
[8] A Consensus Glossary of Temporal Database Concepts—Feb. 1998 Version, C.S. Jensen and C.E. Dyreson, eds., pp. 367-405, in [3].
[9] C.S. Jensen and R.T. Snodgrass, “Semantics of Time-Varying Information,” Information Systems, vol. 21, no. 4, pp. 311-352, 1996.
[10] J. Melton and A.R. Simon, Understanding the New SQL: A Complete Guide, Morgan Kaufmann, San Francisco, 1993.
[11] SQL/Temporal, J. Melton, ed., ISO/IEC JTC 1/SC 21/WG 3 DBL-MCI-0012, July 1996.
[12] G. Özsoyovglu and R.T. Snodgrass, “Temporal and Real-Time Databases: A Survey,” IEEE Trans. Knowledge and Data Eng., vol. 7, no. 4, pp. 513–532, 1995.
[13] J.F. Roddick and J.D. Patrick,“Temporal semantics in information systems—a survey,” Information Systems, vol. 17, no. 3, pp. 249-267, 1992.
[14] B. Salzberg and V.J. Tsotras, "A Comparison of Access Methods for Time Evolving Data," ACM Computing Surveys, to appear.
[15] Proc. Int'l Workshop Infrastructure for Temporal Databases, R.T. Snodgrass, ed., Arlington, Texas, June 1993.
[16] I. Ahn, G. Ariav, D. Batory, J. Clifford, C.E. Dyreson, R. Elmasri, F. Grandi, C.S. Jensen, W. Käfer, N. Kline, K. Kulkarni, T.Y. Leung, N. Lorentzos, J.F. Roddick, A. Segev, M.D. Soo, and S.M. Sripada, The TSQL2 Temporal Query Language, R.T. Snodgrass, ed., Kluwer, 1995; URL:
[17] R.T. Snodgrass, M.H. Böhlen, C.S. Jensen, and A. Steiner, Adding Valid Time to SQL/Temporal, ANSI X3H2-96-501r2, ISO/IEC JTC 1/SC 21/WG 3 DBL-MAD-146r2, Nov. 1996.
[18] R.T. Snodgrass, "Temporal Databases," Advanced Database Systems, Part II, Morgan Kaufmann, 1997.
[19] Temporal Databases: Theory, Design, and Implementation, A. Tansel, J. Clifford, S. Gadia, S. Jajodia, A. Segev, and R.T. Snodgrass, eds., Benjamin/Cummings, 1994.
[20] V.J. Tsotras and X.S. Wang, "Temporal Databases," Encyclopedia of Electrical and Electronics Eng., John Wiley and Sons, 1999.
[21] X. Wang, C. Bettini, A. Brodsky, and S. Jajodia, "Logical Design for Temporal Databases with Multiple Granularities," ACM Trans. Database Systems, to appear, 1997.
[22] J. Wijsen, "Temporal FDs on Complex Objects," ACM Trans. Database Systems, vol. 23, no. 4, Dec. 1998, to appear.
[23] Y. Wu, S. Jajodia, and X.S. Wang, "Temporal Database Bibliography Update," pp. 338-366, in [3].

Index Terms:
Query language, SQL, temporal database, temporal data model, time-constrained database, transaction time, TSQL2, user-defined time, valid time.
Christian S. Jensen, Richard T. Snodgrass, "Temporal Data Management," IEEE Transactions on Knowledge and Data Engineering, vol. 11, no. 1, pp. 36-44, Jan.-Feb. 1999, doi:10.1109/69.755613
Usage of this product signifies your acceptance of the Terms of Use.