Temporal databases: From theory to applications

  • B. A. NovikovEmail author
  • E. A. Gorshkova


Problems concerning the date and time representation in databases are well studied in scientific literature. Temporal databases are required in many applications including the conventional applications of DBMSs such as financial systems. However, commercial systems and standards for the query language do not support temporal data features. A simple and efficient approach for implementing temporal capabilities over conventional commercial DBMSs is proposed and various aspects of its practical applications are described.


Basic Schema Integrity Constraint Business Logic Query Execution Valid Time 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


  1. 1.
    Findler, N. and Chen, D., On the Problems of Time Retrieval, Temporal Relations, Causality, and Coexistence, Proc. Second Int. Joint Conf. on Artificial Intelligence, London, 1971.Google Scholar
  2. 2.
    Soo, M.D., Temporal Database Bibliography Update, SIGMOD Rec., 1995, vol. 25, no. 1, pp. 14–23.MathSciNetGoogle Scholar
  3. 3.
    Bubenko, J.A., Jr., The Temporal Dimension in Information Modelling, Working Conference on Architecture and Models in Data Base Management Systems, Nijssen, G. M., Ed., Nice: North-Holland, 1977, pp. 93–118.Google Scholar
  4. 4.
    Abbod, T., Brown, K., and Noble, H., Providing Time-Related Constraints for Conventional Database Systems, Proc. of the 13th International Conference on Very Large Data Bases, Hammersley, P., Ed., San Francisco: Morgan Kaufmann, 1987, pp. 167–175.Google Scholar
  5. 5.
    Ahn, I., Towards an Implementation of Database Management Systems with Temporal Support, in Proc. of the Int. Conf. on Data Engineering, Los Angeles: IEEE Computer Society, 1986, pp. 374–381.Google Scholar
  6. 6.
    Ahn, I. and Snodgrass, R., Partitioned Storage for Temporal Databases, Inf. Syst., 1988, vol. 13, no. 4, pp. 369–391.CrossRefzbMATHGoogle Scholar
  7. 7.
    Ariav, G. and Clifford, J., A System Architecture for Temporally Oriented Data Management, Proc. of the Fifth Int. Conf. on Information Systems, Tuscon, Arizona, 1984, pp. 177–186.Google Scholar
  8. 8.
    Dadam, P. and Teuhola, J., Managing Schema Versions in a Time-Versioned Non-First-Normal-Form Relational Database, Technical Report TR 87.01.001, Heidelberg Scientific Center IBM, 1987.Google Scholar
  9. 9.
    Dyreson, C.E., Snodgrass, R.T., and Jensen, C.S., On the Semantics of “Now” in Temporal Databases, TempIS Technical Report no. 42, Computer Science Department, University of Arizona, Tuscon, 1993.Google Scholar
  10. 10.
    Grandi, F., Scalas, M. R., and Tiberio, P.A., A History-Oriented Data View and Operation Semantics for Temporal Relational Databases, Proc. of the Int. Workshop on an Infrastructure for Temporal Databases, R. T. Snodgrass, Ed., Arlington, Texas, 1993.Google Scholar
  11. 11.
    Hsu, S. H., Page and Tuple Level Storage Structures for Historical Databases, TempIS Technical Report no. 34, Computer Science Department, University of Arizona, Tuscon, 1992.Google Scholar
  12. 12.
    Androutsopolous, I., Ritchie, G.D., and Thanisch, P., Experience Using TSQL2 in a Natural Language Interface, in Recent Advances in Temporal Databases, Clifford, S. and Tuzhilin, A., Eds., Zurich: Springer, 1995, pp. 113–132.Google Scholar
  13. 13.
    Bohlen, M.H., Jensen, C.S., and Snodgrass, R.T., Evaluating the Completeness of TSQL2, in Recent Advances in Temporal Databases, Clifford, S. and Tuzhilin, A., Eds., Zurich: Springer, 1995, pp. 153–174.Google Scholar
  14. 14.
    Date, C.J., Darwen, H., and Lorentzos, N., Temporal Data & the Relational Model, San-Francisco: Morgan Kaufmann, 2002.Google Scholar

Copyright information

© Pleiades Publishing, Ltd. 2008

Authors and Affiliations

  1. 1.St. Petersburg State UniversitySt. PetersburgRussia

Personalised recommendations